trialsetup


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
phenotypedata.trialsetup_id phenotypedata_ibfk_7 C
germinatebase_id INT 10 null
germinatebase.id trialsetup_ibfk_1 C
dataset_id INT 10 null
datasets.id trialsetup_ibfk_2 C
location_id INT 10 √ null
locations.id trialsetup_ibfk_3 N
treatment_id INT 10 √ null
treatments.id trialsetup_ibfk_4 N
trialseries_id INT 10 √ null
trialseries.id trialsetup_ibfk_5 N
block VARCHAR 10 1
rep VARCHAR 10 1
trial_row SMALLINT 5 √ null
trial_column SMALLINT 5 √ null
latitude DECIMAL 64,10 √ null
longitude DECIMAL 64,10 √ null
elevation DECIMAL 64,10 √ null
created_on DATETIME 19 √ CURRENT_TIMESTAMP
updated_on TIMESTAMP 19 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dataset_id Performance Asc dataset_id
germinatebase_id Performance Asc germinatebase_id
location_id Performance Asc location_id
treatment_id Performance Asc treatment_id
trialseries_id Performance Asc trialseries_id

Relationships

Close relationships within degrees of separation