trialseries


Description

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

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
phenotypedata.trialseries_id phenotypedata_ibfk_6N

Primary id for this table. This uniquely identifies the row.

seriesname VARCHAR 255 null

The description of the trial series name.

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 changes have been made subsequently to the underlying record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships