Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| N_SK2_BODY_SITE | varchar | 2 | √ | null |
|
|
Body Site |
|||
| N_SK3_DIAMETER | real | 4 | √ | null |
|
|
Largest Clinical Diameter |
|||
| N_SK4_BASAL_CELL | char | 1 | √ | null |
|
|
Basal Cell Morphology |
|||
| N_SK5_MARGIN | real | 4 | √ | null |
|
|
Clinical Excision Margin |
|||
| N_SK7_TCELL_AREA | char | 2 | √ | null |
|
|
T-Cell Surface Area |
|||
| N_SK8_LYMPHOMA | char | 1 | √ | null |
|
|
Lymphoma Morphology |
|||
| N_SK9_DISTRIBUTION | char | 1 | √ | null |
|
|
Distribution of Lesions Present |
|||
| N_SK10_TCELL_VARIANT | varchar | 10 | √ | null |
|
|
T-Cell Variant |
|||
| L_THICKNESS | varchar | 20 | √ | null |
|
|
Breslow Thickness |
|||
| L_CLARK_LEVEL | int | 4 | √ | null |
|
|
Clark Level |
|||
| L_AJCC | int | 4 | √ | null |
|
|
AJCC Staging |
|||
| AJCC_DATE | smalldatetime | 16 | √ | null |
|
|
AJCC Date |
|||
| L_ULCERATION | varchar | 1 | √ | null |
|
|
Ulceration |
|||
| L_MITOTIC | varchar | 2147483647 | √ | null |
|
|
Mitotic Rate |
|||
| L_REFERRAL_INFO | varchar | 255 | √ | null |
|
|
Referral Info |
|||
| L_AJCC_TEXT | varchar | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_DERMATOLOGY_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_DERMATOLOGY | Performance | Asc | CARE_ID |