퍼플렉시티

테이블 (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)