nhnacademy_citizen
Tables (25)
address
- id — INT — Primary key — NOT NULL
- third_region_id — INT — Foreign key → third_region.id — NOT NULL
- name — VARCHAR(45)
- INDEX — `fk_address_third_region2_idx`
birth
- human_id — INT — Foreign key → human.id — NOT NULL
- birth_place_type_id — INT — Foreign key → birth_place_type.id — NOT NULL
- request_human_id — INT — Foreign key → human.id — NOT NULL
- birth_request_human_type_id — INT — Foreign key → birth_request_human_type.id — NOT NULL
- request_human_email — VARCHAR(45)
- request_human_phone_number — VARCHAR(45)
- request_date — DATE
- birth_datetime — DATETIME
- INDEX — `fk_birth_birth_place_type1_idx`
- INDEX — `fk_birth_human2_idx`
- INDEX — `fk_birth_birth_request_human_type1_idx`
birth_place_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
birth_request_human_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
certificate_request
- id — INT — Primary key — NOT NULL
- human_id — INT — Foreign key → human.id — NOT NULL
- certificate_request_type_id — INT — Foreign key → certificate_request_type.id — NOT NULL
- verification_number — VARCHAR(17)
- certificate_request_date — DATE
- INDEX — `fk_form_request_human1_idx`
- INDEX — `fk_form_request_form_request_type1_idx`
certificate_request_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
death
- human_id — INT — Foreign key → human.id — NOT NULL
- address_id — INT — Foreign key → address.id — NOT NULL
- request_human_id — INT — Foreign key → human.id — NOT NULL
- death_place_type_id — INT — Foreign key → death_place_type.id — NOT NULL
- death_request_human_type_id — INT — Foreign key → death_request_human_type.id — NOT NULL
- request_human_email — VARCHAR(45)
- request_human_phone_number — VARCHAR(45)
- request_date — DATE
- death_datetime — DATETIME
- INDEX — `fk_death_address1_idx`
- INDEX — `fk_death_human2_idx`
- INDEX — `fk_death_death_place_type1_idx`
- INDEX — `fk_death_death_request_human_type1_idx`
death_place_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
death_request_human_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
family
- id — INT — Primary key — NOT NULL
- family_status_id — INT — Foreign key → family_status.id — NOT NULL
- create_date — DATE
- update_date — DATE
- INDEX — `fk_marrage_marrage_status1_idx`
family_child
- family_id — INT — Foreign key → family.id — NOT NULL
- human_id — INT — Foreign key → human.id — NOT NULL
- INDEX — `fk_child_human_human1_idx`
family_parent
- family_id — INT — Foreign key → family.id — NOT NULL
- human_id — INT — Foreign key → human.id — NOT NULL
- INDEX — `fk_marrage_human_marrage1_idx`
- INDEX — `fk_marrage_human_human1_idx`
family_status
- id — INT — Primary key — NOT NULL
- family_status_type — VARCHAR(45)
first_region
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
gender
- id — INT — Primary key — NOT NULL
- gender_type — CHAR(2)
household
- id — INT — Primary key — NOT NULL
- householder_id — INT — Foreign key → human.id — NOT NULL
- household_init_type_id — INT — Foreign key → household_init_type.id — NOT NULL
- init_date — DATE
- INDEX — `fk_household_human1_idx`
- INDEX — `fk_household_household_init_type1_idx`
household_address
- id — INT — Primary key — NOT NULL
- household_id — INT — Foreign key → household.id — NOT NULL
- address_id — INT — Foreign key → address.id — NOT NULL
- init_date — DATE
- INDEX — `fk_household_address_address1_idx`
household_init_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
household_participant
- human_id — INT — Foreign key → human.id — NOT NULL
- household_id — INT — Foreign key → household.id — NOT NULL
- household_participant_type_id — INT — Foreign key → household_participant_type.id — NOT NULL
- INDEX — `fk_household_participant_household1_idx`
- INDEX — `fk_household_participant_household_participant_type1_idx`
household_participant_change_history
- id — INT — Primary key — NOT NULL
- household_change_type_id — INT — Foreign key → household_participant_change_type.id — NOT NULL
- household_participant_human_id — INT — Foreign key → household_participant.human_id — NOT NULL
- change_date — DATE
- INDEX — `fk_household_change_history_household_change_type1_idx`
- INDEX — `fk_household_change_history_household_participant1_idx`
household_participant_change_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
household_participant_type
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45)
human
- id — INT — Primary key — NOT NULL
- gender_id — INT — Foreign key → gender.id — NOT NULL
- address_id — INT — Foreign key → address.id — NOT NULL
- name — VARCHAR(45)
- social_security_number — VARCHAR(45)
- INDEX — `fk_human_gender_idx`
- INDEX — `fk_human_address1_idx`
second_region
- id — INT — Primary key — NOT NULL
- first_region_id — INT — Foreign key → first_region.id — NOT NULL
- name — VARCHAR(45)
- INDEX — `fk_second_region_first_region1_idx`
third_region
- id — INT — Primary key — NOT NULL
- second_region_id — INT — Foreign key → second_region.id — NOT NULL
- name — VARCHAR(45)
- INDEX — `fk_third_region_second_region1_idx`