compounddata


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null

Primary id for this table. This uniquely identifies the row.
compound_id INT 10 null
compounds.id compounddata_ibfk_2C

Foreign key compounds (compounds.id).
germinatebase_id INT 10 null
germinatebase.id compounddata_ibfk_4C

Foreign key germinatebase (germinatebase.id).
dataset_id INT 10 null
datasets.id compounddata_ibfk_3C

Foreign key datasets (datasets.id).
analysismethod_id INT 10 √ null
analysismethods.id compounddata_ibfk_1N

Foreign key analysismethods (analysismethods.id).
compound_value DECIMAL 64,10 null

The compound value for this compound_id and germinatebase_id combination.
recording_date DATETIME 26 √ null

Date when the phenotypic result was recorded. Should be formatted ‘YYYY-MM-DD HH:MM:SS’ or just ‘YYYY-MM-DD’ where a timestamp is not available.
created_on DATETIME 26 √ CURRENT_TIMESTAMP

When the record was created.
updated_on TIMESTAMP 26 √ CURRENT_TIMESTAMP

When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compounddata_ibfk_analysismethod Performance Asc analysismethod_id
compounddata_ibfk_compound Performance Asc compound_id
compounddata_ibfk_dataset Performance Asc dataset_id
compounddata_ibfk_germinatebase Performance Asc germinatebase_id

Relationships

Close relationships within degrees of separation