[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-developers] proposal-branch; db-manipulation
From: |
sigurdne |
Subject: |
[Phpgroupware-developers] proposal-branch; db-manipulation |
Date: |
Tue, 4 May 2004 12:56:34 +0200 |
I have added some database manipulation functions in property:
CreateTable
AddColumn
DropColumn
DropTable
AlterColumn (dont preserve data in column)
Might be something for the api?
Try it out in property->admin->Admin Location
(Each level in the hierarchy has it owns table - named as location<level> -
and is referencing its parent table by foreign keys. Each level is also
referencing a category-table - which is named fm_location<level>_category)
OR
property->admin->Admin entity
(Similar to the "location" - entities has their own tables - but in this case
the entities are separated by type and category - as entity_<type>_<category>)
Location is a physical part of the property - it is common to organise the
locations in a hierachical structure with "part-of" relations
<example>
Name Level
-- Property 1
/-- Building 2
/-- Entrance 3
/-- Apartment 4
/-- Room 5
</example>
Entities is a generic class of objects that all have in common that they can
be placed in a location and/or linked to other (only one) entities.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-developers] proposal-branch; db-manipulation,
sigurdne <=