The different hormones that may be extracted and analyzed.
HORMONE_IDS defines values for the Hormone column of HORMONE_KITS.
The code used to uniquely identify the hormone.
This column may not be NULL. This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
The value E has a
special meaning to the system. This is the only HORMONE_KITS.Hormone value that indicates the
kit measures concentration of estrogen. Also, the value is
used in the ESTROGENS view.
The value GC has a
special meaning to the system. This is the only HORMONE_KITS.Hormone value that indicates the
kit measures concentration of glucocorticoids. Also, the
value is used in the GLUCOCORTICOIDS
view.
The value P has a
special meaning to the system. This is the only HORMONE_KITS.Hormone value that indicates the
kit measures concentration of progesterone. Also, the value
is used in the PROGESTERONES view.
The value T has a
special meaning to the system. This is the only HORMONE_KITS.Hormone value that indicates the
kit measures concentration of testosterone. Also, the value
is used in the TESTOSTERONES view.
The value TH has
a special meaning to the system. This is the only HORMONE_KITS.Hormone value that indicates the
kit measures concentration of thyroid hormone. Also, the
value is used in the THYROID_HORMONES
view.
The different procedures that may be performed in preparation for hormone analyses.
HORMONE_PREP_PROCEDURES defines values for the Procedure column of HORMONE_PREP_DATA.
The code used to uniquely identify the procedure.
This column may not be NULL. This column may not be empty, it must contain characters,
and it must contain at least one non-whitespace character.
The value MEOH_EXT has
a special meaning to the system. This is the only HORMONE_PREP_DATA.Procedure value that indicates
a methanol extraction. Also, this value is used in the
ESTROGENS, GLUCOCORTICOIDS, PROGESTERONES, and TESTOSTERONES views.
The value SPE has a
special meaning to the system. This is the only HORMONE_PREP_DATA.Procedure value that indicates
a solid-phase extraction. Also, this value is used in the
ESTROGENS, GLUCOCORTICOIDS, PROGESTERONES, and TESTOSTERONES views.
The value ETOH_EXT has
a special meaning to the system. This is the only HORMONE_PREP_DATA.Procedure value that indicates
an ethanol extraction. Also, this value is used in the
THYROID_HORMONES view.
The different software types used for genetic hybrid score analyses.
HYBRIDGENE_SOFTWARE defines values for the Software column of HYBRIDGENE_ANALYSES.
The genetic marker types used in genetic hybrid score analyses.
MARKERS defines values for the Marker column of HYBRIDGENE_ANALYSES.
The different categories of healing progress used in wound/pathology healing updates.
WP_HEALSTATUSES defines values for the HealStatus column of WP_HEALUPDATES.
The possible statuses describing the current state of a wound/pathology report.
WP_REPORTSTATES defines values for the ReportState column of WP_REPORTS.
The codes defining all the possible wounds and pathologies.
The ImpairsLocomotion and InfectionSigns columns affect
validation of the identically-named columns in WP_DETAILS. For each code, all WP_DETAILS.ImpairsLocomotion values must equal the
related ImpairsLocomotion
in this table, unless this table's ImpairsLocomotion is
NULL. Likewise with InfectionSigns, for each code, all
WP_DETAILS.InfectionSigns values must equal the
related InfectionSigns in
this table, unless this table's InfectionSigns is NULL.
WP_WOUNDPATHCODES defines values for the WoundPathCode column of WP_DETAILS.
A character, indicating the required WP_DETAILS.ImpairsLocomotion value, if any, for this WoundPathCode.
This column may be NULL, when there is no required
ImpairsLocomotion for this
WoundPathCode.
A character, indicating the required WP_DETAILS.InfectionSigns value, if any, for this WoundPathCode.
This column may be NULL, when there is no required
InfectionSigns for this
WoundPathCode.