Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| S | char | 1 | null |
|
|
|||
| SPECVERSION | varchar | 5 | √ | null |
|
|
||
| SUBMITCODE | varchar | 5 | √ | null |
|
|
||
| IMPORTLINKID | int | 4 | null |
|
|
|||
| INVESTIGATIONTYPE | char | 1 | √ | null |
|
|
||
| DATEOFCLINICALLYAGREEDDIAGNOSIS | datetime | 16,3 | √ | null |
|
|
||
| WHOORDEREDDEFINITIVEBIOPSYORRESECTION | varchar | 8 | √ | null |
|
|
||
| WHEREWASDEFINITIVEBIOPSYRESECTIONTAKEN | varchar | 5 | √ | null |
|
|
||
| PATHOLOGISTDEFINITIVE | varchar | 8 | √ | null |
|
|
||
| WHEREISDEFINITIVEPATHOLOGISTBASED | varchar | 5 | √ | null |
|
|
||
| SPECIMENNATURE | varchar | 20 | √ | null |
|
|
||
| MORPHOLOGYSNOMEDDEFINITIVE | varchar | 10 | √ | null |
|
|
||
| DEFINITIVEPRIMARYSITE | varchar | 750 | √ | null |
|
|
||
| TUMOURLATERALITYPATH | char | 1 | √ | null |
|
|
||
| PATHOLOGYINVESTIGATIONTYPE | varchar | 2 | √ | null |
|
|
||
| PERINEURALINVASION | char | 1 | √ | null |
|
|
||
| SIZEOFLESIONLENGTH | int | 4 | √ | null |
|
|
||
| MAXIMUMDEPTHOFINVASION | int | 4 | √ | null |
|
|
||
| METSBRAIN | int | 4 | √ | null |
|
|
||
| METSLIVER | int | 4 | √ | null |
|
|
||
| METSLUNG | int | 4 | √ | null |
|
|
||
| METSUNKNOWN | int | 4 | √ | null |
|
|
||
| METSSKIN | int | 4 | √ | null |
|
|
||
| METSLYMPHNODES | int | 4 | √ | null |
|
|
||
| METSBONEEXBONEMARROW | int | 4 | √ | null |
|
|
||
| METSBONEMARROW | int | 4 | √ | null |
|
|
||
| METSOTHER | int | 4 | √ | null |
|
|
||
| VASCULARORLYMPHINVASION | varchar | 20 | √ | null |
|
|
||
| DIFFERENTIATIONGRADE | char | 1 | √ | null |
|
|
||
| EXCISIONMARGIN | char | 1 | √ | null |
|
|
||
| SYNCHRONOUSTUMOUR | char | 1 | √ | null |
|
|
||
| SITEOFSYNCHRONOUSTUMOUR | varchar | 2 | √ | null |
|
|
||
| NUMBEROFNODESEXAMINED | int | 4 | √ | null |
|
|
||
| NUMBEROFNODESPOSITIVE | int | 4 | √ | null |
|
|
||
| NECKDISSECTIONLATERALITY | char | 1 | √ | null |
|
|
||
| POSITIVENODESLATERALITY | char | 1 | √ | null |
|
|
||
| LARGESTMETASTASISLEFTNECK | int | 4 | √ | null |
|
|
||
| LARGESTMETASTASISRIGHTNECK | int | 4 | √ | null |
|
|
||
| EXTRACAPSULARSPREAD | char | 1 | √ | null |
|
|
||
| BONEINVASION | char | 1 | √ | null |
|
|
||
| CARTILAGEINVASION | char | 1 | √ | null |
|
|
||
| HISTOLOGICGRADESALIVARY | char | 1 | √ | null |
|
|
||
| MACROSCOPICEXTRAGLANDULAREXTENSION | char | 1 | √ | null |
|
|
||
| TUMOURTGRADEPATHOLOGICAL | varchar | 3 | √ | null |
|
|
||
| TUMOURNGRADEPATHOLOGICAL | varchar | 3 | √ | null |
|
|
||
| TUMOURMGRADEPATHOLOGICAL | varchar | 3 | √ | null |
|
|
||
| WASPATHOLOGYAFTERNEOADJUVANTRX | char | 1 | √ | null |
|
|
||
| TUMOURTGRADEMDTPOSTOP | varchar | 3 | √ | null |
|
|
||
| TUMOURNGRADEMDTPOSTOP | varchar | 3 | √ | null |
|
|
||
| TUMOURMGRADEMDTPOSTOP | varchar | 3 | √ | null |
|
|
||
| VERSIONOFUICCUSEDFORSTAGING | char | 1 | √ | null |
|
|
||
| WASRESECTIVEPATHOLOGYDISCUSSEDATMDT | char | 1 | √ | null |
|
|
||
| TUMOURSTAGEPRETREATMENT | char | 1 | √ | null |
|
|
||
| TUMOURSTAGEFINAL | char | 1 | √ | null |
|
|
||
| ERR_DATEOFCLINICALLYAGREEDDIAGNOSIS | bit | 1 | null |
|
|
|||
| Username | varchar | 50 | null |
|
|
|||
| RecurrenceMetastaticType | int | 4 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors