|
Name |
Type |
Discontinued? |
|
1 |
RESULT_ID |
VARCHAR |
No |
|
|
|
The unique ID of the result record for this row. This column is frequently used to link to the RES_COMPONENTS table. |
|
|
2 |
GROUP_LINE |
INTEGER |
No |
|
|
|
This is the component line number from the RES_COMPONENTS table. Use the RESULT_ID to link the RES_COMPONENTS table to this table in addition to the GROUP_LINE. |
|
|
3 |
VALUE_LINE |
INTEGER |
No |
|
|
|
The line number of one of the multiple comments that are associated with the component/organism and the result from the RES_CMT_DATA_RM table. This column can be ignored - it is here for completeness. |
|
|
4 |
CMP_MLTLN_USER_CMMT |
NUMERIC |
No |
|
|
|
Stores a list of lines in OVR-52202 which store data for this line in the component related group. To link tables RES_CMT_PTR_RM to RES_CMT_DATA_RM link the following two sets of columns: - RES_CMT_PTR_RM.RESULT_ID to RES_CMT_DATA_RM.RESULT_ID, and - RES_CMT_PTR_RM.CMP_MLTLN_USER_CMMT to RES_CMT_DATA_RM.GROUP_LINE |
|
|