homework1
Tables (8)
Birth
- BirthID — BIGINT — Primary key — NOT NULL
- BirthDateTime — DateTime
- BirthPlace — TEXT
- ReporterID — BIGINT — Foreign key → Reporter.ReporterID
CertifiedCopy
- CertifiedID — NVARCHAR(50) — Primary key — NOT NULL — 증명서 번호
- Issuer — BIGINT — Foreign key → Person.PersonID — NOT NULL
- IssueDate — DATETIME — NOT NULL — 발급일자
Death
- DeathID — BIGINT — Primary key — NOT NULL
- DeathDate — DATETIME — 사망일
- DeathAddress — TEXT — 사망 주소
- DeathPlace — TEXT — 사망 장소
- ReporterID — BIGINT — Foreign key → Reporter.ReporterID — NOT NULL
FamilyRelationship
- ProofID — NVARCHAR(50) — Primary key — NOT NULL — 증명서 번호
- Issuer — BIGINT — Foreign key → Person.PersonID — NOT NULL — 발급인
- IssueDate — DATETIME — NOT NULL — 발급일자
House
- HouseID — BIGINT — Primary key — NOT NULL
- OwnerID — BIGINT — 세대주
- Reasons — TEXT
- HouseDate — DATE
Parents
- ParentsID — BIGINT — Primary key — NOT NULL
- FatherID — BIGINT — 아버지
- MotherID — BIGINT — 어머니
Person
- PersonID — BIGINT — Primary key — NOT NULL
- Name — TEXT — NOT NULL
- NationalID — TEXT — NOT NULL
- Gender — NCHAR(1) — NOT NULL
- NativeAddress — TEXT — NOT NULL
- Partner — BIGINT — Foreign key → Person.PersonID — NOT NULL
- HouseID — BIGINT — Foreign key → House.HouseID — NOT NULL
- BirthID — BIGINT — Foreign key → Birth.BirthID
- DeathID — BIGINT — Foreign key → Death.DeathID
- ParentsID — BIGINT — Foreign key → Parents.ParentsID
Reporter
- ReporterID — BIGINT — Primary key
- Email — NVARCHAR(50)
- PhoneNumber — NVARCHAR(13)
- Role — NVARCHAR(20)