fish_result

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fish_result_id bigserial 19 √ nextval('sgn.fish_result_fish_result_id_seq'::regclass)
fish_result_image.fish_result_id fish_result_image_fish_result_id_fkey C
map_id int8 19 null
deprecated_maps.map_id map_id_fkey R
fish_experimenter_id int4 10 null
fish_experimenter.fish_experimenter_id fish_experimenter_id_fkey R
experiment_name varchar 10 null
clone_id int8 19 null
clone.clone_id fish_result_clone_id_fkey R
chromo_num int2 5 null
fish_karyotype_constants_old.chromo_num Implied Constraint R
chromo_arm varchar 1 null
fish_chromatin_density_constants.arm Implied Constraint R
percent_from_centromere float4 8,8 null
experiment_group varchar 12 √ null
attribution_id int8 19 √ null
attribution.attribution_id fish_result_attribution_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
fish_result_pkey Primary key Asc fish_result_id
fish_result_fish_experimenter_clone_id_experiment_name Must be unique Asc/Asc/Asc fish_experimenter_id + clone_id + experiment_name

Check Constraints

Constraint Name Constraint
fish_result_chromo_arm_check ((((chromo_arm)::text = 'P'::text) OR ((chromo_arm)::text = 'Q'::text)))

Relationships

Close relationships within degrees of separation