cxgn_breedbase
.sgn
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fish_karyotype_constants
0
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
fish_experimenter_id
int4
10
null
chromo_num
int2
5
null
chromo_arm
text
2147483647
null
arm_length
numeric
5,2
null
arm_eu_length
numeric
5,2
null
arm_het_length
numeric
5,2
null
Showing 1 to 6 of 6 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
fish_karyotype_constants_pkey1
Primary key
Asc
/
Asc
/
Asc
fish_experimenter_id + chromo_num + chromo_arm
Showing 1 to 1 of 1 entries
Previous
1
Next
Check Constraints
Search:
Constraint Name
Constraint
chromo_arm_enum
(((chromo_arm = 'P'::text) OR (chromo_arm = 'Q'::text)))
Showing 1 to 1 of 1 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One