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