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

Table contained 7,727 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
cookie Must be unique Asc zdb_submitters_cookie_index  
login Must be unique Asc zdb_submitters_login_index This unique column is also nullable
zdb_id Must be unique Asc zdb_submitters_primary_key_index  

Close relationships  within of separation: