BAT_DB_MAIN

Description: |
Stores unique values for the batch that do not change over time.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
BATCH_NUMBER_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BATCH_NUMBER_ID | VARCHAR | No |
The unique ID of the batch.
2 | BATCH_COMMENT_ID | VARCHAR | No |
The unique ID for the comment on the batch.
3 | INTENDED_PAT_ID | VARCHAR | No |
The patient that the contents of the batch is intended for.