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)