Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||||
| L_SCHOOL | varchar | 255 | √ | null |
|
|
Education Details |
|||
| L_CONGENITAL | varchar | 255 | √ | null |
|
|
Congenital Abnormalites / Genetic Disorders |
|||
| L_DPT | bit | 1 | ((0)) |
|
|
Immunisation History (DPT) |
||||
| L_POLIO | bit | 1 | ((0)) |
|
|
Immunisation History (Polio) |
||||
| L_HIB | bit | 1 | ((0)) |
|
|
Immunisation History (Hib) |
||||
| L_MMR | bit | 1 | ((0)) |
|
|
Immunisation History (MMR) |
||||
| L_MENC | bit | 1 | ((0)) |
|
|
Immunisation History (Men C) |
||||
| L_BCG | bit | 1 | ((0)) |
|
|
Immunisation History (BCG) |
||||
| L_OTHER_IMM | bit | 1 | ((0)) |
|
|
Immunisation History (Other) |
||||
| L_IMM_DETAILS | varchar | 255 | √ | null |
|
|
Other Immunisation History Details |
|||
| L_CHICKENPOX | bit | 1 | ((0)) |
|
|
Infection History (Chickenpox) |
||||
| L_SHINGLES | bit | 1 | ((0)) |
|
|
Infection History (Shingles) |
||||
| L_OTHER_INFEC | bit | 1 | ((0)) |
|
|
Infection History (Other) |
||||
| L_INFEC_DETAILS | varchar | 255 | √ | null |
|
|
Other Infection History Details |
|||
| LANSKY_ID | int | 4 | √ | null |
|
|
Lansky Performance Status |
|||
| LifeThreateningSymptoms | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblINITIAL_PAEDIATRICS | Primary key | Asc | CARE_ID |