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