stock | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
dbxref_id | integer | 20 | The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref. | dbxref.dbxref_id | |
organism_id | integer | 20 | UNIQUE, The organism_id is the organism to which the stock belongs. This column should only be left blank if the organism cannot be determined. | organism.organism_id | |
name | varchar | 255 | The name is a human-readable local name for a stock. | ||
uniquename | text | 64000 | UNIQUE, NOT NULL | ||
description | text | 64000 | The description is the genetic description provided in the stock list. | ||
type_id | integer | 20 | UNIQUE, NOT NULL, The type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Secondary cvterms for stocks would go in stock_cvterm. | cvterm.cvterm_id | |
is_obsolete | boolean | 0 | false | NOT NULL |
Name | Fields |
---|---|
stock_name_ind1 | name |
stock_idx1 | dbxref_id |
stock_idx2 | organism_id |
stock_idx3 | type_id |
stock_idx4 | uniquename |
Type | Fields |
---|---|
NOT NULL | stock_id |
FOREIGN KEY | dbxref_id |
FOREIGN KEY | organism_id |
NOT NULL | uniquename |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | is_obsolete |
UNIQUE | organism_id, uniquename, type_id |
stock_pub | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_pub_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
pub_id | integer | 20 | UNIQUE, NOT NULL | pub.pub_id |
Name | Fields |
---|---|
stock_pub_idx1 | stock_id |
stock_pub_idx2 | pub_id |
Type | Fields |
---|---|
NOT NULL | stock_pub_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | stock_id, pub_id |
stockprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
type_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
value | text | 64000 | NULL | ||
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
stockprop_idx1 | stock_id |
stockprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | stockprop_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | stock_id, type_id, rank |
stockprop_pub | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockprop_pub_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stockprop_id | integer | 20 | UNIQUE, NOT NULL | stockprop.stockprop_id | |
pub_id | integer | 20 | UNIQUE, NOT NULL | pub.pub_id |
Name | Fields |
---|---|
stockprop_pub_idx1 | stockprop_id |
stockprop_pub_idx2 | pub_id |
Type | Fields |
---|---|
NOT NULL | stockprop_pub_id |
NOT NULL | stockprop_id |
FOREIGN KEY | stockprop_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | stockprop_id, pub_id |
stock_relationship | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_relationship_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
subject_id | integer | 20 | UNIQUE, NOT NULL, stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock. | stock.stock_id | |
object_id | integer | 20 | UNIQUE, NOT NULL, stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock. | stock.stock_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. | cvterm.cvterm_id | |
value | text | 64000 | NULL | stock_relationship.value is for additional notes or comments. | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL, stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero. |
Name | Fields |
---|---|
stock_relationship_idx1 | subject_id |
stock_relationship_idx2 | object_id |
stock_relationship_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | stock_relationship_id |
NOT NULL | subject_id |
FOREIGN KEY | subject_id |
NOT NULL | object_id |
FOREIGN KEY | object_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | subject_id, object_id, type_id, rank |
stock_relationship_cvterm | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_relationship_cvterm_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_relationship_id | integer | 20 | NOT NULL | stock_relationship.stock_relationship_id | |
cvterm_id | integer | 20 | NOT NULL | cvterm.cvterm_id | |
pub_id | integer | 20 | pub.pub_id |
Type | Fields |
---|---|
NOT NULL | stock_relationship_cvterm_id |
NOT NULL | stock_relationship_id |
FOREIGN KEY | stock_relationship_id |
NOT NULL | cvterm_id |
FOREIGN KEY | cvterm_id |
FOREIGN KEY | pub_id |
stock_relationship_pub | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_relationship_pub_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_relationship_id | integer | 20 | UNIQUE, NOT NULL | stock_relationship.stock_relationship_id | |
pub_id | integer | 20 | UNIQUE, NOT NULL | pub.pub_id |
Name | Fields |
---|---|
stock_relationship_pub_idx1 | stock_relationship_id |
stock_relationship_pub_idx2 | pub_id |
Type | Fields |
---|---|
NOT NULL | stock_relationship_pub_id |
NOT NULL | stock_relationship_id |
FOREIGN KEY | stock_relationship_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | stock_relationship_id, pub_id |
stock_dbxref | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_dbxref_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
dbxref_id | integer | 20 | UNIQUE, NOT NULL | dbxref.dbxref_id | |
is_current | boolean | 0 | true | NOT NULL, The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock. |
Name | Fields |
---|---|
stock_dbxref_idx1 | stock_id |
stock_dbxref_idx2 | dbxref_id |
Type | Fields |
---|---|
NOT NULL | stock_dbxref_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | dbxref_id |
FOREIGN KEY | dbxref_id |
NOT NULL | is_current |
UNIQUE | stock_id, dbxref_id |
stock_cvterm | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_cvterm_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
cvterm_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
pub_id | integer | 20 | UNIQUE, NOT NULL | pub.pub_id | |
is_not | boolean | 0 | false | NOT NULL | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
stock_cvterm_idx1 | stock_id |
stock_cvterm_idx2 | cvterm_id |
stock_cvterm_idx3 | pub_id |
Type | Fields |
---|---|
NOT NULL | stock_cvterm_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | cvterm_id |
FOREIGN KEY | cvterm_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
NOT NULL | is_not |
NOT NULL | rank |
UNIQUE | stock_id, cvterm_id, pub_id, rank |
stock_cvtermprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_cvtermprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_cvterm_id | integer | 20 | UNIQUE, NOT NULL | stock_cvterm.stock_cvterm_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, The name of the property/slot is a cvterm. The meaning of the property is defined in that cvterm. cvterms may come from the OBO evidence code cv. | cvterm.cvterm_id | |
value | text | 64000 | NULL | The value of the property, represented as text. Numeric values are converted to their text representation. This is less efficient than using native database types, but is easier to query. | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL, Property-Value ordering. Any stock_cvterm can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used. |
Name | Fields |
---|---|
stock_cvtermprop_idx1 | stock_cvterm_id |
stock_cvtermprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | stock_cvtermprop_id |
NOT NULL | stock_cvterm_id |
FOREIGN KEY | stock_cvterm_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | stock_cvterm_id, type_id, rank |
stock_genotype | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_genotype_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
genotype_id | integer | 20 | UNIQUE, NOT NULL | genotype.genotype_id |
Name | Fields |
---|---|
stock_genotype_idx1 | stock_id |
stock_genotype_idx2 | genotype_id |
Type | Fields |
---|---|
NOT NULL | stock_genotype_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | genotype_id |
FOREIGN KEY | genotype_id |
UNIQUE | stock_id, genotype_id |
stockcollection | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockcollection_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
type_id | integer | 20 | UNIQUE, NOT NULL, type_id is the collection type cv. | cvterm.cvterm_id | |
contact_id | integer | 20 | NULL | contact_id links to the contact information for the collection. | contact.contact_id |
name | varchar | 255 | name is the collection. | ||
uniquename | text | 64000 | UNIQUE, NOT NULL, uniqename is the value of the collection cv. |
Name | Fields |
---|---|
stockcollection_name_ind1 | name |
stockcollection_idx1 | contact_id |
stockcollection_idx2 | type_id |
stockcollection_idx3 | uniquename |
Type | Fields |
---|---|
NOT NULL | stockcollection_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | contact_id |
NOT NULL | uniquename |
UNIQUE | uniquename, type_id |
stockcollectionprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockcollectionprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stockcollection_id | integer | 20 | UNIQUE, NOT NULL | stockcollection.stockcollection_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, The cv for the type_id is "stockcollection property type". | cvterm.cvterm_id | |
value | text | 64000 | NULL | ||
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
stockcollectionprop_idx1 | stockcollection_id |
stockcollectionprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | stockcollectionprop_id |
NOT NULL | stockcollection_id |
FOREIGN KEY | stockcollection_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | stockcollection_id, type_id, rank |
stockcollection_stock | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockcollection_stock_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stockcollection_id | integer | 20 | UNIQUE, NOT NULL | stockcollection.stockcollection_id | |
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id |
Name | Fields |
---|---|
stockcollection_stock_idx1 | stockcollection_id |
stockcollection_stock_idx2 | stock_id |
Type | Fields |
---|---|
NOT NULL | stockcollection_stock_id |
NOT NULL | stockcollection_id |
FOREIGN KEY | stockcollection_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
UNIQUE | stockcollection_id, stock_id |
stock_dbxrefprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_dbxrefprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stock_dbxref_id | integer | 20 | UNIQUE, NOT NULL | stock_dbxref.stock_dbxref_id | |
type_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
value | text | 64000 | NULL | ||
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
stock_dbxrefprop_idx1 | stock_dbxref_id |
stock_dbxrefprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | stock_dbxrefprop_id |
NOT NULL | stock_dbxref_id |
FOREIGN KEY | stock_dbxref_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | stock_dbxref_id, type_id, rank |
stockcollection_db | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stockcollection_db_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
stockcollection_id | integer | 20 | UNIQUE, NOT NULL | stockcollection.stockcollection_id | |
db_id | integer | 20 | UNIQUE, NOT NULL | db.db_id |
Name | Fields |
---|---|
stockcollection_db_idx1 | stockcollection_id |
stockcollection_db_idx2 | db_id |
Type | Fields |
---|---|
NOT NULL | stockcollection_db_id |
NOT NULL | stockcollection_id |
NOT NULL | db_id |
UNIQUE | stockcollection_id, db_id |
FOREIGN KEY | db_id |
FOREIGN KEY | stockcollection_id |
stock_feature | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_feature_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
feature_id | integer | 20 | UNIQUE, NOT NULL | feature.feature_id | |
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
type_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
stock_feature_idx1 | stock_feature_id |
stock_feature_idx2 | feature_id |
stock_feature_idx3 | stock_id |
stock_feature_idx4 | type_id |
Type | Fields |
---|---|
NOT NULL | stock_feature_id |
NOT NULL | feature_id |
NOT NULL | stock_id |
NOT NULL | type_id |
NOT NULL | rank |
FOREIGN KEY | feature_id |
FOREIGN KEY | stock_id |
FOREIGN KEY | type_id |
UNIQUE | feature_id, stock_id, type_id, rank |
stock_featuremap | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_featuremap_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
featuremap_id | integer | 20 | UNIQUE, NOT NULL | featuremap.featuremap_id | |
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id | |
type_id | integer | 20 | UNIQUE | cvterm.cvterm_id |
Name | Fields |
---|---|
stock_featuremap_idx1 | featuremap_id |
stock_featuremap_idx2 | stock_id |
stock_featuremap_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | stock_featuremap_id |
NOT NULL | featuremap_id |
NOT NULL | stock_id |
FOREIGN KEY | featuremap_id |
FOREIGN KEY | stock_id |
FOREIGN KEY | type_id |
UNIQUE | featuremap_id, stock_id, type_id |
stock_library | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
stock_library_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
library_id | integer | 20 | UNIQUE, NOT NULL | library.library_id | |
stock_id | integer | 20 | UNIQUE, NOT NULL | stock.stock_id |
Name | Fields |
---|---|
stock_library_idx1 | library_id |
stock_library_idx2 | stock_id |
Type | Fields |
---|---|
NOT NULL | stock_library_id |
NOT NULL | library_id |
NOT NULL | stock_id |
UNIQUE | library_id, stock_id |
FOREIGN KEY | library_id |
FOREIGN KEY | stock_id |