Table zfindb.informix.zdb_submitters Generated by
SchemaSpy
Legend: SourceForge.net
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
login varchar 30  √  null
access varchar 80  √  null
zdb_id varchar 50
expression_pattern_infrastructure.xpatinf_curator_zdb_id xpatinf_curator_foreign_key R
person.zdb_id zdb_submitters_zdb_id_foreign_key C
cookie varchar 30
issue_time datetime year to fraction(3) 23  √  null
name varchar 80  √  null
create_date date 10  √  null
previous_login datetime year to fraction(3) 23  √  null
password varchar 40  √  null
is_curator boolean 1 f

Table contained 8,148 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
is_curator + cookie Must be unique Asc/Asc zdb_submitters_cookie_index
is_curator + login Must be unique Asc/Asc zdb_submitters_login_index
is_curator + zdb_id Must be unique Asc/Asc zdb_submitters_primary_key_index

Close relationships  within of separation: