temp

Tables (13)

address

  • address_id — INT — Primary key — NOT NULL
  • address_name — VARCHAR(100)

address_transfer_history

  • person_id — INT — NOT NULL
  • address_id — INT — NOT NULL
  • address_transfer_history_date — DATE — NOT NULL
  • address_transfer_history_reason — VARCHAR(45)

birth_address_type

  • birth_address_type_id — INT — Primary key — NOT NULL
  • birth_address_value — VARCHAR(45)

birth_person_additional

  • birth_person_id — INT — Primary key — NOT NULL
  • birth_person_date — DATETIME — NOT NULL

birth_report_type

  • birth_report_type_id — INT — Primary key — NOT NULL
  • birth_report_name — VARCHAR(45)

family_paper

  • family_paper_id — BIGINT(17) — Primary key — NOT NULL
  • family_paper_created_at — DATE
  • person_id — INT — NOT NULL

family_relation

  • person_target_id — INT — Primary key — NOT NULL
  • my_id — INT — Primary key — NOT NULL
  • family_relation_type_id — INT — NOT NULL

family_relation_type

  • family_relation_type_id — INT — Primary key — NOT NULL
  • family_relation_type_name — VARCHAR(45)

gender

  • gender_id — INT — Primary key — NOT NULL
  • gender_type — VARCHAR(2)

house_holder

  • house_holder_id — INT — NOT NULL
  • address_id — INT — NOT NULL

my_paper

  • my_paper_id — BIGINT(17) — Primary key — NOT NULL
  • my_paper_created_at — DATE
  • person_id — INT — NOT NULL

person

  • person_id — INT — Primary key — NOT NULL
  • person_name — VARCHAR(45) — NOT NULL
  • person_resident_registration_number — VARCHAR(300) — NOT NULL
  • gender_id — INT — NOT NULL
  • person_birthday — VARCHAR(45) — NOT NULL

person_has_birth_report_type

  • person_id — INT — Primary key — NOT NULL
  • birth_report_type_id — INT — Primary key — NOT NULL