ㄹㅁㄴㅇ
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