| Column Name | Ordinal Position |
|---|
| Column Name | Ordinal Position | Referenced Table | |
|---|---|---|---|
| SCHEDULESESSIONID | 2 | SCHEDULESESSION | |
| SURGERYCASEID | 3 | IDENTIFIER |
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SURGERYCASERECORDID | INT | ||||||||
|
Description: The unique Id for the SurgeryCaseRecord table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | SCHEDULESESSIONID | INT | ||||||||
|
Description: ScheduleSessionId is a foreign key to the ScheduleSession table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 3 | SURGERYCASEID | INT | ||||||||
|
Description: SurgeryCaseId is a foreign key to the Identifier table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | ADDENDUMNUM | INT | ||||||||
|
Description: Reserved for future enhancement/revision
|
||||||||||