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 |