Table zfindb.public.curation 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
cur_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id cur_zdb_id_foreign_key C
cur_pub_zdb_id text 2147483647
publication.zdb_id cur_pub_zdb_id_foreign_key C
cur_curator_zdb_id text 2147483647
person.zdb_id cur_curator_zdb_id_foreign_key R
cur_topic text 2147483647
curation_topic.curtopic_name cur_topic_foreign_key R
cur_data_found bool 1 false
cur_entry_date timestamp 29,6
cur_closed_date timestamp 29,6  √  null
cur_opened_date timestamp 29,6  √  null

Table contained 398,589 rows at Fri Oct 04 14:43 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
cur_zdb_id Primary key Asc curation_primary_key
cur_curator_zdb_id Performance Asc cur_assign_curator_zdb_id_index
cur_pub_zdb_id Performance Asc cur_pub_zdb_id_index
cur_topic Performance Asc cur_topic_index

Close relationships  within of separation: