a

Tables (7)

birth_death_report_resident

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

certificate_issue

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

family_relationship

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

household

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

household_composition_resident

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

household_movement_address

  • household_movement_report_date — date — Primary key — NOT NULL
  • household_serial_number — int — Foreign key → household.household_serial_number — NOT NULL
  • house_movement_address — varchar(255)
  • last_address_yn — varchar(255)

resident

  • resident_serial_number — int — Primary key — NOT NULL
  • birth_date — datetime(6)
  • birth_place_code — varchar(255)
  • death_date — datetime(6)
  • death_place_address — varchar(255)
  • death_place_code — varchar(255)
  • email — varchar(255)
  • gender_code — varchar(255)
  • id — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • registration_base_address — varchar(255)
  • resident_registration_number — varchar(255)