hw

테이블 (10)

birth

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL

dead

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL

family

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — NOT NULL
  • realation — VARCHAR(255) — NOT NULL

householder

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — NOT NULL

issue_certificate

  • Field — VARCHAR(255)
  • person_num — VARCHAR(255) — NOT NULL

me

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL

person

  • person_num — VARCHAR(255) — 기본 키 — NOT NULL

report

  • person_num — VARCHAR(255) — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

residential

  • Field — VARCHAR(255)
  • person_num — VARCHAR(255) — NOT NULL

세대구성원 (members_householder)

  • person_num — VARCHAR(255) — 외래 키 → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — NOT NULL
  • Field — VARCHAR(255)