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