fish_result_composite

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fish_result_id int8 19 (0)::bigint
map_id int8 19 (0)::bigint
fish_experimenter_id int4 10 √ null
fish_experimenter.fish_experimenter_id Implied Constraint R
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 R
chromo_arm varchar 1 'P'::character varying
fish_chromatin_density_constants.arm Implied Constraint R
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

Indexes

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

Check Constraints

Constraint Name Constraint
fish_result_composite_het_or_eu_check ((((het_or_eu)::text = 'H'::text) OR ((het_or_eu)::text = 'E'::text)))
fish_result_composite_chromo_arm_check ((((chromo_arm)::text = 'P'::text) OR ((chromo_arm)::text = 'Q'::text)))

Relationships

Close relationships within degrees of separation