feature_genotype

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
feature_genotype_id serial 10 √ nextval('feature_genotype_feature_genotype_id_seq'::regclass)
feature_id int4 10 null
feature.feature_id feature_genotype_feature_id_fkey C
genotype_id int4 10 null
genotype.genotype_id feature_genotype_genotype_id_fkey C
chromosome_id int4 10 √ null
feature.feature_id feature_genotype_chromosome_id_fkey N

A feature of SO type “chromosome”.
rank int4 10 null

rank can be used for n-ploid organisms or to preserve order.
cgroup int4 10 null

Spatially distinguishable group. group can be used for distinguishing the chromosomal groups, for example (RNAi products and so on can be treated as different groups, as they do not fall on a particular chromosome).
cvterm_id int4 10 null
cvterm.cvterm_id feature_genotype_cvterm_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
feature_genotype_pkey Primary key Asc feature_genotype_id
feature_genotype_c1 Must be unique Asc/Asc/Asc/Asc/Asc/Asc feature_id + genotype_id + cvterm_id + chromosome_id + rank + cgroup
feature_genotype_idx1 Performance Asc feature_id
feature_genotype_idx2 Performance Asc genotype_id

Relationships

Close relationships within degrees of separation