Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PAED_CHEMO_ID | int identity | 4 | √ | null |
|
|
Unique Record ID (Auto) |
|||
| CHEMO_ID | int | 4 | null |
|
|
Links record to Main Chemotherapy |
||||
| L_ROUTE | int | 4 | √ | null |
|
|
Route of Administration |
|||
| L_CUL_POS | int | 4 | √ | null |
|
|
Culture Positive |
|||
| L_CUL_NEG | int | 4 | √ | null |
|
|
Culture Negative |
|||
| L_SITE | int | 4 | √ | null |
|
|
Site |
|||
| L_ORGANISM | varchar | 5 | √ | null |
|
|
Organism |
|||
| L_IV_ANTI | int | 4 | √ | null |
|
|
IV Antibiotics |
|||
| L_ANTIFUNGALS | int | 4 | √ | null |
|
|
Antifungals |
|||
| L_FEBRILE_POS | int | 4 | √ | null |
|
|
Febrile Neutropenia (Culture +) |
|||
| L_FEBRILE_NEG | int | 4 | √ | null |
|
|
Febrile Neutropenia (Culture -) |
|||
| L_REACTION | varchar | 255 | √ | null |
|
|
Type of Reaction |
|||
| L_LOC_GEN | varchar | 255 | √ | null |
|
|
Local/Generalised |
|||
| L_DRUG_NAME | varchar | 255 | √ | null |
|
|
Name of Drug |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblCHEMOTHERAPY_PAEDIATRIC | Primary key | Asc | PAED_CHEMO_ID |
| IX_tblCHEMOTHERAPY_PAEDIATRIC | Performance | Asc | CHEMO_ID |