Radiation
Tables (12)
Common (Untitled)
- createdAt — CreateDateColumn
- updateAt — UpdateDateColumn
- deletedAt — DeleteDateColumn
Patients (PatientTable)
- id (patient_table_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- patient_id — NOT NULL — NOT NULL
- hospital_code — Enum (1 : SNUH, 2: SNUBH,3: BRMH ) — NOT NULL
- patient_name — NOT NULL
- gender — 1: Male, 2: Female
- age_at_diagnosis — NOT NULL
- diagnosis_no — Auto Increment
- diagnosis_1 — Enum (1 : H&N-Oral cavity ~ 12 : Metastasis)
- diagnosis_2 — Enum ( if diagnosis_1 : 12 -> 13: Stmoach ~ 18: Others )
- pathological_dx — Enum (1 : Adenoca~ 12 : Unknown )
- dx_date_primary — YYYYMMDD
- dx_date_meta — YYYYMMDD
- stage — Enum ( 0, ~ IVC )
- stage_cT — Enum ( 0, ~ IVC )
- stage_cN — Enum ( N0, ~ Nx )
- stage_cM — Enum (M0, M1, M1a, M1b, M1c, Mx )
- stage_pT — Enum ( T0, ~ Tx )
- stage_pN — Enum ( N0, ~ Nx )
- stage_pM — Enum (M0, M1, M1a, M1b, M1c, Mx )
- last_follow_up — YYYYMMDD
- last_status — "0: deceased 1: alive"
Recurrences (Untitled5)
- recurId (recur_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- id (patient_table_id) — PrimaryGeneratedColumn — Foreign key → Patients.id — NOT NULL
- recur_local — Enum ( 0: No , 1: Yes )
- recur_local_date — if ( recur_local :1 -> YYYYMMDD )
- recur_regional — Enum ( 0: No , 1: Yes )
- recur_regional_date — if ( recur_regional :1 -> YYYYMMDD )
- recur_distant — Enum ( 0: No , 1: Yes )
- recur_distant_date — if ( recur_distant :1 -> YYYYMMDD )
Reviews (ReviewTable)
- reviewId (review_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- userId (user_id) — PrimaryGeneratedColumn — Foreign key → User.userId — NOT NULL
- id (patient_table_id) — PrimaryGeneratedColumn — Foreign key → Patients.id — NOT NULL
- last_reviewer — NOT NULL
- last_save_datetime — UpdateDateColumn
- review_comment — nullable : True
RtCtx (Untitled11)
- rtCtxId (Key) — PrimaryGeneratedColumn — Primary key — NOT NULL
- therapyId (therapy_id) — PrimaryGeneratedColumn — Foreign key → Therapy.therapyId — NOT NULL
- rtCtx (Field) — Enum ( 0: No , 1: Yes )
- rtCtxName (Field2) — if ( rt_ctx :1 -> NOT NULL )
- rtCtxDate (Field3) — if ( rt_ctx :1 -> YYYYMMDD )
RtHtx (Untitled12)
- rtHtxId (Key) — PrimaryGeneratedColumn — Primary key — NOT NULL
- therapyId (therapy_id) — PrimaryGeneratedColumn — Foreign key → Therapy.therapyId — NOT NULL
- rtHtx (Field) — Enum ( 0: No , 1: Yes )
- rtHtxName (Field2) — if ( rt_htx :1 -> Enum ( Tamoxifen, ~ , Ketoconazole ) )
- rtHtxDate (Field3) — if ( rt_htx :1 -> YYYYMMDD )
RtOperation (Untitled10)
- rtOperationId (Key) — PrimaryGeneratedColumn — Primary key — NOT NULL
- therapyId (therapy_id) — PrimaryGeneratedColumn — Foreign key → Therapy.therapyId — NOT NULL
- rtOp (Field) — Enum ( 0: No , 1: Yes )
- rtOpName (Field2) — if ( rt_op :1 -> NOT NULL )
- Field3 — if ( rt_op :1 -> YYYYMMDD )
RtTtx (Untitled13)
- rtTtxId (Key) — PrimaryGeneratedColumn — Primary key — NOT NULL
- therapyId (therapy_id) — PrimaryGeneratedColumn — Foreign key → Therapy.therapyId — NOT NULL
- rtTtx (Field) — Enum ( 0: No , 1: Yes )
- rtTtxName (Field2) — if ( rt_ttx :1 -> Enum ( Cetuximab, Trastuzumab, Pertuzumab ) )
- rtTtxDate (Field3) — if ( rt_ttx :1 -> YYYYMMDD )
Tests (TestTable)
- test_id — PrimaryGeneratedColumn — Primary key — NOT NULL
- id (patient_table_id) — PrimaryGeneratedColumn — Foreign key → Patients.id — NOT NULL
- test_name — Enum ( 1: BRAF , 2: HER2, 3:ALK, 4: EGFR )
- test_result_text — NOT NULL
- test_result_value — NOT NULL
- test_result_units — NOT NULL
- test_result_date — YYYYMMDD
Therapy (Untitled4)
- therapyId (therapy_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- id (patient_table_id) — PrimaryGeneratedColumn — Foreign key → Patients.id — NOT NULL
- rt_aim — Enum ( 1: Radical 2: Preop 3: Postop 4: Salvage 5: Palliative )
- rt_site — NOT NULL
- rt_date — YYYYMMDD
- rt_fx — NOT NULL
- rt_dose_per_fx — NOT NULL
- rt_dose_delivered — NOT NULL
- rt_del — DeleteDateColumn
Update (Untitled8)
- updateId (update_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- updateField (update_field)
- prevData (prev_date) — NOT NULL
- currentData (current_data) — NOT NULL
- updatedAt (Field) — UpdateDateColumn
User (Untitled7)
- userId (user_id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- id (Field2) — NOT NULL
- password (Field) — hashedString
- user_name — NOT NULL
- userRole — Enum ( 1: Admin , 2: Doctor, 3: Client )