Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| N_G1_GYNAE_ONCOLOGY | char | 1 | √ | null |
|
|
Accredited Gynae-Oncologist |
|||
| N_G2_DIAGNOSTIC_ROUTE | int | 4 | √ | null |
|
|
Diagnostic Route |
|||
| R_FIGO | varchar | 3 | √ | null |
|
|
Final FIGO Stage (1) |
|||
| R_FIGO2 | varchar | 3 | √ | null |
|
|
Final FIGO Stage (2) |
|||
| R_FIGO3 | varchar | 3 | √ | null |
|
|
Final FIGO Stage (3) |
|||
| R_SECONDARY_DEPOSIT | varchar | 255 | √ | null |
|
|
Secondary Deposit From (Organ) |
|||
| L_QUESTIONNAIRE | varchar | 3 | √ | null |
|
|
||||
| NODAL_STATUS_ID | int | 4 | √ | null |
|
|
||||
| R_FIGO4 | varchar | 5 | √ | null |
|
|
Final FIGO Stage (4) |
|||
| R_FIGO_STAGINGTYPE | varchar | 5 | √ | null |
|
|
FIGO Staging Type |
|||
| StageGynaeReportDate | smalldatetime | 16 | √ | null |
|
|
Final FIGO Stage Date |
|||
| StageGynaeOrgID | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_GYNAECOLOGY_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_GYNAECOLOGY | Performance | Asc | CARE_ID |