Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TertiaryReferralID | int | 4 | null |
|
|
|||||
| ReferringClinicianID | int | 4 | √ | null |
|
|
||||
| ReferringContactName | varchar | 100 | √ | null |
|
|
||||
| ReferringContactPhone | varchar | 50 | √ | null |
|
|
||||
| ReferringContactMobile | varchar | 50 | √ | null |
|
|
||||
| ReferringContactEmail | varchar | 100 | √ | null |
|
|
||||
| ReceivingClinician | varchar | 100 | √ | null |
|
|
||||
| ReceivingClinicianSpecialty | int | 4 | √ | null |
|
|
||||
| PatientMobile | varchar | 50 | √ | null |
|
|
||||
| PatientEmail | varchar | 100 | √ | null |
|
|
||||
| UsePatientContactDetails | bit | 1 | ((0)) |
|
|
|||||
| CarerContact | varchar | 50 | √ | null |
|
|
||||
| CarerRelationship | varchar | 5 | √ | null |
|
|
||||
| CarerPhone | varchar | 50 | √ | null |
|
|
||||
| ConfirmedCancer | int | 4 | √ | null |
|
|
||||
| ReceivingContactName | varchar | 50 | √ | null |
|
|
||||
| ReceivingContactPhone | varchar | 50 | √ | null |
|
|
||||
| ReceivingContactEmail | varchar | 100 | √ | null |
|
|
||||
| ReferringClinicianDesc | varchar | 100 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblTERTIARY_REFERRALS_IPTF | Primary key | Asc | TertiaryReferralID |