Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PUBLISHED_TREATMENTS_ID | int identity | 4 | √ | null |
|
|
||||
| PUBLISHED_TREATMENT_SUMMARY_ID | int | 4 | null |
|
|
|||||
| Treatment | varchar | 250 | √ | null |
|
|
||||
| Consultant | varchar | 100 | √ | null |
|
|
||||
| ClinicalTrial | varchar | 50 | √ | null |
|
|
||||
| Intent | varchar | 50 | √ | null |
|
|
||||
| ProcedureDesc | varchar | 250 | √ | null |
|
|
||||
| ProcedureDesc2 | varchar | 250 | √ | null |
|
|
||||
| ProcedureDesc3 | varchar | 250 | √ | null |
|
|
||||
| Laterality | varchar | 250 | √ | null |
|
|
||||
| Laterality2 | varchar | 250 | √ | null |
|
|
||||
| Laterality3 | varchar | 250 | √ | null |
|
|
||||
| LymphNodePro | varchar | 250 | √ | null |
|
|
||||
| LymphNodePro2 | varchar | 250 | √ | null |
|
|
||||
| Reconstruction1 | varchar | 250 | √ | null |
|
|
||||
| Reconstruction2 | varchar | 250 | √ | null |
|
|
||||
| Symmetrisation1 | varchar | 250 | √ | null |
|
|
||||
| Symmetrisation2 | varchar | 250 | √ | null |
|
|
||||
| Airways | varchar | 250 | √ | null |
|
|
||||
| ReconstructionProc1 | varchar | 250 | √ | null |
|
|
||||
| ReconstructionProc2 | varchar | 250 | √ | null |
|
|
||||
| LeftNeckProc | varchar | 250 | √ | null |
|
|
||||
| RightNeckProc | varchar | 250 | √ | null |
|
|
||||
| NeckProcedure | varchar | 250 | √ | null |
|
|
||||
| NeckProcedureLat | varchar | 250 | √ | null |
|
|
||||
| Graft | varchar | 250 | √ | null |
|
|
||||
| DischargeDate | datetime | 16,3 | √ | null |
|
|
||||
| DrugType | varchar | 250 | √ | null |
|
|
||||
| DrugRegimen | varchar | 250 | √ | null |
|
|
||||
| AnatomicalSite | varchar | 250 | √ | null |
|
|
||||
| SupportType | varchar | 250 | √ | null |
|
|
||||
| MonitoringIntent | varchar | 250 | √ | null |
|
|
||||
| TreatmentSetting | varchar | 250 | √ | null |
|
|
||||
| SiteDescription | varchar | 250 | √ | null |
|
|
||||
| StartDate | datetime | 16,3 | √ | null |
|
|
||||
| EndDate | datetime | 16,3 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblTREATMENT_SUMMARY_PUBLISHED_TREATMENTS | Primary key | Asc | PUBLISHED_TREATMENTS_ID |