Schema Version: 1.3

study


Columns

Column Type Size Foreign Key Nullable Default Comments
study_id bigserial 19
nextval('chado.study_study_id_seq'::regclass)
contact_id int8 19
contact.contact_id study_contact_id_fkey C
null
pub_id int8 19
pub.pub_id study_pub_id_fkey N
√ null
dbxref_id int8 19
dbxref.dbxref_id study_dbxref_id_fkey N
√ null
name text 2147483647
null
description text 2147483647
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
study_pkey Primary key Asc study_id
study_c1 Must be unique Asc name
study_idx1 Performance Asc contact_id
study_idx2 Performance Asc pub_id
study_idx3 Performance Asc dbxref_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the study table.

Show relationships within degrees of separation