Changeset 26338


Ignore:
Timestamp:
06/12/10 20:43:03 (7 years ago)
Author:
rambo
Message:

reorganize the schema so the fields are in more logical order

File:
1 edited

Legend:

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

    r26336 r26338  
    1818        </property>
    1919
    20         <property name="media" type="string" dbtype="varchar(20)" index="true">
    21             <description>
    22                 String identifier for media. Suggested to use standard english abbreviations (lowercased) like: cd, dvd, bd. Or lowercase english
    23                 words like: softcover, hardcover. Since the schema defined context for the media it's not neccessary to be fully explicit
    24                 like: "book: hardcover", "record: LP".
    25 
    26                 Limited to 20 characters which should be plenty. Indexed.
    27             </description>
    28         </property>
    29 
    3020        <property name="barcode" type="string" dbtype="varchar(30)" index="true">
    3121            <description>
     
    4131        </property>
    4232
    43         <property name="isxn" type="string" dbtype="varchar(35)" index="true">
     33        <property name="media" type="string" dbtype="varchar(20)" index="true">
    4434            <description>
    45                 ISBN, ISSN, ISAN or somesuch International Standard Number. Limited to 35 characters which should be plenty even for ISAN (33 in human readable form). Indexed.
    46             </description>
    47         </property>
     35                String identifier for media. Suggested to use standard english abbreviations (lowercased) like: cd, dvd, bd. Or lowercase english
     36                words like: softcover, hardcover. Since the schema defined context for the media it's not neccessary to be fully explicit
     37                like: "book: hardcover", "record: LP".
    4838
    49         <property name="xxdb" type="string" dbtype="varchar(15)" index="true">
    50             <description>
    51                 IMDb, CDDB or some such internet database identifier. Limited to 15 characters which should be plenty. Indexed.
    52             </description>
    53         </property>
    54 
    55         <property name="asin" type="string" dbtype="varchar(10)" index="true">
    56             <description>
    57                 ASIN (http://en.wikipedia.org/wiki/Amazon_Standard_Identification_Number). Limited to 10 characters. Indexed.
    58             </description>
    59         </property>
    60 
    61         <property name="ddc" type="string" dbtype="varchar(10)" index="true">
    62             <description>
    63                 Dewey Decimal Classification. Limited to 10 characters. Indexed.
     39                Limited to 20 characters which should be plenty. Indexed.
    6440            </description>
    6541        </property>
     
    7349        </property>
    7450
    75         <property name="extcode2" type="string" dbtype="varchar(15)" index="true">
     51        <property name="ddc" type="string" dbtype="varchar(10)" index="true">
    7652            <description>
    77                 Generic External service identifier. Limited to 15 characters which should be plenty. Indexed.
    78             </description>
    79         </property>
    80 
    81         <property name="extcode3" type="string" dbtype="varchar(15)" index="true">
    82             <description>
    83                 Generic External service identifier, another slot. Limited to 15 characters which should be plenty. Indexed.
    84             </description>
    85         </property>
    86 
    87         <property name="uri" type="string">
    88             <description>
    89                 External full uri, just in case it's needed
     53                Dewey Decimal Classification (you could also figure out your own classification). Limited to 10 characters. Indexed.
    9054            </description>
    9155        </property>
     
    10973                More info regarding the status, basically free text for example for the name and phone number
    11074                of whoever loaned the item.
     75            </description>
     76        </property>
     77
     78        <property name="asin" type="string" dbtype="varchar(10)" index="true">
     79            <description>
     80                ASIN (http://en.wikipedia.org/wiki/Amazon_Standard_Identification_Number). Limited to 10 characters. Indexed.
     81            </description>
     82        </property>
     83
     84        <property name="isxn" type="string" dbtype="varchar(35)" index="true">
     85            <description>
     86                ISBN, ISSN, ISAN or somesuch International Standard Number. Limited to 35 characters which should be plenty even for ISAN (33 in human readable form). Indexed.
     87            </description>
     88        </property>
     89
     90        <property name="xxdb" type="string" dbtype="varchar(15)" index="true">
     91            <description>
     92                IMDb, CDDB or some such internet database identifier. Limited to 15 characters which should be plenty. Indexed.
     93            </description>
     94        </property>
     95
     96        <property name="extcode2" type="string" dbtype="varchar(15)" index="true">
     97            <description>
     98                Generic External service identifier. Limited to 15 characters which should be plenty. Indexed.
     99            </description>
     100        </property>
     101
     102        <property name="extcode3" type="string" dbtype="varchar(15)" index="true">
     103            <description>
     104                Generic External service identifier, another slot. Limited to 15 characters which should be plenty. Indexed.
     105            </description>
     106        </property>
     107
     108        <property name="uri" type="string">
     109            <description>
     110                External full uri, just in case it's needed
    111111            </description>
    112112        </property>
Note: See TracChangeset for help on using the changeset viewer.