Table cohort

cohort_id--varchar(6)--primary key--unique--the group of individuals that results from the cross of the two parents referenced below on this date are reffered to as a cohort. The cohort_id never changes. Organisms that are later tagged as individuals always belong to a cohort.

cohort_cross_date--Date--YYYYMMDD--the date on which the cross producing this cohort happened.

cohort_parent_1--the id of one of the parents of the cohort; may or may not be an id from the individual table (if not, the parent was not bred in the facility)

cohort_parent_2--the id of the other parent of the cohort; may or may not be an id from the individual table (if not, the parent was not bred in the facility)

cohort_location--ENUM(pool_1, pool_2, pool_3, pool_4, pool_5, pool_6, pool_7, pool_8, pool_9, pool_10, pool_11, pool_11, pool_12, pool_13, pool_14, pool_15, pool_16, pool_17, pool_18, pool_19, pool_20)--the pool in which the cohort resides (not necessarily the location in which the cross happened).

Table individual 

individual_id--varchar(6)--primary key--unique identifier for the individual organism that is identical to the identifier tag on the organism

ind_cohort_id--varchar(6)--foreign key to cohort_id in the cohort table--the cohort to which the individual belongs
 
ind_location--(text)--the tank, in which the individual organism stored


Table cohort_physical
This table is to be used for physical measurements of organisms that only have a cohort id and no individual id.

cphysical_auto_id--autogenerated unique id for each measurement

cphysical_cohort_id--varchar(6)--the cohort id of the organism tested. This field is a foreign key to cohort_id in the cohort table. This means that the the cohort needs to already be recorded in the cohort table before data can be entered about it in the cohort_physical table.


cphysical_length_mm--Double--the length of the organism in mm

cphysical_weight_g--Double--the weight of the organism in g


Table ind_physical
This table is to be used for physical measurements of organisms that already have an individual id. 

iphysical_auto_id--autogenerated unique id for each measurement

iphysical_cohort_id--varchar(6)--the individual id of the organism tested. This field is a foreign key to individual_id in the individual table. This means that the individual needs to already be recorded in the individual table before data can be entered about it in the ind_physical table.


iphysical_length_mm--Double--the length of the organism in mm

iphysical_weight_g--Double--the weight of the organism in g