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

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

savedSearchID

integer

11,10

√

null

savedSearches.savedSearchID

FK_savedSearchConditions_savedSearches_savedSearchID R

searchConditionID

integer

11,10

√

null

condition

varchar

65536,10

√

null

operator

varchar

65536,10

√

null

value

varchar

65536,10

√

null

required

varchar

65536,10

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
savedSearchID + searchConditionID	Primary key	Asc/Asc	sqlite_autoindex_savedSearchConditions_1	These unique columns are also nullable