Table zfindb.public.zebrashare_data_edit_permission 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
zdep_zdb_id text 2147483647
zdep_person_zdb_id text 2147483647
person.zdb_id zdep_person_fk C
zdep_pub_zdb_id text 2147483647
publication.zdb_id zdep_pub_fk C
zdep_person_is_submitter bool 1  √  false

Table contained 23 rows at Fri Oct 04 14:43 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
zdep_zdb_id Primary key Asc zebrashare_data_edit_permission_pkey
zdep_person_zdb_id + zdep_pub_zdb_id Must be unique Asc/Asc zebrashare_alternate_key_index
zdep_person_zdb_id Performance Asc zebrashare_person_fk_index
zdep_pub_zdb_id Performance Asc zebrashare_pub_fk_index

Close relationships  within of separation: