Schema Version: 1.3

studyprop


Columns

Column Type Size Foreign Key Nullable Default Comments
studyprop_id bigserial 19
nextval('chado.studyprop_studyprop_id_seq'::regclass)
study_id int8 19
study.study_id studyprop_study_id_fkey C
null
type_id int8 19
cvterm.cvterm_id studyprop_type_id_fkey C
null
value text 2147483647
null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
studyprop_pkey Primary key Asc studyprop_id
studyprop_idx1 Performance Asc study_id
studyprop_idx2 Performance Asc type_id
studyprop_study_id_type_id_rank_key Must be unique Asc/Asc/Asc study_id + type_id + rank

Relationships