nd_geolocation | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_geolocation_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
description | text | 64000 | A textual representation of the location, if this is the original georeference. Optional if the original georeference is available in lat/long coordinates. | ||
latitude | real | 10 | The decimal latitude coordinate of the georeference, using positive and negative sign to indicate N and S, respectively. | ||
longitude | real | 10 | The decimal longitude coordinate of the georeference, using positive and negative sign to indicate E and W, respectively. | ||
geodetic_datum | varchar | 32 | The geodetic system on which the geo-reference coordinates are based. For geo-references measured between 1984 and 2010, this will typically be WGS84. | ||
altitude | real | 10 | The altitude (elevation) of the location in meters. If the altitude is only known as a range, this is the average, and altitude_dev will hold half of the width of the range. |
Name | Fields |
---|---|
nd_geolocation_idx1 | latitude |
nd_geolocation_idx2 | longitude |
nd_geolocation_idx3 | altitude |
Type | Fields |
---|---|
NOT NULL | nd_geolocation_id |
nd_experiment | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_geolocation_id | integer | 20 | NOT NULL | nd_geolocation.nd_geolocation_id | |
type_id | integer | 20 | NOT NULL | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_experiment_idx1 | nd_geolocation_id |
nd_experiment_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_id |
NOT NULL | nd_geolocation_id |
FOREIGN KEY | nd_geolocation_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | nd_geolocation_id |
FOREIGN KEY | type_id |
nd_experiment_project | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_project_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
project_id | integer | 20 | UNIQUE, NOT NULL | project.project_id | |
nd_experiment_id | integer | 20 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id |
Name | Fields |
---|---|
nd_experiment_project_idx1 | project_id |
nd_experiment_project_idx2 | nd_experiment_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_project_id |
NOT NULL | project_id |
FOREIGN KEY | project_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
UNIQUE | project_id, nd_experiment_id |
FOREIGN KEY | project_id |
FOREIGN KEY | nd_experiment_id |
nd_experimentprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experimentprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
type_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
value | text | 64000 | NULL | ||
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
nd_experimentprop_idx1 | nd_experiment_id |
nd_experimentprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_experimentprop_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | nd_experiment_id, type_id, rank |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | type_id |
nd_experiment_pub | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_pub_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
pub_id | integer | 20 | UNIQUE, NOT NULL | pub.pub_id |
Name | Fields |
---|---|
nd_experiment_pub_idx1 | nd_experiment_id |
nd_experiment_pub_idx2 | pub_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_pub_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | pub_id |
FOREIGN KEY | pub_id |
UNIQUE | nd_experiment_id, pub_id |
nd_geolocationprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_geolocationprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_geolocation_id | integer | 20 | UNIQUE, NOT NULL | nd_geolocation.nd_geolocation_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
value | text | 64000 | NULL | The value of the property. | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
Name | Fields |
---|---|
nd_geolocationprop_idx1 | nd_geolocation_id |
nd_geolocationprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_geolocationprop_id |
NOT NULL | nd_geolocation_id |
FOREIGN KEY | nd_geolocation_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | nd_geolocation_id, type_id, rank |
FOREIGN KEY | nd_geolocation_id |
FOREIGN KEY | type_id |
nd_protocol | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_protocol_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
name | varchar | 255 | UNIQUE, NOT NULL, The protocol name. | ||
type_id | integer | 20 | NOT NULL | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_protocol_idx1 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_protocol_id |
NOT NULL | name |
UNIQUE | name |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | type_id |
nd_reagent | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_reagent_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
name | varchar | 80 | NOT NULL, The name of the reagent. The name should be unique for a given type. | ||
type_id | integer | 20 | NOT NULL, The type of the reagent, for example linker oligomer, or forward primer. | cvterm.cvterm_id | |
feature_id | integer | 20 | NULL | If the reagent is a primer, the feature that it corresponds to. More generally, the corresponding feature for any reagent that has a sequence that maps to another sequence. | feature.feature_id |
Name | Fields |
---|---|
nd_reagent_idx1 | type_id |
nd_reagent_idx2 | feature_id |
Type | Fields |
---|---|
NOT NULL | nd_reagent_id |
NOT NULL | name |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | feature_id |
FOREIGN KEY | type_id |
FOREIGN KEY | feature_id |
nd_protocol_reagent | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_protocol_reagent_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_protocol_id | integer | 20 | NOT NULL | nd_protocol.nd_protocol_id | |
reagent_id | integer | 20 | NOT NULL | nd_reagent.nd_reagent_id | |
type_id | integer | 20 | NOT NULL | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_protocol_reagent_idx1 | nd_protocol_id |
nd_protocol_reagent_idx2 | reagent_id |
nd_protocol_reagent_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_protocol_reagent_id |
NOT NULL | nd_protocol_id |
FOREIGN KEY | nd_protocol_id |
NOT NULL | reagent_id |
FOREIGN KEY | reagent_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | nd_protocol_id |
FOREIGN KEY | reagent_id |
FOREIGN KEY | type_id |
nd_protocolprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_protocolprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_protocol_id | integer | 20 | UNIQUE, NOT NULL, The protocol to which the property applies. | nd_protocol.nd_protocol_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
value | text | 64000 | NULL | The value of the property. | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
Name | Fields |
---|---|
nd_protocolprop_idx1 | nd_protocol_id |
nd_protocolprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_protocolprop_id |
NOT NULL | nd_protocol_id |
FOREIGN KEY | nd_protocol_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | nd_protocol_id, type_id, rank |
FOREIGN KEY | nd_protocol_id |
FOREIGN KEY | type_id |
nd_experiment_stock | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_stock_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | NOT NULL | nd_experiment.nd_experiment_id | |
stock_id | integer | 20 | NOT NULL, stock used in the extraction or the corresponding stock for the clone | stock.stock_id | |
type_id | integer | 20 | NOT NULL | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_experiment_stock_idx1 | nd_experiment_id |
nd_experiment_stock_idx2 | stock_id |
nd_experiment_stock_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_stock_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | stock_id |
FOREIGN KEY | stock_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | stock_id |
FOREIGN KEY | type_id |
nd_experiment_protocol | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_protocol_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | NOT NULL | nd_experiment.nd_experiment_id | |
nd_protocol_id | integer | 20 | NOT NULL | nd_protocol.nd_protocol_id |
Name | Fields |
---|---|
nd_experiment_protocol_idx1 | nd_experiment_id |
nd_experiment_protocol_idx2 | nd_protocol_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_protocol_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | nd_protocol_id |
FOREIGN KEY | nd_protocol_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | nd_protocol_id |
nd_experiment_phenotype | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_phenotype_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
phenotype_id | integer | 20 | UNIQUE, NOT NULL | phenotype.phenotype_id |
Name | Fields |
---|---|
nd_experiment_phenotype_idx1 | nd_experiment_id |
nd_experiment_phenotype_idx2 | phenotype_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_phenotype_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | phenotype_id |
FOREIGN KEY | phenotype_id |
UNIQUE | nd_experiment_id, phenotype_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | phenotype_id |
nd_experiment_genotype | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_genotype_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
genotype_id | integer | 20 | UNIQUE, NOT NULL | genotype.genotype_id |
Name | Fields |
---|---|
nd_experiment_genotype_idx1 | nd_experiment_id |
nd_experiment_genotype_idx2 | genotype_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_genotype_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | genotype_id |
FOREIGN KEY | genotype_id |
UNIQUE | nd_experiment_id, genotype_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | genotype_id |
nd_reagent_relationship | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_reagent_relationship_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
subject_reagent_id | integer | 20 | NOT NULL, The subject reagent in the relationship. In parent/child terminology, the subject is the child. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | nd_reagent.nd_reagent_id | |
object_reagent_id | integer | 20 | NOT NULL, The object reagent in the relationship. In parent/child terminology, the object is the parent. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | nd_reagent.nd_reagent_id | |
type_id | integer | 20 | NOT NULL, The type (or predicate) of the relationship. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_reagent_relationship_idx1 | subject_reagent_id |
nd_reagent_relationship_idx2 | object_reagent_id |
nd_reagent_relationship_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_reagent_relationship_id |
NOT NULL | subject_reagent_id |
FOREIGN KEY | subject_reagent_id |
NOT NULL | object_reagent_id |
FOREIGN KEY | object_reagent_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
FOREIGN KEY | subject_reagent_id |
FOREIGN KEY | object_reagent_id |
FOREIGN KEY | type_id |
nd_reagentprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_reagentprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_reagent_id | integer | 20 | UNIQUE, NOT NULL | nd_reagent.nd_reagent_id | |
type_id | integer | 20 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
value | text | 64000 | NULL | ||
rank | integer | 10 | 0 | UNIQUE, NOT NULL |
Name | Fields |
---|---|
nd_reagentprop_idx1 | nd_reagent_id |
nd_reagentprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_reagentprop_id |
NOT NULL | nd_reagent_id |
FOREIGN KEY | nd_reagent_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | nd_reagent_id, type_id, rank |
FOREIGN KEY | nd_reagent_id |
FOREIGN KEY | type_id |
nd_experiment_stockprop | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_stockprop_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_stock_id | integer | 20 | UNIQUE, NOT NULL, The experiment_stock to which the property applies. | nd_experiment_stock.nd_experiment_stock_id | |
type_id | integer | 20 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
value | text | 64000 | NULL | The value of the property. | |
rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
Name | Fields |
---|---|
nd_experiment_stockprop_idx1 | nd_experiment_stock_id |
nd_experiment_stockprop_idx2 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_stockprop_id |
NOT NULL | nd_experiment_stock_id |
FOREIGN KEY | nd_experiment_stock_id |
NOT NULL | type_id |
FOREIGN KEY | type_id |
NOT NULL | rank |
UNIQUE | nd_experiment_stock_id, type_id, rank |
FOREIGN KEY | nd_experiment_stock_id |
FOREIGN KEY | type_id |
nd_experiment_stock_dbxref | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_stock_dbxref_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_stock_id | integer | 20 | NOT NULL | nd_experiment_stock.nd_experiment_stock_id | |
dbxref_id | integer | 20 | NOT NULL | dbxref.dbxref_id |
Name | Fields |
---|---|
nd_experiment_stock_dbxref_idx1 | nd_experiment_stock_id |
nd_experiment_stock_dbxref_idx2 | dbxref_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_stock_dbxref_id |
NOT NULL | nd_experiment_stock_id |
FOREIGN KEY | nd_experiment_stock_id |
NOT NULL | dbxref_id |
FOREIGN KEY | dbxref_id |
FOREIGN KEY | nd_experiment_stock_id |
FOREIGN KEY | dbxref_id |
nd_experiment_dbxref | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_dbxref_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | NOT NULL | nd_experiment.nd_experiment_id | |
dbxref_id | integer | 20 | NOT NULL | dbxref.dbxref_id |
Name | Fields |
---|---|
nd_experiment_dbxref_idx1 | nd_experiment_id |
nd_experiment_dbxref_idx2 | dbxref_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_dbxref_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | dbxref_id |
FOREIGN KEY | dbxref_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | dbxref_id |
nd_experiment_contact | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_contact_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | NOT NULL | nd_experiment.nd_experiment_id | |
contact_id | integer | 20 | NOT NULL | contact.contact_id |
Name | Fields |
---|---|
nd_experiment_contact_idx1 | nd_experiment_id |
nd_experiment_contact_idx2 | contact_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_contact_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | contact_id |
FOREIGN KEY | contact_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | contact_id |
nd_experiment_analysis | Top |
Field Name | Data Type | Size | Default Value | Other | Foreign Key |
---|---|---|---|---|---|
nd_experiment_analysis_id | integer | 20 | PRIMARY KEY, NOT NULL | ||
nd_experiment_id | integer | 20 | NOT NULL | nd_experiment.nd_experiment_id | |
analysis_id | integer | 20 | NOT NULL | analysis.analysis_id | |
type_id | integer | 20 | NULL | cvterm.cvterm_id |
Name | Fields |
---|---|
nd_experiment_analysis_idx1 | nd_experiment_id |
nd_experiment_analysis_idx2 | analysis_id |
nd_experiment_analysis_idx3 | type_id |
Type | Fields |
---|---|
NOT NULL | nd_experiment_analysis_id |
NOT NULL | nd_experiment_id |
FOREIGN KEY | nd_experiment_id |
NOT NULL | analysis_id |
FOREIGN KEY | analysis_id |
FOREIGN KEY | type_id |
FOREIGN KEY | nd_experiment_id |
FOREIGN KEY | analysis_id |
FOREIGN KEY | type_id |