1

Tables (27)

ABDOMINAL_CAT

  • ID — SERIAL
  • ABDOMINAL_NAME — VARCHAR(50) — NOT NULL

ABDOMINAL_COMMENT

  • ID — SMALLINT
  • SUBJID — VARCHAR(12)
  • COMMENT — ( VARCHAR(255) — NOT NULL — VARCHAR(255) NOT NUL

ABDOMINAL_SUBJECT

  • SUBJID — VARCHAR(12)
  • ID — SMALLINT

BLOOD_OR_EVALUATION

  • ID — SERIAL
  • NAME — VARCHAR(20)

CCI

  • SUBJID — VARCHAR(12)
  • CCI_SYMPTOM_NAME — SMALLINT
  • YNU — SMALLINT — NOT NULL
  • 간질환_정도 — VARCHAR(30)
  • 당뇨_정도 — VARCHAR(50)
  • 고형암_정도 — VARCHAR(10)

CCI_SCORE

  • ID — SERIAL
  • SELECTION — VARCHAR(50) — NOT NULL
  • SCORE — SMALLINT — NOT NULL

CCI_SYMPTOM_CAT

  • ID — SERIAL
  • CCI_SYMPTOM_NAME — VARCHAR(50) — NOT NULL

DOSE_POWER_CAT

  • ID — SERIAL
  • DOSE_NAME — VARCHAR(50) — NOT NULL

EXTRA_ABDOMINAL_CAT

  • ID — SERIAL
  • SUBJID — VARCHAR(12)
  • EXTRA_ADOMINAL_NAME — VARCHAR(30) — NOT NULL

MAIN_SYMPTOM_CAT

  • ID — SERIAL
  • MAIN_SYMPTOM_NAME — VARCHAR(20) — NOT NULL

MAIN_SYMPTOM_COMMENT

  • ID — SMALLINT
  • SUBJID — VARCHAR(12)
  • DMS1CO — VARCHAR(255) — NOT NULL

MAIN_SYMPTOM_SUBJECT

  • SUBJID — VARCHAR(12)
  • ID — SMALLINT

QUESTIONNAIRE_BEFORE_SURGERY

  • SUBJID — VARHCAR(12)
  • SUB_ITEM — SMALLINT
  • DT — DATE — NOT NULL
  • RES — FLOAT — NOT NULL

QUESTIONNAIRE_MAIN_ITEM

  • MAIN_ITEM_ID — SERIAL
  • MAIN_ITEM — VARCHAR(50)

QUESTIONNAIRE_SUB_ITEM

  • ID — SERIAL
  • SUB_ITEM — VARCHAR(50)
  • MAIN_ID — SMALLINT

REGION_MAIN

  • ID — SERIAL
  • MAIN_CAT — VARCHAR(50)

REGION_SUB

  • ID — SERIAL
  • SUB_CAT — VARCHAR(10)
  • SUBJID — INT — Foreign key → SUBJECT_BASIC_INFO.SUBJID

SUBJECT_BASIC_INFO

  • SUBJID — INT — Primary key
  • REGIST_DT — DATE — NOT NULL
  • BIRTH — INT — NOT NULL
  • HOSPITALIZE_DT — DATE — NOT NULL
  • SEX — SEX_ENUM — NOT NULL
  • WEIGHT — NUMERIC(3,1) — NOT NULL
  • HEIGHT — NUMERIC(3,1) — NOT NULL
  • INSURACNE — INSUR_ENUM — NOT NULL
  • REG_1 — SMALLINT — NOT NULL
  • REG_2 — SMALLINT — NOT NULL
  • SMOKE — SMK_ENUM — NOT NULL
  • SMOKEDOSE — NUMERIC(2,1)
  • SMOKEPRD — NUMERIC(2,1)
  • ALCOHOL — ACH_ENUM — NOT NULL
  • ACHFRQ — ACHFRQ_ENUM
  • ACHPRD — NUMERIC(2,1)
  • SHYN — SMALLINT — NOT NULL

UNIT

  • ID — SERIAL
  • LABEL_NAME — VARCHAR(30) — NOT NULL
  • UNIT_NAME — VARCHAR(10) — NOT NULL

WEIGHT_RECORD

  • WT_ID — SERIAL
  • SUBJID — VARCHAR(12) — NOT NULL
  • REGIST_DT — DATE — NOT NULL
  • WEIGHT — NUMERIC(3,1)

YNU_SELECTION

  • ID — SERIAL
  • YNU — VARCHAR(10)

간질환

  • ID — SERIAL
  • 정도 — VARCHAR(100) — NOT NULL

검사항목

  • 검사항목ID — INT
  • 검사유형ID — INT
  • 검사항목이름 — VARCHAR(255) — NOT NULL

결과

  • 결과ID — INT
  • 세부항목ID — INT
  • 결과 — VARCHAR(255) — NOT NULL
  • 날짜 — DATE — NOT NULL
  • 값 — FLOAT

고형암

  • ID — SERIAL
  • 정도 — VARCHAR(100) — NOT NULL

당뇨

  • ID — SERIAL
  • 정도 — VARCHAR(100) — NOT NULL

세부항목

  • 세부항목ID — INT
  • 검사항목ID — INT
  • 세부항목이름 — VARCHAR(255) — NOT NULL