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 341,759 rows at Mon Sep 03 04:09 PDT 2018

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: