Description: Unique number assigned to a patient for identification purposes
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| PATIENTID |
2 |
PATIENT
|
|
| AUTHORITYORGANIZATIONID |
3 |
ORGANIZATION
|
|
|
Name |
Type |
|
| 1 |
MEDICALRECORDNUMBERID |
INT |
|
|
Description: The unique Id for the MedicalRecordNumber table
|
|
Name |
Type |
|
| 2 |
PATIENTID |
INT |
|
|
Description: PatientId is a foreign key to the Patient table
|
|
Name |
Type |
|
| 3 |
AUTHORITYORGANIZATIONID |
INT |
|
|
Description: AuthorityOrganizationId is a foreign key to the Organization table
|
|
Name |
Type |
|
| 4 |
MRN |
NVARCHAR |
|
|
Description: Medical Record Number
|