Table zfindb.public.feature_community_contribution 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
fcc_pk_id bigserial 19  √  nextval('feature_community_contribution_fcc_pk_id_seq'::regclass)
fcc_feature_zdb_id text 2147483647
feature.feature_zdb_id fcc_feature_zdb_id_foreign_key C
fcc_functional_consequence text 2147483647  √  null
fcc_adult_viable bool 1  √  false
fcc_maternal_zygosity_examined bool 1  √  false
fcc_currently_available bool 1  √  false
fcc_other_line_information text 2147483647  √  null
fcc_date_added timestamp 29,6 now()
fcc_added_by text 2147483647
person.zdb_id fcc_person_fk_odc C

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

Indexes:
Column(s) Type Sort Constraint Name
fcc_pk_id Primary key Asc feature_community_contribution_pkey
fcc_feature_zdb_id Performance Asc fcc_feature_zdb_id_index

Close relationships  within of separation: