ㅇ

Tables (10)

birth

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL
  • Key — VARCHAR(255) — Foreign key → report.Key — NOT NULL

dead

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL
  • Key — VARCHAR(255) — Foreign key → report.Key — NOT NULL

family

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — Foreign key → me.person_num — NOT NULL
  • realation — VARCHAR(255) — NOT NULL

householder

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — Foreign key → me.person_num — NOT NULL

issue_certificate

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • person_num — VARCHAR(255) — Foreign key → me.person_num — NOT NULL

me

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL

members_householder

  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL
  • person_num2 — VARCHAR(255) — Foreign key → householder.person_num — NOT NULL
  • Field — VARCHAR(255)

person

  • person_num — VARCHAR(255) — Primary key — NOT NULL

report

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • person_num — VARCHAR(255) — Foreign key → me.person_num — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

residential

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • person_num — VARCHAR(255) — Foreign key → person.person_num — NOT NULL