Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TERTIARY_REFERRAL_ID | int identity | 4 | √ | null |
|
|
||||
| CARE_ID | int | 4 | null |
|
|
|||||
| TERTIARY_REFERRAL_DATE | datetime | 16,3 | null |
|
|
|||||
| REFERRING_ORGANISATION_ID | int | 4 | null |
|
|
|||||
| REFERRING_CLINICIAN_ID | int | 4 | √ | null |
|
|
||||
| REFERRING_CONTACT_NAME | varchar | 50 | √ | null |
|
|
||||
| REFERRING_CONTACT_PHONE | varchar | 50 | √ | null |
|
|
||||
| REFERRING_CONTACT_MOBILE | varchar | 50 | √ | null |
|
|
||||
| REFERRING_CONTACT_EMAIL | varchar | 100 | √ | null |
|
|
||||
| TERTIARY_REFERRAL_REASON | int | 4 | √ | null |
|
|
||||
| TERTIARY_REFERRAL_COMMENTS | varchar | 8000 | √ | null |
|
|
||||
| RECEIVING_ORGANISATION_ID | int | 4 | null |
|
|
|||||
| RECEIVING_CLINICIAN | varchar | 100 | √ | null |
|
|
||||
| RECEIVING_CLINICIAN_SPECIALTY | int | 4 | √ | null |
|
|
||||
| PATIENT_MOBILE | varchar | 50 | √ | null |
|
|
||||
| PATIENT_EMAIL | varchar | 100 | √ | null |
|
|
||||
| USE_PATIENT_CONTACT_DETAILS | bit | 1 | ((0)) |
|
|
|||||
| CARER_CONTACT | varchar | 50 | √ | null |
|
|
||||
| CARER_RELATIONSHIP | varchar | 5 | √ | null |
|
|
||||
| CARER_PHONE | varchar | 50 | √ | null |
|
|
||||
| CONFIRMED_CANCER | int | 4 | √ | null |
|
|
||||
| RECEIVING_CONTACT_NAME | varchar | 50 | √ | null |
|
|
||||
| RECEIVING_CONTACT_PHONE | varchar | 50 | √ | null |
|
|
||||
| RECEIVING_CONTACT_EMAIL | varchar | 100 | √ | null |
|
|
||||
| ROOT_TERTIARY_SENT_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| NEW_TERTIARY_REFERRAL_ID | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblTERTIARY_REFERRALS_NEW | Primary key | Asc | TERTIARY_REFERRAL_ID |