Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
|||||
| R_PROX_MARG | varchar | 20 | √ | null |
|
|
||||
| R_DIST_MARGIN | varchar | 20 | √ | null |
|
|
||||
| R_RESECTION_MAR | varchar | 20 | √ | null |
|
|
||||
| R_CIRCUMF | varchar | 20 | √ | null |
|
|
||||
| R_VASCULAR_INV | char | 3 | √ | null |
|
|
||||
| R_PERFORATIONS | char | 3 | √ | null |
|
|
||||
| R_DISTANT_MARGIN | real | 4 | √ | null |
|
|
||||
| R_DISTANT_APER | real | 4 | √ | null |
|
|
||||
| L_LOCAL_INV | varchar | 100 | √ | null |
|
|
||||
| L_DUKES | varchar | 50 | √ | null |
|
|
||||
| R_TUMOUR_IS | varchar | 20 | √ | null |
|
|
||||
| R_MARGINS | real | 4 | √ | null |
|
|
||||
| R_LIVER_METS | varchar | 3 | √ | null |
|
|
||||
| R_DOUGHNUTS | varchar | 20 | √ | null |
|
|
||||
| R_CUT_MARGINS | varchar | 20 | √ | null |
|
|
||||
| R_CUT_END_RECTAL | real | 4 | √ | null |
|
|
||||
| L_HAGGITT | int | 4 | √ | null |
|
|
||||
| L_KIKUCHI | int | 4 | √ | null |
|
|
||||
| NBCATumourType | int | 4 | √ | null |
|
|
||||
| NBCASpecimenSize | int | 4 | √ | null |
|
|
||||
| NBCAMismatchRepair | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_COLORECTAL_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_COLORECTAL | Performance | Asc | PATHOLOGY_ID |