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)