Table cxgn.sgn.fish_result_composite

Generated by
SchemaSpy
Implied relationships 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
fish_result_id int8 19 (0)::bigint
fish_file.fish_result_id Implied Constraint
map_id int8 19 (0)::bigint
fish_experimenter_id int4 10  √  null
experiment_name varchar 10  √  null
clone_id int8 19 (0)::bigint
chromo_num int2 5 (0)::smallint
fish_karyotype_constants_old.chromo_num Implied Constraint
chromo_arm varchar 1 'P'::character varying
percent_from_centromere float4 8,8 (0)::real
het_or_eu varchar 1  √  null
um_from_centromere float4 8,8  √  null
um_from_arm_end float4 8,8  √  null
um_from_arm_border float4 8,8  √  null
mbp_from_arm_end float4 8,8  √  null
mbp_from_centromere float4 8,8  √  null
mbp_from_arm_border float4 8,8  √  null
experiment_group varchar 12  √  null

Table contained 215 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
fish_result_id Primary key Asc fish_result_composite_pkey

Close relationships: