The possible locales where tissue and nucleic acid samples can be stored or used.
INSTITUTIONS defines values for the Institution column in LOCATIONS, NUCACID_DATA, NUCACID_LOCAL_IDS, TISSUE_DATA, and TISSUE_LOCAL_IDS.
The value 1 has
special meaning to the system. It is used in the TISSUES, NUCACIDS, and NUCACIDS_W_CONC views to help populate each
view's respective LocalId_1 column.
The value 2 has
special meaning to the system. It is used in the TISSUES, NUCACIDS, and NUCACIDS_W_CONC views to help populate each
view's respective LocalId_2 column.
The possible levels of confidence in the identity of a tissue sample.
MISID_STATUSES defines values for TISSUE_DATA.Misid_Status.
The possible methods for quantifying nucleic acid concentrations.
NUCACID_CONC_METHODS defines values for NUCACID_CONC_DATA.Conc_Method.
The value 1 has a
special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that
indicates quantification by quantitative PCR ("qPCR"). Also,
this value is used in the definition of
the NUCACIDS_W_CONC view.
The value 2
has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that
indicates quantification with a Nanodrop
spectrophotometer. Also, this value is used in the definition of
the NUCACIDS_W_CONC view.
The value 3 has
a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that
indicates quantification with a Qubit fluorometer. Also,
this value is used in the definition of
the NUCACIDS_W_CONC view.
The value
4 has a special
meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that
indicates quantification with a Bioanalyzer assay. Also,
this value is used in the definition of
the NUCACIDS_W_CONC view.
The value 5
has a special meaning to the system. This is the only NUCACID_CONC_DATA.Conc_Method value that
indicates quantification with a Quant-iT assay. Also, this
value is used in the definition of
the NUCACIDS_W_CONC view.
The possible methods for creating nucleic acid samples.
NUCACID_CREATION_METHODS defines values for NUCACID_DATA.Creation_Method.
The possible nucleic acid sample types.
NUCACID_TYPES defines values for NUCACID_DATA.NucAcid_Type.
This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.
The possible media used for storage/archiving of tissue samples.
STORAGE_MEDIA defines values for TISSUE_DATA.Storage_Medium.
This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.
The possible tissue sample types.
Some types of tissues, e.g. blood, cannot plausibly be collected after an individual has died or disappeared. Other tissue types may be collected during regular observation or sometime afterward, e.g. "skin" could be a puncture from a live animal or a patch of dry flesh from a found corpse. To validate the TISSUE_DATA.Collection_Date against the source individual's BIOGRAPH.Statdate, but also allow the flexibility to set different rules for different tissue types, this table includes the Max_After_Statdate column.
When the Max_After_Statdate column is not
NULL, all TISSUE_DATA rows that have this
row's Tissue_Type and that came from an individual in the main
population cannot have a Collection_Date that is more than
Max_After_Statdate days after
the individual's Statdate. That is,
tissue samples cannot be collected more than Max_After_Statdate days after the
individual's death/disappearance.
TISSUE_TYPES defines values for TISSUE_DATA.Tissue_Type.
A non-negative integer, indicating the maximum number of days that the Collection_Date of a TISSUE_DATA row with this Tissue_Type is allowed to exceed the source individual's BIOGRAPH.Statdate, if any.
This column may be NULL, indicating that the row's
Tissue_Type can be collected any number of days after the
Statdate.