genotypeprop

535 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
genotypeprop_id serial 10 nextval('genotypeprop_genotypeprop_id_seq'::regclass)
genotype_id int4 10 null
genotype.genotype_id genotypeprop_genotype_id_fkey C
type_id int4 10 null
cvterm.cvterm_id genotypeprop_type_id_fkey C
value jsonb 2147483647 null
rank int4 10 0

Indexes

Constraint Name Type Sort Column(s)
genotypeprop_pkey Primary key Asc genotypeprop_id
genotypeprop_c1 Must be unique Asc/Asc/Asc genotype_id + type_id + rank
genotypeprop_idx1 Performance Asc genotype_id
genotypeprop_idx2 Performance Asc type_id

Relationships