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