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 )