TestLabel (ver20.11.0)
Association between a fitness test and the type of fitness tested (e.g. Cardio, Flexibility, Strength).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 20.11.0 | Number(16) | Unique identifier for this table. Indexed. Required. |
TestCodeSetID | 20.11.0 | Number(16) | Foreign Key to the CodeSet table values with the CodeType='Test Label'. Indexed. Required. |
TestScoreDCID | 20.11.0 | Number(10) | Foreign Key to the TestScore table. Indexed. Required. |
| WhenCreated | 20.11.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 20.11.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 20.11.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
| WhoModifed | 20.11.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |