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`