Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| DIAGNOSIS_ID | int identity | 4 | √ | null |
|
|
Unique Record ID (Auto) |
|||
| CARE_ID | int | 4 | √ | null |
|
|
Links record to Referrals |
|||
| TEMP_ID | varchar | 255 | √ | null |
|
|
System ID |
|||
| N_SK1_DIAGNOSIS_DATE | smalldatetime | 16 | √ | null |
|
|
Date of Diagnosis |
|||
| N_SK2_BODY_SITE | varchar | 2 | √ | null |
|
|
Body Site |
|||
| N_SK3_DIAMETER | real | 4 | √ | null |
|
|
Largest Clinical Diameter |
|||
| N_SK4_BCC_MORPHOLOGY | char | 1 | √ | null |
|
|
Basal Cell Morphology |
|||
| N_SK5_MARGINS | real | 4 | √ | null |
|
|
Clinical Excision Margin |
|||
| N_SK6_RECURRENCE | char | 1 | √ | null |
|
|
New/Recurrent Skin Cancer |
|||
| L_SKIN_TYPE | int | 4 | √ | null |
|
|
Type of Skin Cancer |
|||
| L_MET_LUNG | int | 4 | √ | null |
|
|
Lung Metastases |
|||
| L_MET_BONE | int | 4 | √ | null |
|
|
Bone Metastases |
|||
| L_MET_LIVER | int | 4 | √ | null |
|
|
Liver Metastases |
|||
| L_MET_OTHER | int | 4 | √ | null |
|
|
Other Metastases |
|||
| L_OTHER_METS | varchar | 255 | √ | null |
|
|
Other Metastases |
|||
| ACTION_ID | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblDERMATOLOGY_RECURRENCES | Primary key | Asc | DIAGNOSIS_ID |
| IX_tblDERMATOLOGY_RECURRENCES | Performance | Asc | CARE_ID |