zerocho

Tables (18)

Address

  • road_address — nvarchar(100) — Primary key — NOT NULL — 도로명주소
  • address_number — nvarchar(10) — NOT NULL — 우편번호

AddressRecord

  • adress_record — nvarchar(50) — Primary key — NOT NULL — 정렬용 주소이전기록ID
  • person_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • road_address — nvarchar(100) — Foreign key → Address.road_address — NOT NULL — 도로명주소
  • reason_id — int — Foreign key → Reason.reason_id — NOT NULL
  • record_date — date — NOT NULL — 주소이전날짜

BirthPlace

  • birthplace_id — int — Primary key — NOT NULL
  • birthplace_detail — nvarchar(10) — NOT NULL

BirthReport

  • birth_id — int — Primary key — NOT NULL
  • report_datetime — datetime — NOT NULL
  • birthplace_id — int — Foreign key → BirthPlace.birthplace_id — NOT NULL
  • birth_datetime — datetime — NOT NULL
  • father_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • mother_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • sex_id — int — Foreign key → Sex.sex_id — NOT NULL
  • birth_address — nvarchar(100) — Foreign key → Address.road_address — NOT NULL — 도로명주소

BirthReporter

  • birth_id — int — Foreign key → BirthReport.birth_id — NOT NULL
  • reporter_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • reporter_type_id — int — Foreign key → BirthReporterType.reporter_type_id — NOT NULL
  • reporter_email — varchar(100)
  • phone_number — varchar(20)

BirthReporterType

  • reporter_type_id — int — Primary key — NOT NULL
  • reporter_type — nvarchar(10) — NOT NULL

Certificate

  • certificate_id — varchar(17) — Primary key — NOT NULL
  • issue_date — DATE — NOT NULL
  • person_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • certificate_type_id — TINYINT — Foreign key → Certificate_type.certificate_type_id — NOT NULL

Certificate_type

  • certificate_type_id — TINYINT — Primary key — NOT NULL
  • certificate_name — NVARCHAR(10) — NOT NULL

Household

  • household_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • road_address — nvarchar(100) — Foreign key → Address.road_address — NOT NULL — 도로명주소

Human

  • person_id — varchar(300) — Primary key — NOT NULL — 주민등록번호
  • name — nvarchar(30) — NOT NULL — 이름
  • birthday — date — NOT NULL — 생년월일
  • is_alive — tinyint(1) — NOT NULL — 생존여부
  • household_id — char(14) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • family_address — nvarchar(100) — Foreign key → Address.road_address — NOT NULL — 도로명주소
  • sex_id — int — Foreign key → Sex.sex_id — NOT NULL

Reason

  • reason_id — int — Primary key — NOT NULL
  • reason_detail — nvarchar(10) — NOT NULL

Relation

  • relation_id — int — Primary key — NOT NULL
  • relation_name — varchar(10) — NOT NULL

Relationship

  • my_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • other_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • relation_id — int — Foreign key → Relation.relation_id — NOT NULL

Sex

  • sex_id — int — Primary key — NOT NULL
  • sex_detail — nvarchar(2) — NOT NULL

deadReport

  • death_id — int — Primary key — NOT NULL
  • deadDateTime — datetime — NOT NULL
  • person_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • death_site_id — int — Foreign key → dead_site_category.death_site_id — NOT NULL
  • death_address — nvarchar(100) — Foreign key → Address.road_address — NOT NULL — 도로명주소
  • death_report_date — date — NOT NULL

dead_site_category

  • death_site_id — int — Primary key — NOT NULL
  • death_site — varchar(30) — NOT NULL

deathReporter

  • death_id — int — Foreign key → deadReport.death_id — NOT NULL
  • person_id — varchar(300) — Foreign key → Human.person_id — NOT NULL — 주민등록번호
  • reporter_email — varchar(30)
  • reporter_phoneNumber — varchar(30)
  • reporter_type_id — int — Foreign key → death_reporter_type.reporter_type_id — NOT NULL

death_reporter_type

  • reporter_type_id — int — Primary key — NOT NULL
  • reporter_type — varchar(30) — NOT NULL