Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| N_HN10_QOL | int | 4 | √ | null |
|
|
QoL at Diagnosis (WHO) |
|||
| R_TUMOUR_NO | varchar | 50 | √ | null |
|
|
Primary Head and Neck Tumour Number |
|||
| R_RECURRENCE_TYPE | varchar | 50 | √ | null |
|
|
Recurrence Type |
|||
| R_NECK_NODES | varchar | 255 | √ | null |
|
|
Neck Nodes |
|||
| L_RECORD_GIVEN | bit | 1 | ((0)) |
|
|
Record given to patient |
||||
| INSS_ID | int | 4 | √ | null |
|
|
||||
| INSS_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| INPC_ID | int | 4 | √ | null |
|
|
||||
| CYTOGENETIC_RISK_CLASSIFICATION_ID | int | 4 | √ | null |
|
|
||||
| HPV_TEST_COMPLETE | varchar | 1 | √ | null |
|
|
||||
| HPV_TEST | int | 4 | √ | null |
|
|
||||
| HPV_STATUS | int | 4 | √ | null |
|
|
||||
| PATIENT_CONCERNS_INVENTORY | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_HEAD_NECK_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_HEAD_NECK | Performance | Asc | CARE_ID |