Table zfindb.public.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 text 2147483647  √  null
access text 2147483647  √  null
zdb_id text 2147483647
expression_pattern_infrastructure.xpatinf_curator_zdb_id xpatinf_curator_foreign_key R
person.zdb_id zdb_submitters_zdb_id_foreign_key C
cookie text 2147483647
issue_time timestamp 26,3  √  null
name text 2147483647  √  null
create_date date 13  √  null
previous_login timestamp 26,3  √  null
password text 2147483647  √  null
is_curator bool 1 false
is_student bool 1  √  false
password_reset_key text 2147483647  √  null
password_reset_date timestamp 26,3  √  null

Table contained 9,587 rows at Wed Sep 15 00:41 PDT 2021

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

Close relationships  within of separation: