Physical Traits

HORMONE_IDS

(THIS TABLE IS IN PROGRESS. IT DOES NOT YET ACTUALLY EXIST IN BABASE AS DESCRIBED BELOW, AND IT MAY APPEAR QUITE DIFFERENT WHEN/IF IT EVER DOES GET ADDED TO BABASE.)

The different hormones that may be extracted and analyzed.

Vocabulary For

HORMONE_IDS defines values for the Hormone column of HORMONE_KITS.

Key Name: Hormone

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.

Special Values

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.

HORMONE_PREP_PROCEDURES

(THIS TABLE IS IN PROGRESS. IT DOES NOT YET ACTUALLY EXIST IN BABASE AS DESCRIBED BELOW, AND IT MAY APPEAR QUITE DIFFERENT WHEN/IF IT EVER DOES GET ADDED TO BABASE.)

The different procedures that may be performed in preparation for hormone analyses.

Vocabulary For

HORMONE_PREP_PROCEDURES defines values for the Procedure column of HORMONE_PREP_DATA.

Key Name: Procedure

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.

Special Values

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.

HYBRIDGENE_SOFTWARE

The different software types used for genetic hybrid score analyses.

Vocabulary For

HYBRIDGENE_SOFTWARE defines values for the Software column of HYBRIDGENE_ANALYSES.

Key Name: Software

Software

Special Values

None.

MARKERS

The genetic marker types used in genetic hybrid score analyses.

Vocabulary For

MARKERS defines values for the Marker column of HYBRIDGENE_ANALYSES.

Key Name: Marker

Marker

Special Values

None.

WP_HEALSTATUSES

The different categories of healing progress used in wound/pathology healing updates.

Vocabulary For

WP_HEALSTATUSES defines values for the HealStatus column of WP_HEALUPDATES.

Key Name: HealStatus

HealStatus

Special Values

None.

WP_REPORTSTATES

The possible statuses describing the current state of a wound/pathology report.

Vocabulary For

WP_REPORTSTATES defines values for the ReportState column of WP_REPORTS.

Key Name: ReportState

ReportState

Special Values

None.

WP_WOUNDPATHCODES

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.

Vocabulary For

WP_WOUNDPATHCODES defines values for the WoundPathCode column of WP_DETAILS.

Key Name: WoundPathCode

WoundPathCode

Special Values

None.

The ImpairsLocomotion Column

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.

The InfectionSigns Column

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.


Page generated: 2021-09-17T11:16:36-04:00.