Table cxgn.sgn_bt.fish_result

Generated by
SchemaSpy

Legend:

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

bigserial

√

nextval('fish_result_fish_result_id_seq'::regclass)

map_id

int8

deprecated_maps.map_id

map_id_fkey

fish_experimenter_id

int4

fish_experimenter.fish_experimenter_id

fish_experimenter_id_fkey

experiment_name

varchar

clone_id

int8

clone.clone_id

fish_result_clone_id_fkey

chromo_num

int2

fish_karyotype_constants_old.chromo_num

Implied Constraint

chromo_arm

varchar

percent_from_centromere

float4

8,8

experiment_group

varchar

√

null

cxgn_production_visible

bool

√

false

attribution_id

int8

√

null

Table contained 855 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

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