fish_result_composite

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 16 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Check Constraints

Search:

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)))

Showing 1 to 2 of 2 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation