퍼플렉시티
테이블 (7)
BirthRegistration
- registration_id — INT
- child_id — INT — NOT NULL
- birth_date — DATE — NOT NULL
- birth_time — TIME — NOT NULL
- birth_place — VARCHAR(100) — NOT NULL
- registrant_id — INT — NOT NULL
- registration_date — DATE — NOT NULL
- registrant_relation — VARCHAR(20)
- registrant_email — VARCHAR(100)
- registrant_phone — VARCHAR(20)
Certificate
- certificate_id — INT
- certificate_type — VARCHAR(20) — NOT NULL
- verification_number — VARCHAR(16) — NOT NULL
- issue_date — DATE — NOT NULL
- requested_by_person_id — INT — NOT NULL
DeathRegistration
- registration_id — INT
- deceased_id — INT — NOT NULL
- death_date — DATE — NOT NULL
- death_time — TIME — NOT NULL
- death_place — VARCHAR(100) — NOT NULL
- death_cause — VARCHAR(100)
- registrant_id — INT — NOT NULL
- registration_date — DATE — NOT NULL
- registrant_relation — VARCHAR(20)
- registrant_email — VARCHAR(100)
- registrant_phone — VARCHAR(20)
FamilyRelationship
- relationship_id — INT
- base_person_id — INT — NOT NULL
- related_person_id — INT — NOT NULL
- relationship_type — VARCHAR(20) — NOT NULL
Household
- household_id — INT
- household_address — VARCHAR(200) — NOT NULL
- head_person_id — INT — NOT NULL
HouseholdMember
- member_id — INT
- household_id — INT — NOT NULL
- person_id — INT — NOT NULL
- relationship_to_head — VARCHAR(20) — NOT NULL
- move_in_date — DATE — NOT NULL
- move_in_reason — VARCHAR(50)
Person
- person_id — INT
- name — VARCHAR(50) — NOT NULL
- resident_number — VARCHAR(300) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — CHAR(1) — NOT NULL
- death_date — DATE
- death_time — TIME
- death_place — VARCHAR(100)
- death_reason — VARCHAR(100)