SchemaSpy - Table ..\\db\\trunk\\zotero.sqlite.zotero.customItemTypeFields

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

customItemTypeID

integer

11,10

customItemTypes.customItemTypeID

FK_customItemTypeFields_customItemTypes_customItemTypeID R

fieldID

integer

11,10

√

null

fields.fieldID

FK_customItemTypeFields_fields_fieldID R

customFieldID

integer

11,10

√

null

customFields.customFieldID

FK_customItemTypeFields_customFields_customFieldID R

hide

integer

11,10

orderIndex

integer

11,10

Table contained 0 rows at jeu. oct. 21 19:16 CEST 2010

Indexes:

Column(s)	Type	Sort	Constraint Name
customItemTypeID + orderIndex	Primary key	Asc/Asc	sqlite_autoindex_customItemTypeFields_1
customFieldID	Performance	Asc	customItemTypeFields_customFieldID
fieldID	Performance	Asc	customItemTypeFields_fieldID