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

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

itemTypeID

integer

11,10

√

null

itemTypes.itemTypeID

FK_baseFieldMappings_itemTypes_itemTypeID R

baseFieldID

integer

11,10

√

null

fields.fieldID

FK_baseFieldMappings_fields_fieldID R

fieldID

integer

11,10

√

null

fields.fieldID

FK_baseFieldMappings_fields_fieldID R

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

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
itemTypeID + baseFieldID + fieldID	Primary key	Asc/Asc/Asc	sqlite_autoindex_baseFieldMappings_1	These unique columns are also nullable
baseFieldID	Performance	Asc	baseFieldMappings_baseFieldID
fieldID	Performance	Asc	baseFieldMappings_fieldID