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

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

itemID

integer

11,10

√

null

items.itemID

FK_itemCreators_items_itemID R

creatorID

integer

11,10

√

null

creators.creatorID

FK_itemCreators_creators_creatorID R

creatorTypeID

integer

11,10

√

creatorTypes.creatorTypeID

FK_itemCreators_creatorTypes_creatorTypeID R

orderIndex

integer

11,10

√

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

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
itemID + creatorID + creatorTypeID + orderIndex	Primary key	Asc/Asc/Asc/Asc	sqlite_autoindex_itemCreators_1	These unique columns are also nullable