Changeset 26334


Ignore:
Timestamp:
06/12/10 17:46:06 (7 years ago)
Author:
rambo
Message:

add the entity and entity_link objects so I do not forget about them when the time comes to handle such metadata like authors, bands etc

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/ragnaroek/midcom/net.hurttakallio.library/config/mgdschema.xml

    r26332 r26334  
    105105
    106106    </type>
     107    <type name="net_hurttakallio_library_entity" table="net_hurttakallio_library_entity">
     108        <property name="id" type="unsigned integer" primaryfield="id" />
     109
     110        <property name="up" type="unsigned integer" link="net_hurttakallio_library_entity:id" upfield="up">
     111            <description>
     112                Use to link an entity to another entity in hierarchical manner (members of a band of something)
     113                See also the n-n net_hurttakallio_library_entity_link -object
     114            </description>
     115        </property>
     116
     117        <property name="dm2schemaname" type="string" dbtype="varchar(15)" index="true">
     118            <description>
     119                Copy of the schema name parameter, for more efficient querying and to provide context. Limited to 15 characters which should be plenty. Indexed.
     120            </description>
     121        </property>
     122
     123        <property name="title" type="string">
     124            <description>
     125                Title of the entity (name of person/band).
     126            </description>
     127        </property>
     128
     129        <property name="description" type="text">
     130            <description>
     131                Full text field for description or whatever, usually contains HTML.
     132            </description>
     133        </property>
     134    </type>
     135
     136    <type name="net_hurttakallio_library_entity_link" table="net_hurttakallio_library_entity_link">
     137        <property name="id" type="unsigned integer" primaryfield="id" />
     138        <property name="entity" type="unsigned integer" link="net_hurttakallio_library_entity:id">
     139            <description>
     140                The entity to link TO (in any case)
     141            </description>
     142        </property>
     143       
     144        <property name="item" type="unsigned integer" link="net_hurttakallio_library_item:id">
     145            <description>
     146                In case of item->entity links the item to link FROM
     147            </description>
     148        </property>
     149       
     150        <property name="fromentity" type="unsigned integer" link="net_hurttakallio_library_entity:id">
     151            <description>
     152                In case of entity->entity links the entity to link FROM
     153            </description>
     154        </property>
     155    </type>
     156
    107157</Schema>
Note: See TracChangeset for help on using the changeset viewer.