dental
Tables (3)
go, lo (건강검진DB)
- PERSON_ID (개인일련번호) — Primary key — NOT NULL
- YKIHO_GUBUN_CD (검진기관종별코드)
- 치주질환 (치주질환 유무)
gy20 (진료DB-명세서)
- KEY_SEQ (청구일련번호) — Primary key — NOT NULL
- PERSON_ID (개인일련번호) — Primary key — NOT NULL
- YKIHO_ID (요양기관식별대체번호) — Primary key — NOT NULL
- DSBJT_CD (진료과목코드)
- MAIN_SICK (주상병)
- SUB_SICK (부상병)
- PERSON_ID (개인일련번호2) — Foreign key → go, lo.PERSON_ID — NOT NULL
gy40 (진료DB-상병내역)
- KEY_SEQ (청구일련번호) — Primary key — NOT NULL
- PERSON_ID (개인일련번호) — Primary key — NOT NULL
- DSBJT_CD (진료과목코드)
- SICK_SYM (상병기호)
- SICK_DIV_TYPE_CD (상병분류구분)
- PERSON_ID (개인일련번호2) — Foreign key → go, lo.PERSON_ID — NOT NULL