Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
TELE_ID | int identity | 4 | null |
|
|
|||||
CARE_ID | int | 4 | null |
|
|
|||||
TEMP_ID | varchar | 255 | √ | null |
|
|
||||
N10_1_SITE_CODE | varchar | 5 | √ | null |
|
|
||||
N10_2_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
N10_3_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N10_6_TREATMENT_INTENT | varchar | 1 | √ | null |
|
|
||||
N10_7_TREATMENT_SITE | varchar | 5 | √ | null |
|
|
||||
N10_8_START_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N10_9_END_DATE | smalldatetime | 16 | √ | null |
|
|
||||
N10_10_DOSE | real | 4 | √ | null |
|
|
||||
N10_11_FRACTIONS | real | 4 | √ | null |
|
|
||||
N10_12_DURATION | int | 4 | √ | null |
|
|
||||
N10_13_ACTUAL_DOSE | real | 4 | √ | null |
|
|
||||
N10_14_ACTUAL_FRACTIONS | real | 4 | √ | null |
|
|
||||
N10_15_ACTUAL_DURATION | int | 4 | √ | null |
|
|
||||
N10_16_BEAM_TYPE | varchar | 1 | √ | null |
|
|
||||
N10_17_BEAM_ENERGY_1 | varchar | 1 | √ | null |
|
|
||||
N10_17_BEAM_ENERGY_2 | varchar | 1 | √ | null |
|
|
||||
N10_18_FIELDS | varchar | 1 | √ | null |
|
|
||||
N10_19_COMPLEXITY | varchar | 1 | √ | null |
|
|
||||
N10_20_ANAESTHETIC | varchar | 5 | √ | null |
|
|
||||
N10_21_MULTIPLE_PLANNING | varchar | 5 | √ | null |
|
|
||||
N10_23_STATUS | int | 4 | √ | null |
|
|
||||
N_L26_RT_GIVEN | varchar | 2 | √ | null |
|
|
||||
L_DOSE_FRACTIONS | int | 4 | √ | null |
|
|
||||
L_FRACTIONS_WEEK | int | 4 | √ | null |
|
|
||||
L_NAMED_COMP | varchar | 50 | √ | null |
|
|
||||
L_COMP_3MTH | varchar | 50 | √ | null |
|
|
||||
L_SHORT_LONG | varchar | 5 | √ | null |
|
|
||||
L_TRIAL | int | 4 | √ | null |
|
|
||||
L_FRAME | int | 4 | √ | null |
|
|
||||
R_TREAT_TO | varchar | 2 | √ | null |
|
|
||||
DEFINITIVE_TREATMENT | int | 4 | √ | null |
|
|
||||
CWT_PROFORMA | int | 4 | √ | null |
|
|
||||
L_COMMENTS | text | 2147483647 | √ | null |
|
|