Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
sample_id
varchar(255)
This is not a FK. This is the name of the sample.
This is not a FK. This is the name of the sample.
3
marker_id
int(10, 0)
Foreign key to markers (markers.id).
Foreign key to markers (markers.id).
4
dataset_id
int(10, 0)
Foreign key to datasets (datasets.id).
Foreign key to datasets (datasets.id).
5
germinatebase_id
int(10, 0)
Foreign key to germinatebase (germinatebase.id).
Foreign key to germinatebase (germinatebase.id).
6
description
varchar(255)
Describes the entry for this specific row.
Describes the entry for this specific row.
7
value
double(64, 10)
Describes the value associated with this sample, marker, germinatebase and dataset entry.
Describes the value associated with this sample, marker, germinatebase and dataset entry.
8
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
9
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The name of the analysis method.
The name of the analysis method.
3
description
varchar(255)
Describes the analysis method.
Describes the analysis method.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines attributes data. Attributes which are defined in attributes can have values associated with them. Data which does not warrant new column in the germinatebase table can be added here. Examples include small amounts of data defining germplasm which only exists for a small sub-group of the total database.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
attribute_id
int(10, 0)
Foreign key to attributes (attributes.id).
Foreign key to attributes (attributes.id).
3
foreign_id
int(10, 0)
Foreign key to germinatebase (germinatebase.id).
Foreign key to germinatebase (germinatebase.id).
4
value
text
The value of the attribute.
The value of the attribute.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Describes attributes. Attributes are bits of information that can be joined to, for example, a germinatebase entry. These are bits of data that while important do not warrant adding additional columns in the other tables. Examples would be using this to define ecotypes for germinatebase entries.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Defines the name of the attribute.
Defines the name of the attribute.
3
description
varchar(255)
Describes the attribute. This should expand on the name to make it clear what the attribute actually is.
Describes the attribute. This should expand on the name to make it clear what the attribute actually is.
4
datatype
enum
Default:
int
Describes the data type of the attribute. This can be INT, FLOAT or CHAR type.
Describes the data type of the attribute. This can be INT, FLOAT or CHAR type.
Default:
int
5
target_table
varchar(255)
Default:
germinatebase
Default:
germinatebase
6
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
7
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Based on Multi Crop Passport Descriptors (MCPD V2 2012) - The coding scheme proposed can be used at 3 different levels of detail: either by using the general codes (in boldface) such as 100, 200, 300, 400, or by using the more specific codes such as 110, 120, etc. 100) Wild 110) Natural 120) Semi-natural/wild 130) Semi-natural/sown 200) Weedy 300) Traditional cultivar/landrace 400) Breeding/research material 410) Breeder's line 411) Synthetic population 412) Hybrid 413) Founder stock/base population 414) Inbred line (parent of hybrid cultivar) 415) Segregating population 416) Clonal selection 420) Genetic stock 421) Mutant (e.g. induced/insertion mutants, tilling populations) 422) Cytogenetic stocks (e.g. chromosome addition/substitution, aneuploids, amphiploids) 423) Other genetic stocks (e.g. mapping populations) 500) Advanced or improved cultivar (conventional breeding methods) 600) GMO (by genetic engineering) 999) Other
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
sampstat
varchar(255)
Previoulsy known as sampstat.
Previoulsy known as sampstat.
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Holds montly average climate data such as rainfall, temperature or cloud cover. This is based on locations rather than accessions like most of the other tables in Germinate.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
climate_id
int(10, 0)
Default:
0
Foreign key to climates (climates.id).
Foreign key to climates (climates.id).
Default:
0
3
location_id
int(10, 0)
Default:
0
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
Default:
0
4
climate_value
double(64, 10)
Value for the specific climate attribute. These are monthly averages and not daily. Monthly data is required for the current Germinate climate viisualizations and interface.
Value for the specific climate attribute. These are monthly averages and not daily. Monthly data is required for the current Germinate climate viisualizations and interface.
5
dataset_id
int(10, 0)
Foreign key to datasets (datasets.id).
Foreign key to datasets (datasets.id).
6
recording_date
varchar(32)
The month that the data was recorded. This uses an integer to represent the month (1-12).
The month that the data was recorded. This uses an integer to represent the month (1-12).
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Climate overlays can be used in conjunction with Google Maps in order to visualize climate data in a geographic context.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
climate_id
int(10, 0)
Foreign key to climates (climates.id).
Foreign key to climates (climates.id).
3
path
varchar(255)
This is the path for holding images which can be used as overlays for the Google Maps representation in Germinate. The path is relative.
This is the path for holding images which can be used as overlays for the Google Maps representation in Germinate. The path is relative.
4
bottom_left_longitude
double(64, 10)
Allows the allignment of images against Google Maps API.
Allows the allignment of images against Google Maps API.
5
bottom_left_latitude
double(64, 10)
Allows the allignment of images against Google Maps API.
Allows the allignment of images against Google Maps API.
6
top_right_longitude
double(64, 10)
Allows the allignment of images against Google Maps API.
Allows the allignment of images against Google Maps API.
7
top_right_latitude
double(64, 10)
Allows the allignment of images against Google Maps API.
Allows the allignment of images against Google Maps API.
8
is_legend
tinyint(3, 0)
Default:
0
The legend for the image. What colours represent in the overlays. This is not required but used if present.
The legend for the image. What colours represent in the overlays. This is not required but used if present.
Default:
0
9
description
varchar(255)
Describes the climate overlay if additional explanation of the overlay image is required.
Describes the climate overlay if additional explanation of the overlay image is required.
10
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
11
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines climates. Climates are measureable weather type characteristics such as temperature or cloud cover.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Describes the climate.
Describes the climate.
3
short_name
char(10)
Shortened version of the climate name which is used in some table headers.
Shortened version of the climate name which is used in some table headers.
4
description
text
A longer description of the climate.
A longer description of the climate.
5
datatype
enum
Default:
int
Defines the datatype which can be FLOAT, INT or CHAR type.
Defines the datatype which can be FLOAT, INT or CHAR type.
Default:
int
6
unit_id
int(10, 0)
Foreign key to units (units.id).
Foreign key to units (units.id).
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Last name (surname) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
Last name (surname) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
3
last_name
varchar(255)
First name (and middle name if available) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
First name (and middle name if available) of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
4
email
varchar(255)
E-mail address of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
E-mail address of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
5
phone
varchar(255)
Phone number of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
Phone number of the author(s), researcher(s), scientist(s), student(s) responsible for producing the information product.
6
institution_id
int(10, 0)
Author's affiliation when the resource was created. Foreign key to 'institutions'
Author's affiliation when the resource was created. Foreign key to 'institutions'
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
The coding scheme proposed can be used at 2 different levels of detail: either by using the general codes such as 10, 20, 30, 40, etc., or by using the more specific codes, such as 11, 12, etc. See Multi Crop Passport Descriptors (MCPD V2 2012) for further definitions.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
collsrc
varchar(255)
collsrc in the Multi Crop Passport Descriptors (MCPD V2 2012)
collsrc in the Multi Crop Passport Descriptors (MCPD V2 2012)
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Comments can be added to different entries in Germinate such as entries from germinatebase or markers from the markers table.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
commenttype_id
int(10, 0)
Default:
0
Foreign key to commentypes (commenttypes.id).
Foreign key to commentypes (commenttypes.id).
Default:
0
3
user_id
int(10, 0)
Foreign key to Gatekeeper users (Gatekeeper users.id).
Foreign key to Gatekeeper users (Gatekeeper users.id).
4
visibility
tinyint(3, 0)
Defines if the comment is available or masked (hidden) from the interface.
Defines if the comment is available or masked (hidden) from the interface.
5
description
text
The comment content.
The comment content.
6
reference_id
int(10, 0)
Default:
0
Relates to the UID of the table to which the comment relates
Relates to the UID of the table to which the comment relates
Default:
0
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
text
Describes the comment type.
Describes the comment type.
3
reference_table
varchar(50)
This could include 'germinatebase' or 'markers' to define the table that the comment relates to.
This could include 'germinatebase' or 'markers' to define the table that the comment relates to.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
compound_id
int(10, 0)
Foreign key compounds (compounds.id).
Foreign key compounds (compounds.id).
3
germinatebase_id
int(10, 0)
Foreign key germinatebase (germinatebase.id).
Foreign key germinatebase (germinatebase.id).
4
dataset_id
int(10, 0)
Foreign key datasets (datasets.id).
Foreign key datasets (datasets.id).
5
analysismethod_id
int(10, 0)
Foreign key analysismethods (analysismethods.id).
Foreign key analysismethods (analysismethods.id).
6
compound_value
decimal(64, 10)
The compound value for this compound_id and germinatebase_id combination.
The compound value for this compound_id and germinatebase_id combination.
7
recording_date
datetime
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.
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.
8
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
9
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Compound full name.
Compound full name.
3
description
varchar(255)
Full description of the compound. This should contain enough infomation to accurately identify the compound and how it was recorded.
Full description of the compound. This should contain enough infomation to accurately identify the compound and how it was recorded.
4
molecular_formula
varchar(255)
The molecular formula of the compound.
The molecular formula of the compound.
5
monoisotopic_mass
decimal(64, 10)
The monoisotopic mass of the compound.
The monoisotopic mass of the compound.
6
average_mass
decimal(64, 10)
The average mass of the compound.
The average mass of the compound.
7
class
varchar(255)
A classification of the compound.
A classification of the compound.
8
unit_id
int(10, 0)
Foreign Key to units (units.id).
Foreign Key to units (units.id).
9
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
10
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Countries that are used in the locations type tables in Germinate. These are the ISO codes for countries.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
country_code2
char(2)
ISO 2 Code for country.
ISO 2 Code for country.
3
country_code3
char(3)
ISO 3 Code for country.
ISO 3 Code for country.
4
country_name
varchar(255)
Country name.
Country name.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines dataset sizes for the items in the datasets table. This table is automatically updated every hour.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
dataset_id
int(10, 0)
Foreign key to [datasets] ([datasets].id).
Foreign key to [datasets] ([datasets].id).
3
nr_of_data_objects
int(10, 0)
The number of data objects contained in this dataset.
The number of data objects contained in this dataset.
4
nr_of_data_points
int(10, 0)
The number of individual data points contained in this dataset.
The number of individual data points contained in this dataset.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
This defines which users can view which datasets. Requires Germinate Gatekeeper. This overrides the datasets state.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
dataset_id
int(10, 0)
Foreign key to datasets (datasets.id).
Foreign key to datasets (datasets.id).
3
user_id
int(10, 0)
Foreign key to Gatekeeper users (Gatekeeper usersid).
Foreign key to Gatekeeper users (Gatekeeper usersid).
4
group_id
int(10, 0)
Foreign key to usergroups table.
Foreign key to usergroups table.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Datasets which are defined within Germinate although there can be external datasets which are links out to external data sources most will be held within Germinate.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
experiment_id
int(10, 0)
Default:
0
Foreign key to experiments (experiments.id).
Foreign key to experiments (experiments.id).
Default:
0
3
location_id
int(10, 0)
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
4
description
text
Describes the dataset.
Describes the dataset.
5
date_start
date
Date that the dataset was generated.
Date that the dataset was generated.
6
date_end
date
Date at which the dataset recording ended.
Date at which the dataset recording ended.
7
source_file
varchar(255)
8
datatype
varchar(255)
A description of the data type of the contained data. Examples might be: "raw data", "BLUPs", etc.
A description of the data type of the contained data. Examples might be: "raw data", "BLUPs", etc.
9
dublin_core
json
10
version
char(10)
Dataset version if this exists.
Dataset version if this exists.
11
created_by
int(10, 0)
Defines who created the dataset. This is a FK in Gatekeeper users table. Foreign key to Gatekeeper users (users.id).
Defines who created the dataset. This is a FK in Gatekeeper users table. Foreign key to Gatekeeper users (users.id).
12
dataset_state_id
int(10, 0)
Default:
1
Foreign key to datasetstates (datasetstates.id).
Foreign key to datasetstates (datasetstates.id).
Default:
1
13
license_id
int(10, 0)
14
is_external
tinyint(3, 0)
Default:
0
Defines if the dataset is contained within Germinate or from an external source and not stored in the database.
Defines if the dataset is contained within Germinate or from an external source and not stored in the database.
Default:
0
15
hyperlink
varchar(255)
Link to access the external dasets.
Link to access the external dasets.
16
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
17
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
18
contact
varchar(255)
The contact to get more information about this dataset.
The contact to get more information about this dataset.
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Defines the datasetstate.
Defines the datasetstate.
3
description
varchar(255)
Describes the datasetstate.
Describes the datasetstate.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
experiment_name
varchar(255)
The name of the experiment.
The name of the experiment.
3
user_id
int(10, 0)
Foreign key to Gatekeeper users (Gatekeeper users.id).
Foreign key to Gatekeeper users (Gatekeeper users.id).
4
description
text
Describes the experiment.
Describes the experiment.
5
experiment_date
date
The date that the experiment was carried out.
The date that the experiment was carried out.
6
experiment_type_id
int(10, 0)
Foreign key to experimenttypes (experimenttypes.id).
Foreign key to experimenttypes (experimenttypes.id).
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
varchar(255)
Describes the experiment type.
Describes the experiment type.
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Germinatebase is the Germinate base table which contains passport and other germplasm definition data.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
general_identifier
varchar(255)
A unique identifier.
A unique identifier.
3
number
varchar(255)
This is the unique identifier for accessions within a genebank, and is assigned when a sample is
entered into the genebank collection (e.g. ‘PI 113869’).
This is the unique identifier for accessions within a genebank, and is assigned when a sample is
entered into the genebank collection (e.g. ‘PI 113869’).
4
name
varchar(255)
A unique name which defines an entry in the germinatbase table.
A unique name which defines an entry in the germinatbase table.
5
bank_number
varchar(255)
Alternative genebank number.
Alternative genebank number.
6
breeders_code
char(50)
FAO WIEWS code of the institute that has bred the material. If the holding institute has bred the material, the breeding institute code (BREDCODE) should be the same as the holding institute code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon without space.
FAO WIEWS code of the institute that has bred the material. If the holding institute has bred the material, the breeding institute code (BREDCODE) should be the same as the holding institute code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon without space.
7
breeders_name
varchar(255)
Name of the institute (or person) that bred the material. This descriptor should be used only if BREDCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple names are separated by a semicolon without space.
Name of the institute (or person) that bred the material. This descriptor should be used only if BREDCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple names are separated by a semicolon without space.
8
subtaxa_id
int(10, 0)
Foreign key to subtaxa (subtaxa.id).
Foreign key to subtaxa (subtaxa.id).
9
taxonomy_id
int(10, 0)
Foreign key to taxonomies (taxonomies.id).
Foreign key to taxonomies (taxonomies.id).
10
institution_id
int(10, 0)
Foreign key to institutions (institutions.id).
Foreign key to institutions (institutions.id).
11
plant_passport
varchar(255)
Record if the entry has a plant passport.
Record if the entry has a plant passport.
12
donor_code
varchar(255)
FAO WIEWS code of the donor institute. Follows INSTCODE standard.
FAO WIEWS code of the donor institute. Follows INSTCODE standard.
13
donor_name
varchar(255)
Name of the donor institute (or person). This descriptor should be used only if DONORCODE cannot be filled because the FAO WIEWS code for this institute is not available.
Name of the donor institute (or person). This descriptor should be used only if DONORCODE cannot be filled because the FAO WIEWS code for this institute is not available.
14
donor_number
varchar(255)
Identifier assigned to an accession by the donor. Follows ACCENUMB standard.
Identifier assigned to an accession by the donor. Follows ACCENUMB standard.
15
acqdate
varchar(255)
Date on which the accession entered the collection where YYYY is the year, MM is the month and
DD is the day. Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero].
Date on which the accession entered the collection where YYYY is the year, MM is the month and
DD is the day. Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero].
16
collnumb
varchar(255)
Original identifier assigned by the collector(s) of the sample, normally composed of the name or
initials of the collector(s) followed by a number (e.g. ‘FM9909’). This identifier is essential for
identifying duplicates held in different collections.
Original identifier assigned by the collector(s) of the sample, normally composed of the name or
initials of the collector(s) followed by a number (e.g. ‘FM9909’). This identifier is essential for
identifying duplicates held in different collections.
17
colldate
date
Collecting date of the sample, where YYYY is the year, MM is the month and DD is the day.
Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero].
Collecting date of the sample, where YYYY is the year, MM is the month and DD is the day.
Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero].
18
collcode
varchar(255)
FAO WIEWS code of the institute collecting the sample. If the holding institute has collected the
material, the collecting institute code (COLLCODE) should be the same as the holding institute
code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon
without space.
FAO WIEWS code of the institute collecting the sample. If the holding institute has collected the
material, the collecting institute code (COLLCODE) should be the same as the holding institute
code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon
without space.
19
collname
varchar(255)
Name of the institute collecting the sample. This descriptor should be used only if COLLCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple values are separated by a semicolon without space.
Name of the institute collecting the sample. This descriptor should be used only if COLLCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple values are separated by a semicolon without space.
20
collmissid
varchar(255)
Identifier of the collecting mission used by the Collecting Institute (4 or 4.1) (e.g. 'CIATFOR-052', 'CN426').
Identifier of the collecting mission used by the Collecting Institute (4 or 4.1) (e.g. 'CIATFOR-052', 'CN426').
21
othernumb
text
Any other identifiers known to exist in other collections for this accession. Use the following format: INSTCODE:ACCENUMB;INSTCODE:identifier;… INSTCODE and identifier are separated by a colon without space. Pairs of INSTCODE and identifier are separated by a semicolon without space. When the institute is not known, the identifier should be preceded by a colon.
Any other identifiers known to exist in other collections for this accession. Use the following format: INSTCODE:ACCENUMB;INSTCODE:identifier;… INSTCODE and identifier are separated by a colon without space. Pairs of INSTCODE and identifier are separated by a semicolon without space. When the institute is not known, the identifier should be preceded by a colon.
22
duplsite
varchar(255)
FAO WIEWS code of the institute(s) where a safety duplicate of the accession is maintained.
Multiple values are separated by a semicolon without space. Follows INSTCODE standard.
FAO WIEWS code of the institute(s) where a safety duplicate of the accession is maintained.
Multiple values are separated by a semicolon without space. Follows INSTCODE standard.
23
duplinstname
varchar(255)
Name of the institute where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space.
Name of the institute where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space.
24
mlsstatus_id
int(10, 0)
Foreign key to mlsstatus (mlsstatus.id).
Foreign key to mlsstatus (mlsstatus.id).
25
puid
varchar(255)
Any persistent, unique identifier assigned to the accession so it can be unambiguously referenced at the global level and the information associated with it harvested through automated means. Report one PUID for each accession.
Any persistent, unique identifier assigned to the accession so it can be unambiguously referenced at the global level and the information associated with it harvested through automated means. Report one PUID for each accession.
26
biologicalstatus_id
int(10, 0)
Foreign key to biologicalstatus (biologicalstaus.id).
Foreign key to biologicalstatus (biologicalstaus.id).
27
collsrc_id
int(10, 0)
Foreign key to collectionsources (collectionsources.id).
Foreign key to collectionsources (collectionsources.id).
28
location_id
int(10, 0)
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
29
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
30
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines which entities are contained within a group. These can be the primary key from any table.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
foreign_id
int(10, 0)
Foreign key to [table] ([table].id).
Foreign key to [table] ([table].id).
3
group_id
int(10, 0)
Foreign key to groups (groups.id).
Foreign key to groups (groups.id).
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Allows the definition of groups within Germinate. Germinate supports a number of different group types such as germinatebase accesion groups and marker groups.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
grouptype_id
int(10, 0)
Foreign key to grouptypes (grouptypes.id).
Foreign key to grouptypes (grouptypes.id).
3
name
varchar(255)
The name of the group which can be used to identify it.
The name of the group which can be used to identify it.
4
description
text
A free text description of the group. This has no length limitations.
A free text description of the group. This has no length limitations.
5
visibility
tinyint(3, 0)
Defines if the group is visuble or hidden from the Germinate user interface.
Defines if the group is visuble or hidden from the Germinate user interface.
6
created_by
int(10, 0)
Defines who created the group. Foreign key to Gatekeeper users (Gatekeeper users.id).
Defines who created the group. Foreign key to Gatekeeper users (Gatekeeper users.id).
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
imagetype_id
int(10, 0)
Default:
0
Foreign key to imagetypes (imagetypes.id).
Foreign key to imagetypes (imagetypes.id).
Default:
0
3
description
text
A description of what the image shows if required.
A description of what the image shows if required.
4
foreign_id
int(10, 0)
Default:
0
Relates to the UID of the table to which the comment relates.
Relates to the UID of the table to which the comment relates.
Default:
0
5
path
text
The file system path to the image.
The file system path to the image.
6
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
7
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
text
A description of the image type. This would usually be a description of what the image was showing in general terms such as 'field image' or 'insitu hybridisation images'.
A description of the image type. This would usually be a description of what the image was showing in general terms such as 'field image' or 'insitu hybridisation images'.
3
reference_table
varchar(50)
The table which the image type relates to.
The table which the image type relates to.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines institutions within Germinate. Accessions may be associated with an institute and this can be defined here.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
code
varchar(255)
If there is a defined ISO code for the institute this should be used here.
If there is a defined ISO code for the institute this should be used here.
3
name
varchar(255)
The institute name.
The institute name.
4
acronym
varchar(20)
If there is an acronym for the institute.
If there is an acronym for the institute.
5
country_id
int(10, 0)
Default:
0
Foreign key to countries (countries.id).
Foreign key to countries (countries.id).
Default:
0
6
contact
varchar(255)
The contact at the institute which should be used for correspondence.
The contact at the institute which should be used for correspondence.
7
phone
varchar(255)
The telephone number for the institute.
The telephone number for the institute.
8
email
varchar(255)
The email address to contact the institute.
The email address to contact the institute.
9
address
text
The postal address of the institute.
The postal address of the institute.
10
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
11
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Germinate allows to define external links for different types of data. With this feature you can define links to external resources.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
linktype_id
int(10, 0)
Foreign key to linktypes (linktypes.id).
Foreign key to linktypes (linktypes.id).
3
foreign_id
int(10, 0)
4
hyperlink
varchar(255)
The actual hyperlink.
The actual hyperlink.
5
description
varchar(255)
A description of the link.
A description of the link.
6
visibility
tinyint(3, 0)
Default:
1
Determines if the link is visible or not: {0, 1}
Determines if the link is visible or not: {0, 1}
Default:
1
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
The link type determines which database table and column are used to construct the final link. The ”placeholder” in the link (from the links table) will be replaced by the value of the ”target column” in the ”target table”
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
varchar(255)
A description of the link
.
A description of the link
.
3
target_table
varchar(255)
This is the table that the link links to.
This is the table that the link links to.
4
target_column
varchar(255)
This is the column that is used to generate the link.
This is the column that is used to generate the link.
5
placeholder
varchar(255)
The part of the link that will be replaced by the value of the target column.
The part of the link that will be replaced by the value of the target column.
6
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
7
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Describes locations. Locations can be collecting sites or the location of any geographical feature such as research institutes or lab locations.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
locationtype_id
int(10, 0)
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
3
country_id
int(10, 0)
Default:
0
Foreign key to countries (countries.id).
Foreign key to countries (countries.id).
Default:
0
4
state
varchar(255)
The state where the location is if this exists.
The state where the location is if this exists.
5
region
varchar(255)
The region where the location is if this exists.
The region where the location is if this exists.
6
site_name
varchar(255)
The site name where the location is.
The site name where the location is.
7
site_name_short
varchar(22)
Shortened site name which can be used in tables within Germinate.
Shortened site name which can be used in tables within Germinate.
8
elevation
decimal(64, 10)
The elevation of the site in metres.
The elevation of the site in metres.
9
latitude
decimal(64, 10)
Latitude of the location.
Latitude of the location.
10
longitude
decimal(64, 10)
Longitude of the location.
Longitude of the location.
11
coordinate_uncertainty
int(10, 0)
Uncertainty associated with the coordinates in metres. Leave the value empty if the uncertainty is unknown.
Uncertainty associated with the coordinates in metres. Leave the value empty if the uncertainty is unknown.
12
coordinate_datum
varchar(255)
The geodetic datum or spatial reference system upon which the coordinates given in decimal latitude and decimal longitude are based (e.g. WGS84, ETRS89, NAD83). The GPS uses the WGS84 datum.
The geodetic datum or spatial reference system upon which the coordinates given in decimal latitude and decimal longitude are based (e.g. WGS84, ETRS89, NAD83). The GPS uses the WGS84 datum.
13
georeferencing_method
varchar(255)
The georeferencing method used (GPS, determined from map, gazetteer, or estimated using software). Leave the value empty if georeferencing method is not known.
The georeferencing method used (GPS, determined from map, gazetteer, or estimated using software). Leave the value empty if georeferencing method is not known.
14
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
15
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The name of the location type.
The name of the location type.
3
description
varchar(255)
A description of the location type.
A description of the location type.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Relates genetic markers to a map and assigns a position (if known). Maps are made up of lists of markers and positions (genetic or physiscal and chromosome/linkage group assignation). In the case of QTL the definition_start and definition_end columns can be used to specify a range across a linkage group.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
mapfeaturetype_id
int(10, 0)
Foreign key to mapfeaturetypes (mapfeaturetypes.id).
Foreign key to mapfeaturetypes (mapfeaturetypes.id).
3
marker_id
int(10, 0)
Foreign key to markers (markers.id).
Foreign key to markers (markers.id).
4
map_id
int(10, 0)
Foreign key to maps (maps.id).
Foreign key to maps (maps.id).
5
definition_start
double(64, 10)
Used if the markers location spans over an area more than a single point on the maps. Determines the marker start location.
Used if the markers location spans over an area more than a single point on the maps. Determines the marker start location.
6
definition_end
double(64, 10)
Used if the markers location spans over an area more than a single point on the maps. Determines the marker end location.
Used if the markers location spans over an area more than a single point on the maps. Determines the marker end location.
7
chromosome
varchar(255)
The chromosome/linkage group that this marker is found on.
The chromosome/linkage group that this marker is found on.
8
arm_impute
varchar(255)
If a chromosome arm is available then this can be entered here.
If a chromosome arm is available then this can be entered here.
9
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
10
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines features which can exist on maps. In general this will be the marker type but it can also be used to identify QTL regions.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
varchar(255)
Description of the feature type. This could include a definition of the marker type such as 'SNP', 'KASP' or 'AFLP'.
Description of the feature type. This could include a definition of the marker type such as 'SNP', 'KASP' or 'AFLP'.
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Describes genetic maps that have been defined within Germinate.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
varchar(255)
Describes the map.
Describes the map.
3
visibility
int(10, 0)
Determines if the map is visible to the Germinate interface or hidden.
Determines if the map is visible to the Germinate interface or hidden.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
6
user_id
int(10, 0)
Foreign key to Gatekeeper users (Gatekeeper users.id).
Foreign key to Gatekeeper users (Gatekeeper users.id).
Defines genetic markers within the database and assigns a type (markertypes).
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
markertype_id
int(10, 0)
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
3
marker_name
varchar(45)
The name of the marker. This should be a unique name which identifies the marker.
The name of the marker. This should be a unique name which identifies the marker.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Describes the marker type. Markers (markers) have a defined type. This could be AFLP, MicroSat, SNP and so on. Used to differentiate markers within the markers table and alllows for mixing of marker types on genetic and physical maps.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
description
varchar(255)
Describes the marker type. Markers (markers) have a defined type. This could be AFLP, MicroSat, SNP and so on.
Describes the marker type. Markers (markers) have a defined type. This could be AFLP, MicroSat, SNP and so on.
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Describes mega environment data by grouping collection sites (locations) into mega environments. Mega environments in this context are collections of sites which meet the mega environment definition criteria.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
location_id
int(10, 0)
Foreign key to locations (locations.id).
Foreign key to locations (locations.id).
3
source_id
int(10, 0)
Source ID
Source ID
4
megaenvironment_id
int(10, 0)
Foreign key to megaenvironments (megaenvironments.id).
Foreign key to megaenvironments (megaenvironments.id).
5
is_final
tinyint(3, 0)
The source that was used to determine the megaenvironment data.
The source that was used to determine the megaenvironment data.
6
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
7
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines the mega environments if used and their temperature and precipitation ranges.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The mega environment name.
The mega environment name.
3
max_temp_lower
int(10, 0)
The lower maximum temperature for this environment.
The lower maximum temperature for this environment.
4
max_temp_upper
int(10, 0)
The maximum temperature for this environment.
The maximum temperature for this environment.
5
precip_lower
int(10, 0)
The minimum precipitation for this environment.
The minimum precipitation for this environment.
6
precip_upper
int(10, 0)
the maximum precipitation for this environment.
the maximum precipitation for this environment.
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Contains information relating to the source of the mega environments. This could be the contributing source including contact and location details or how the mega environments were extracted from current datasets.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The name of the mega environment source.
The name of the mega environment source.
3
description
text
Describes the mega environment source.
Describes the mega environment source.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Holds news items that are displayed within Germinate.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
newstype_id
int(10, 0)
Foreign key newstypes (newstypes.id).
Foreign key newstypes (newstypes.id).
3
title
varchar(255)
A title which is used to name this news item. This appears in the Germinate user interface if used.
A title which is used to name this news item. This appears in the Germinate user interface if used.
4
content
text
The textual content of this news item.
The textual content of this news item.
5
image
varchar(255)
Image to use with this news item.
Image to use with this news item.
6
hyperlink
varchar(255)
HTML hyperlink to use for this news item. This can be a link to another source which contains more information or a link to the original source.
HTML hyperlink to use for this news item. This can be a link to another source which contains more information or a link to the original source.
7
user_id
int(10, 0)
Foreign key users (users.id).
Foreign key users (users.id).
8
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
9
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Defines the news types which are contained the database. The news types are displayed on the Germinate user interface and are not required if the user interface is not used.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Name of the news type.
Name of the news type.
3
description
varchar(255)
A longer description of the news type.
A longer description of the news type.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
This table holds the actual pedigree definition data.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
germinatebase_id
int(10, 0)
Foreign key to germinatebase (germinatebase.id).
Foreign key to germinatebase (germinatebase.id).
3
pedigreenotation_id
int(10, 0)
Foreign key to pedigreenotations (pedigreenotations.id).
Foreign key to pedigreenotations (pedigreenotations.id).
4
pedigreedescription_id
int(10, 0)
5
definition
text
The pedigree string which is used to represent the germinatebase entry.
The pedigree string which is used to represent the germinatebase entry.
6
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
7
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Description of pedigrees. Pedigrees can have a description which details additional information about the pedigree, how it was constructed and who the contact is for the pedigree.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The name of the pedigree.
The name of the pedigree.
3
description
text
Describes the pedigree in more detail.
Describes the pedigree in more detail.
4
author
varchar(255)
Who is responsible for the creation of the pedigree. Attribution should be included in here for pedigree sources.
Who is responsible for the creation of the pedigree. Attribution should be included in here for pedigree sources.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Allows additional supporting data to be associated with a pedigree definition such as the contributing data source.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Name of the reference notation source.
Name of the reference notation source.
3
description
text
A longer description about the reference notation source.
A longer description about the reference notation source.
4
reference_url
varchar(255)
Hyperlink to the notation source.
Hyperlink to the notation source.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Holds pedigree definitions. A pedigree is constructed from a series of individial->parent records. This gives a great deal of flexibility in how pedigree networks can be constructed. This table is required for operation with the Helium pedigree viewer.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
germinatebase_id
int(10, 0)
Foreign key germinatebase (germinatebase.id).
Foreign key germinatebase (germinatebase.id).
3
parent_id
int(10, 0)
Foreign key germinatebase (germinatebase.id). This is the parrent of the individual identified in the germinatebase_id column.
Foreign key germinatebase (germinatebase.id). This is the parrent of the individual identified in the germinatebase_id column.
4
relationship_type
enum
Default:
OTHER
Male or Female parent. Should be recorded as 'M' (male) or 'F' (female).
Male or Female parent. Should be recorded as 'M' (male) or 'F' (female).
Default:
OTHER
Can be used as a meta-data field to describe the relationships if a complex rellationship is required. Examples may include, 'is a complex cross containing', 'F4 generation' and so on. This is used by the Helium pedigree visualiztion tool.
Can be used as a meta-data field to describe the relationships if a complex rellationship is required. Examples may include, 'is a complex cross containing', 'F4 generation' and so on. This is used by the Helium pedigree visualiztion tool.
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
The phenotype value for this phenotype_id and germinatebase_id combination.
The phenotype value for this phenotype_id and germinatebase_id combination.
5
dataset_id
int(10, 0)
Foreign key datasets (datasets.id).
Foreign key datasets (datasets.id).
6
recording_date
datetime
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.
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.
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
Phenotype full name.
Phenotype full name.
3
short_name
char(10)
Shortened name for the phenotype. This is used in table columns where space is an issue.
Shortened name for the phenotype. This is used in table columns where space is an issue.
4
description
text
Full description of the phenotype. This should contain enough infomation to accurately identify the phenoytpe and how it was recorded.
Full description of the phenotype. This should contain enough infomation to accurately identify the phenoytpe and how it was recorded.
5
datatype
enum
Default:
int
Defines the data type of the phenotype. This can be of float, int or char types.
Defines the data type of the phenotype. This can be of float, int or char types.
Default:
int
6
unit_id
int(10, 0)
Foreign Key to units (units.id).
Foreign Key to units (units.id).
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Holds information relating to subtaxa if available.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
taxonomy_id
int(10, 0)
Default:
0
Foreign key to the taxonomies table. A taxonomy may, or may not, have a subtaxa.
Foreign key to the taxonomies table. A taxonomy may, or may not, have a subtaxa.
Default:
0
3
subtaxa_author
varchar(255)
also known as subtauthor in the Multi Crop Passport Descriptors (MCPD V2 2012).
also known as subtauthor in the Multi Crop Passport Descriptors (MCPD V2 2012).
4
taxonomic_identifier
varchar(255)
Subtaxa name.
Subtaxa name.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
Allows the definition of synonyms for entries such as germinatebase entries or marker names.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
foreign_id
int(10, 0)
Foreign key to target table (l[targettable].id).
Foreign key to target table (l[targettable].id).
3
synonymtype_id
int(10, 0)
Foreign key to synonymtypes (synonymnstypes.id).
Foreign key to synonymtypes (synonymnstypes.id).
4
synonym
varchar(255)
The synonym.
The synonym.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
target_table
varchar(255)
The target table.
The target table.
3
name
varchar(255)
Name of the synonym type.
Name of the synonym type.
4
description
varchar(255)
Description of the type.
Description of the type.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
The species table holds information relating to the species that are deinfed within a particular Germinate instance including common names and ploidy levels.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
genus
varchar(255)
Genus name for the species.
Genus name for the species.
3
species
varchar(255)
Species name in lowercase.
Species name in lowercase.
4
species_author
varchar(255)
also known as spauthor in the Multi Crop Passport Descriptors (MCPD V2 2012). Describes the authority for the species name.
also known as spauthor in the Multi Crop Passport Descriptors (MCPD V2 2012). Describes the authority for the species name.
5
cropname
varchar(255)
The name of the crop. This should be the common name. Examples would include barley, maize, wheat, rice and so on.
The name of the crop. This should be the common name. Examples would include barley, maize, wheat, rice and so on.
6
ploidy
int(10, 0)
Defines the ploidy level for the species. Use numbers to reference ploidy for example diploid = 2, tetraploid = 4.
Defines the ploidy level for the species. Use numbers to reference ploidy for example diploid = 2, tetraploid = 4.
7
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
8
updated_on
timestamp
Default:
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.
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
For trials data the treatment is used to distinguish between factors. Examples would include whether the trial was treated with fungicides or not.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
name
varchar(255)
The name which defines the treatment.
The name which defines the treatment.
3
description
varchar(255)
A longer descripiton of the treatment. This should include enough information to be able to identify what the treatment was and why it was applied.
A longer descripiton of the treatment. This should include enough information to be able to identify what the treatment was and why it was applied.
4
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
Holds the names of trial series. Trial series define the name of the trial to which trials data is associated. Examples would include the overarching project.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
seriesname
varchar(255)
The description of the trial series name.
The description of the trial series name.
3
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
4
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
The 'units' table holds descriptions of the various units that are used in the Germinate database. Examples of these would include International System of Units (SI) base units: kilogram, meter, second, ampere, kelvin, candela and mole but can include any units that are required.
Columns
PK
Name
Data type
Null
Attributes
Description
1
id
int(10, 0)
Identity / Auto increment column
Primary id for this table. This uniquely identifies the row.
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
2
unit_name
varchar(255)
The name of the unit. This should be the name of the unit in full.
The name of the unit. This should be the name of the unit in full.
3
unit_abbreviation
char(10)
This should be the unit abbreviation.
This should be the unit abbreviation.
4
unit_description
text
A description of the unit. If the unit is not a standard SI unit then it is beneficial to have a description which explains what the unit it, how it is derived and any other information which would help identifiy it.
A description of the unit. If the unit is not a standard SI unit then it is beneficial to have a description which explains what the unit it, how it is derived and any other information which would help identifiy it.
5
created_on
datetime
Default:
CURRENT_TIMESTAMP
When the record was created.
When the record was created.
Default:
CURRENT_TIMESTAMP
6
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP
Unique keys
Key name
Columns
Description
PRIMARY
id
Exported: 2017-11-01 15:10, Last imported: 2017-10-31 13:00
When the record was created.
Default:
CURRENT_TIMESTAMP
5
updated_on
timestamp
Default:
CURRENT_TIMESTAMP
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
When the record was updated. This may be different from the created on date if changes have been made subsequently to the underlying record.
Default:
CURRENT_TIMESTAMP