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)