Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
project_feature Table project_feature_id bigserial 19 nextval('project.project_feature_project_feature_id_seq'::regclass)
project_relationship Table subject_project_id int8 19 null
project_relationship Table type_id int8 19 null

The cvterm type of the relationship being stated, such as "part of".

project_stock Table project_id int8 19 null
project Table name varchar 255 null
project_analysis Table analysis_id int8 19 null
project_dbxref Table is_current bool 1 true

The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked project.

project_dbxref Table project_id int8 19 null
project_stock Table project_stock_id bigserial 19 nextval('project.project_stock_project_stock_id_seq'::regclass)
projectprop Table type_id int8 19 null
projectprop Table project_id int8 19 null
project_feature Table project_id int8 19 null
project_relationship Table project_relationship_id bigserial 19 nextval('project.project_relationship_project_relationship_id_seq'::regclass)
project_stock Table stock_id int8 19 null
projectprop Table rank int4 10 0
project_relationship Table object_project_id int8 19 null
project_analysis Table project_analysis_id bigserial 19 nextval('project.project_analysis_project_analysis_id_seq'::regclass)
projectprop Table projectprop_id bigserial 19 nextval('project.projectprop_projectprop_id_seq'::regclass)
project_analysis Table project_id int8 19 null
projectprop Table value text 2147483647 null
project_contact Table contact_id int8 19 null
project_feature Table feature_id int8 19 null
project Table project_id bigserial 19 nextval('project.project_project_id_seq'::regclass)
project_pub Table project_id int8 19 null
project_analysis Table rank int4 10 0
project_pub Table pub_id int8 19 null
project_pub Table project_pub_id bigserial 19 nextval('project.project_pub_project_pub_id_seq'::regclass)
project_contact Table project_id int8 19 null
project Table description text 2147483647 null
project_contact Table project_contact_id bigserial 19 nextval('project.project_contact_project_contact_id_seq'::regclass)
project_dbxref Table project_dbxref_id bigserial 19 nextval('project.project_dbxref_project_dbxref_id_seq'::regclass)
project_dbxref Table dbxref_id int8 19 null