Table 4 Tables in the DSC database
From: Continuous multimodal data supply chain and expandable clinical decision support for oncology
DB No. | DB Name | DB code | Table No. | Table Name | Table Description |
|---|---|---|---|---|---|
1 | Patients | PT | 1 | CNCR_PATINFO | Patient basic information |
1 | Patients | PT | 2 | CNCR_BODYINFO | Body measurement information |
2 | Diagnosis | DG | 3 | CNCR_DX | Diagnoses relating to a hospital visits |
2 | Diagnosis | DG | 4 | CNCR_CRDINFO | Copayment Decreasing Policy |
2 | Diagnosis | DG | 5 | CNCR_CSLT | Consultant Information |
3 | Examination | EM | 6 | CNCR_LAB | Events relating to laboratory tests |
3 | Examination | EM | 7 | CNCR_IMAGE | Events relating to Imaging test |
4 | Pathology | PH | 8 | CNCR_PATHOLOGY | Events relating to Pathology |
5 | Operation | OP | 9 | CNCR_OP | Surgery |
6 | Treatment | TX | 10 | CNCR_REGIMEN | Chemo-therapy |
6 | Treatment | TX | 11 | CNCR_RT | Radiation-therapy |
6 | Treatment | TX | 12 | CNCR_DRUG | Medicines prescribed |
6 | Treatment | TX | 13 | CNCR_PROC | Procedure (included medical operation) |
7 | Progress | TE | 14 | CNCR_FRM | Clinical Forms |
8 | aCancer registry | TM | 15 | CNCR_TUMOR_RGT | Tumor Registry (personal details and cancer diagnosis) |
8 | Cancer registry | TM | 16 | CNCR_TUMOR_TRANS | Tumor Registry (included cancer recurrence/metastasis) |
8 | Cancer registry | TM | 17 | CNCR_TUMOR_TRC | Tumor Registry (included cancer patient follow-up) |
8 | Cancer registry | TM | 18 | CNCR_TUMOR_TRET | Tumor Registry (included cancer treatment) |
