ㄹㅁㄴㅇ

Tables (11)

Address

  • AddressID — int — Primary key — NOT NULL
  • Address — varchar(50) — NOT NULL

Birth

  • BirthID — int — Primary key — NOT NULL
  • BirthPlace — varchar(30) — NOT NULL — 자택, 병원, 기타 등등 주소x
  • DeclarationDate — date
  • PersonID2 — int — Foreign key → Person.PersonID — NOT NULL
  • PersonID — int — Foreign key → Person.PersonID — NOT NULL
  • AddressID — int — Foreign key → Address.AddressID — NOT NULL

Certificate

  • CertID — int — Primary key — NOT NULL
  • CertType — varchar(20)

Death

  • DeathID — int — Primary key — NOT NULL
  • DeathPlace — varchar(30) — NOT NULL
  • DeathDate — datetime — NOT NULL
  • PersonID2 — int — Foreign key → Person.PersonID — NOT NULL
  • PersonID — int — Foreign key → Person.PersonID — NOT NULL
  • AddressID — int — Foreign key → Address.AddressID — NOT NULL
  • DeclarationDate — date

Family

  • FamilyID — int — Primary key — NOT NULL
  • PersonID — int — Foreign key → Person.PersonID — NOT NULL
  • PersonID2 — int — Foreign key → Person.PersonID — NOT NULL
  • RoleID — int — Foreign key → Role.RoleID — NOT NULL

Generation_composition

  • HouseholdID — int — Primary key — NOT NULL
  • HouseID — int — Foreign key → Household.HouseID — NOT NULL
  • PersonID — int — Foreign key → Person.PersonID — NOT NULL
  • RoleID — int — Foreign key → Role.RoleID — NOT NULL
  • JoinDate — date — NOT NULL
  • ChangeReason — varchar(50) — NOT NULL
  • isOwner — boolean

Household

  • HouseID — int — Primary key — NOT NULL
  • CreatedDate — date — NOT NULL

HouseholdAddressHistory

  • HahID — int — Primary key — NOT NULL
  • HouseID — int — Foreign key → Household.HouseID — NOT NULL
  • NotiDate — date
  • AddressID — int — Foreign key → Address.AddressID — NOT NULL

Issuance_details

  • DetailID — int — Primary key — NOT NULL
  • PersonID — int — Foreign key → Person.PersonID — NOT NULL
  • CertID — int — Foreign key → Certificate.CertID — NOT NULL
  • IssueDate — date
  • CertificateNumber — varchar(20)

Person

  • PersonID — int — Primary key — NOT NULL
  • Name — varchar(20) — NOT NULL
  • ResidentID — varchar(300)
  • BirthDate — datetime — NOT NULL
  • Gender — varchar(10) — NOT NULL
  • Phone — varchar(15)
  • Email — varchar(30)

Role

  • RoleID — int — Primary key — NOT NULL
  • RoleName — varchar(10) — NOT NULL