Table cxgn.sgn.family

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
family_id bigserial 19  √  nextval('family_family_id_seq'::regclass)
family_member.family_id family_member_family_id_fkey
family_tree.family_id family_tree_family_id_fkey
family_build_id int8 19  √  null
family_build.family_build_id family_family_build_id_fkey
family_annotation text 2147483647  √  null
tree_log_file_location varchar 2147483647  √  null
tree_file_location varchar 2147483647  √  null
tree_taxa_number int4 10  √  null
tree_overlap_length int4 10  √  null
family_nr int4 10  √  null
member_count int4 10  √  null

Table contained 128,925 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
family_id Primary key Asc family_pkey
family_build_id Performance Asc family_build_id_idx

Close relationships: