system

Tables (7)

birth_death_report_resident

  • birth_death_type_code — varchar(20) — Primary key — NOT NULL
  • report_resident_serial_number — int(11) — Primary key — NOT NULL
  • resident_serial_number — int(11) — Foreign key → resident.resident_serial_number — NOT NULL
  • birth_death_report_date — date — NOT NULL
  • birth_report_qualifications_code — varchar(20)
  • death_report_qualifications_code — varchar(20)
  • email_address — varchar(50)
  • phone_number — varchar(20) — NOT NULL

certificate_issue

  • certificate_confirmation_number — bigint — Primary key — NOT NULL
  • certificate_type_code — varchar(20) — NOT NULL
  • certificate_issue_date — date — NOT NULL
  • resident_serial_number — int(11) — Foreign key → resident.resident_serial_number — NOT NULL

family_relationship

  • family_resident_serial_number — int(11) — Primary key — NOT NULL
  • resident_serial_number (base_resident_serial_number) — int(11) — Foreign key → resident.resident_serial_number — NOT NULL
  • family_relationship_code — varchar(20) — NOT NULL

household

  • household_serial_number — int(11) — Primary key — NOT NULL
  • household_composition_date — date — NOT NULL
  • household_composition_reason_code — varchar(20) — NOT NULL
  • current_house_movement_address — varchar(500) — NOT NULL
  • household_resident_serial_number — int(11) — Foreign key → resident.resident_serial_number — NOT NULL

household_composition_resident

  • resident_serial_number — int(11) — Foreign key → resident.resident_serial_number — NOT NULL
  • household_serial_number — int(11) — Foreign key → household.household_serial_number — NOT NULL
  • report_date — date — NOT NULL
  • household_relationship_code — varchar(20) — NOT NULL
  • household_composition_change_reason_code — varchar(20) — NOT NULL

household_movement_address

  • house_movement_report_date — date — Primary key — NOT NULL
  • household_serial_number — int(11) — Foreign key → household.household_serial_number — NOT NULL
  • house_movement_address — varchar(500) — NOT NULL
  • last_address_yn — varchar(1) — NOT NULL

resident

  • resident_serial_number — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • resident_registration_number — varchar(300) — NOT NULL
  • gender_code — varchar(20) — NOT NULL
  • birth_date — datetime — NOT NULL
  • birth_place_code — varchar(20) — NOT NULL
  • registration_base_address — varchar(500) — NOT NULL
  • death_date — datetime
  • death_place_code — varchar(20)
  • death_place_address — varchar(500)