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

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

itemTypeID

integer

11,10

dateAdded

timestamp

30,10

2010-10-21 17:16:19

dateModified

timestamp

30,10

2010-10-21 17:16:19

clientDateModified

timestamp

30,10

2010-10-21 17:16:19

libraryID

integer

11,10

√

null

libraries.libraryID

FK_items_libraries_libraryID R

key

varchar

65536,10

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

Indexes:

Column(s)	Type	Sort	Constraint Name
libraryID + key	Primary key	Asc/Asc	sqlite_autoindex_items_1