Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReferralID | int | 4 | null |
|
|
|||
| PatientID | int | 4 | null |
|
|
|||
| CareID | int | 4 | √ | null |
|
|
||
| ReferredDate | date | 20 | null |
|
|
|||
| ReferredTime | time | 32 | √ | null |
|
|
||
| RouteOfReferral | varchar | 100 | √ | null |
|
|
||
| ReferralReason | varchar | 250 | √ | null |
|
|
||
| ReferrerName | varchar | 250 | √ | null |
|
|
||
| ReferrerContactTel | varchar | 250 | √ | null |
|
|
||
| ReferrerContactEmail | varchar | 250 | √ | null |
|
|
||
| PatientType | varchar | 8000 | √ | null |
|
|
||
| PrimaryTumourSite | varchar | 50 | √ | null |
|
|
||
| EndOfLifeCare | int | 4 | √ | null |
|
|
||
| AdmissionDate | date | 20 | √ | null |
|
|
||
| AdmissionTime | time | 32 | √ | null |
|
|
||
| Ward | varchar | 50 | √ | null |
|
|
||
| PatientAlreadyDischarged | int | 4 | √ | null |
|
|