ㅁㅁㅁ

Tables (35)

account_info

  • id — int — Primary key — NOT NULL
  • group_code — text
  • group_name — text
  • account_code — text
  • account_name — text
  • web_account_name — text
  • started_at — date
  • ended_at — date
  • type — text
  • use_yn — varchar(1)
  • support_type — varchar(1)
  • reservation_type — varchar(2)
  • manager — text
  • shuttle_yn — varchar(1)
  • web_started_at — date
  • web_ended_at — date
  • web_use_yn — varchar(1)
  • show_yn — varchar(1)
  • created_at — datetime
  • event_count — int
  • updated_at — datetime
  • area — varchar(1)
  • cal_yn — varchar(1)
  • cal_apply_yn — varchar(1)
  • url — text
  • event_started_at — date
  • event_ended_at — date
  • event_select_count — int
  • base_year — text
  • url_base_year — text

account_package

  • id — int — Primary key — NOT NULL
  • account_info_id — int — Foreign key → account_info.id — NOT NULL
  • package_info_id — int — Foreign key → package_info.id — NOT NULL
  • account_code — text
  • package_code — text
  • package_name — text
  • web_package_name — text
  • type — varchar(1)
  • started_at — date
  • ended_at — date
  • lifetime_count — int
  • select_count — int
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)

admin_info

  • id — int — Primary key — NOT NULL
  • user_info_id — int — Foreign key → user_info.id — NOT NULL
  • name — text
  • code — text
  • department — text
  • manager — varchar(5)
  • position — text
  • phone — text
  • email — text
  • birth — date
  • gender — varchar(1)
  • employment_status — int
  • joined_at — datetime
  • resigned_at — datetime
  • last_logined_at — datetime
  • status — int
  • create_admin_info_id — int
  • created_at — datetime
  • update_admin_info_id — int
  • updated_at — datetime
  • memo — text

auth

  • id — int — Primary key — NOT NULL
  • admin_info_id — int — Foreign key → admin_info.id — NOT NULL
  • title — text
  • account_yn — varchar(1)
  • plan_yn — varchar(1)
  • capa_yn — varchar(1)
  • examine_yn — varchar(1)
  • push_yn — varchar(1)
  • ocs_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime
  • delete_yn — varchar(1)
  • push_token — text

capa_cal_info

  • id — int — Primary key — NOT NULL
  • account_info_id — int — Foreign key → account_info.id — NOT NULL
  • capa_info_id — int — Foreign key → capa_info.id — NOT NULL
  • center_info_id — int — Foreign key → center_info.id — NOT NULL
  • cal_am_man — int
  • cal_am_woman — int
  • cal_pm_man — int
  • cal_pm_woman — int
  • cal_hold_am_man — int
  • cal_hold_am_woman — int
  • cal_hold_pm_man — int
  • cal_hold_pm_woman — int
  • hold_am_man — int
  • hold_pm_man — int
  • hold_am_woman — int
  • hold_pm_woman — int
  • updated_at — date
  • cal_date — date
  • created_at — date

capa_date_info

  • id — int — Primary key — NOT NULL
  • capa_info_id — int — Foreign key → capa_info.id — NOT NULL
  • started_at — VARCHAR(255)
  • ended_at — VARCHAR(255)
  • man_count — VARCHAR(255)
  • woman_count — VARCHAR(255)
  • created_at — VARCHAR(255)

capa_equip_cal_info

  • id — int — Primary key — NOT NULL
  • capa_equip_info_id — int — Foreign key → capa_equip_info.id — NOT NULL
  • account_info_id — int — Foreign key → account_info.id — NOT NULL
  • lab_info_id — int — Foreign key → lab_info.id — NOT NULL
  • am — text
  • pm — text
  • cal_hold_am — text
  • cal_hold_pm — text
  • hold_am — text
  • hold_pm — text
  • capa_date — datetime
  • created_at — datetime
  • updated_at — datetime

capa_equip_date_info

  • id — int — Primary key — NOT NULL
  • capa_equip_info_id — int — Foreign key → capa_equip_info.id — NOT NULL
  • started_at — datetime
  • ended_at — datetime
  • count — int
  • created_at — datetime
  • updated_at — VARCHAR(255)

capa_equip_info

  • id — int — Primary key — NOT NULL
  • lab_info_info_id — int — Foreign key → lab_info.id — NOT NULL
  • center_info_id — int — Foreign key → center_info.id — NOT NULL
  • capa_am — int
  • capa_pm — int
  • hold_am — int
  • hold_pm — int
  • cal_am — int
  • cal_pm — int
  • cal_hold_am — int
  • cal_hold_pm — int
  • capa_date — date
  • created_at — datetime
  • updated_at — datetime

capa_info

  • id — int — Primary key — NOT NULL
  • center_info_id — int — Foreign key → center_info.id — NOT NULL
  • capa_am_man — int
  • capa_am_woman — int
  • capa_pm_man — int
  • capa_pm_woman — int
  • cal_am_man — int
  • cal_am_woman — int
  • cal_pm_man — int
  • cal_pm_woman — int
  • hold_am_man — int
  • hold_am_woman — int
  • hold_pm_man — int
  • hold_pm_woman — int
  • cal_hold_am_man — int
  • cal_hold_am_woman — int
  • cal_hold_pm_man — int
  • cal_hold_pm_woman — int
  • capa_date — date
  • created_at — datetime
  • updated_at — datetime

capa_plan_config

  • id — int — Primary key — NOT NULL
  • capa_plan_info_id — int — Foreign key → capa_plan_info.id — NOT NULL
  • month — int
  • samsung_man_am — int
  • samsung_man_pm — int
  • samsung_woman_am — int
  • samsung_woman_pm — int
  • normal_man_am — int
  • normal_man_pm — int
  • normal_woman_am — int
  • normal_woman_pm — int
  • person_man_am — int
  • person_man_pm — int
  • person_woman_am — int
  • person_woman_pm — int
  • five_man_am — int
  • five_man_pm — int
  • five_woman_am — int
  • five_woman_pm — int
  • odd_man_am — int
  • odd_man_pm — int
  • odd_woman_am — int
  • odd_woman_pm — int
  • weekly_man_am — int
  • weekly_man_pm — int
  • weekly_woman_am — int
  • weekly_woman_pm — int
  • created_at — datetime
  • five_work_day — text
  • odd_work_day — text
  • weekly_work_day — text
  • status — int

capa_plan_info

  • id — int — Primary key — NOT NULL
  • user_info_id — int — Foreign key → user_info.id — NOT NULL
  • center_info_id — int — Foreign key → center_info.id — NOT NULL
  • year — int
  • excel_path — text
  • last_update_id — int
  • updated_at — datetime
  • created_at — datetime
  • applied_at — datetime
  • apply_yn — varchar(1)
  • delete_yn — varchar(1)

center_info

  • id — int — Primary key — NOT NULL
  • title — text

country_info

  • id — int — Primary key — NOT NULL
  • code — text
  • title — text
  • title_en — text
  • created_at — datetime

covid_info

  • id — int — Primary key — NOT NULL
  • reservation_info_id — int — Foreign key → reservation_info.id — NOT NULL
  • user_info_id — int
  • abroad_yn — int
  • country — text
  • visited_at — datetime
  • created_at — datetime
  • breath_yn — varchar(1)

email_verify

  • id — int — Primary key — NOT NULL
  • username — text
  • email — text
  • code — text
  • verify_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime

event_examine_bridge

  • id — int — Primary key — NOT NULL
  • account_info_id — int — Foreign key → account_info.id — NOT NULL
  • examine_info_id — int — Foreign key → examine_info.id — NOT NULL
  • use_yn — varchar(1)
  • started_at — date
  • ended_at — date
  • area — varchar(1)
  • time — varchar(2)
  • exam_code — text
  • account_code — text
  • mon_yn — varchar(1)
  • tue_yn — varchar(1)
  • wed_yn — varchar(1)
  • thu_yn — varchar(1)
  • fri_yn — varchar(1)
  • sat_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)

examine_group_bridge_info

  • id — int — Primary key — NOT NULL
  • examine_group_info_id — int — Foreign key → examine_group_info.id — NOT NULL
  • code — text
  • group_code — text
  • created_at — datetime
  • deleted_yn — Y
  • N — NULL

examine_group_info

  • id — int — Primary key — NOT NULL
  • group_title — VARCHAR(255)
  • group_description — VARCHAR(255)
  • deleted_yn — Y
  • N — NULL
  • created_at — datetime

examine_info

  • id — int — Primary key — NOT NULL
  • code — text
  • title — text
  • web_title — text
  • question_yn — varchar(1)
  • gender — varchar(1)
  • device_yn — varchar(1)
  • price — int
  • type — varchar(1)
  • link — text
  • webuse_yn — varchar(1)
  • description — text
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)

examiner_info

  • id — int — Primary key — NOT NULL
  • user_info_id — int — Foreign key → user_info.id — NOT NULL
  • group_code — text
  • group_name — text
  • account_code — text
  • account_name — text
  • registration_number — text
  • reservation_number — text
  • name — text
  • birth — text
  • gender — varchar(1)
  • age — int
  • employee_number — text
  • phone — text
  • registered_at — text
  • state — varchar(1)
  • base_year — text
  • lifetime_yn — varchar(1)
  • specific — varchar(1)
  • gongdan_yn — varchar(1)
  • group_booker — varchar(1)
  • deadline_at — text
  • reserved_at — text
  • time_code — varchar(2)
  • area — varchar(1)
  • last_examined_at — date
  • last_area — varchar(1)
  • type — text
  • package_code — text
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)
  • ocs_reservation_yn — varchar(2)
  • policy_yn — varchar(1)
  • terms_yn — varchar(1)
  • special_yn — varchar(1)
  • special_division_yn — varchar(1)

excel_history

  • id — int — Primary key — NOT NULL
  • user_info_id — int — Foreign key → user_info.id — NOT NULL
  • title — text
  • text — text
  • created_at — datetime

inquiry_info

  • id — int — Primary key — NOT NULL
  • reservation_info_id — int — Foreign key → reservation_info.id — NOT NULL
  • hope_yn — varchar(1)
  • channel — int
  • time_code — varchar(2)
  • memo — text
  • state — int
  • relate_id — int
  • counselor — text
  • consulted_at — datetime
  • created_at — datetime
  • updated_at — datetime
  • manager_memo — text

inquiry_manager

  • id — int — Primary key — NOT NULL
  • inquiry_info_id — int — Foreign key → inquiry_info.id — NOT NULL
  • admin_info_id — int — Foreign key → admin_info.id — NOT NULL
  • division — int
  • created_at — datetime

interview_info

  • id — int — Primary key — NOT NULL
  • title — VARCHAR(255)
  • gender — VARCHAR(255)
  • question — VARCHAR(255)
  • created_at — VARCHAR(255)
  • type — int

lab_examine_info

  • id — int — Primary key — NOT NULL
  • lab_info_id — int — Foreign key → lab_info.id — NOT NULL
  • examine_info_id — int — Foreign key → examine_info.id — NOT NULL
  • deleted_yn — varchar(1)
  • created_at — datetime

lab_info

  • id — int — Primary key — NOT NULL
  • center_info_id — int
  • title — text
  • code — text
  • deleted_yn — varchar(1)
  • created_at — date

log_reservation_status

  • id — int — Primary key — NOT NULL
  • admin_info_id — int
  • reservation_info_id — int
  • name — text
  • before_status — int
  • current_status — int
  • before_manager_check_yn — varchar(2)
  • current_manager_check_yn — varchar(2)
  • checked_at — datetime
  • created_at — datetime

log_send_message

  • id — int — Primary key — NOT NULL
  • admin_info_id — int
  • reservation_info_id — int
  • status — int
  • count — int
  • phone — text
  • created_at — datetime

package_bridge

  • id — int — Primary key — NOT NULL
  • examine_info_id — int — Foreign key → examine_info.id — NOT NULL
  • account_package_id — int — Foreign key → account_package.id — NOT NULL
  • account_code — text
  • account_name — text
  • package_code — text
  • package_name — text
  • started_at — date
  • ended_at — date
  • exam_code — text
  • exam_name — text
  • stomach_yn — varchar(1)
  • lifetime_yn — varchar(1)
  • shuttle_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)

package_info

  • id — int — Primary key — NOT NULL
  • package_code — text
  • package_name — text
  • web_package_name — text
  • type — varchar(1)
  • specific — varchar(1)
  • lifetime_yn — varchar(1)
  • gongdan_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime
  • show_yn — varchar(1)
  • latent_yn — varchar(2)

reservation_examine_info

  • id — int — Primary key — NOT NULL
  • reservation_info_id — int — Foreign key → reservation_info.id — NOT NULL
  • lab_info_id — int — Foreign key → lab_info.id — NOT NULL
  • type — int
  • relate_id — int
  • status — int
  • memo — text
  • code — text
  • deleted_yn — varchar(1)
  • created_at — datetime
  • updated_at — datetime
  • price — int
  • price_real — int

reservation_info

  • id — int — Primary key — NOT NULL
  • examiner_info_id — int — Foreign key → examiner_info.id — NOT NULL
  • registration_number — text
  • reservation_number — text
  • name — text
  • birth — text
  • gender — varchar(1)
  • age — int
  • reserved_at — text
  • reservation_time_code — varchar(2)
  • area — text
  • account_name — text
  • type — varchar(3)
  • package_name — text
  • stomach_name — text
  • lifetime_name — text
  • select_1_name — text
  • select_2_name — text
  • additional_name — text
  • event_name — text
  • shuttle_name — text
  • shuttle_yn — varchar(1)
  • disease_check_yn — varchar(1)
  • medicine_check_yn — varchar(1)
  • operation_check_yn — varchar(1)
  • dentist_check_yn — varchar(1)
  • drug_check_yn — varchar(1)
  • etc_check_yn — varchar(1)
  • female_yn — varchar(1)
  • marital_yn — varchar(1)
  • memo — text
  • interview_yn — int
  • confirm_yn — varchar(1)
  • status — int
  • manager_check_yn — varchar(1)
  • inquiry_hope_yn — varchar(1)
  • channel — int
  • inquiry_time_code — varchar(2)
  • inquiry_memo — text
  • inquired_at — datetime
  • inquiry_state — int
  • inquiry_manager_memo — text
  • counselor — text
  • consulted_at — datetime
  • abroad_yn — varchar(1)
  • country — text
  • visited_at — datetime
  • breath_yn — varchar(1)
  • address_check_yn — varchar(1)
  • zipcode — text
  • address — text
  • address_detail — text
  • last_examined_at — date
  • last_area — text
  • gongdan_yn — varchar(1)
  • lifetime_yn — varchar(1)
  • specific_yn — varchar(1)
  • web_package_name — text
  • employee_number — text
  • phone — text
  • … +31

reservation_interview

  • id — int — Primary key — NOT NULL
  • reservation_info_id — int — Foreign key → reservation_info.id — NOT NULL
  • code — VARCHAR(255)
  • question — text
  • type — int
  • deleted_yn — VARCHAR(255)
  • updated_at — VARCHAR(255)
  • created_at — date

user_info

  • id — int — Primary key — NOT NULL
  • username — text
  • password — text
  • role — text
  • created_at — datetime
  • updated_at — datetime
  • delete_yn — varchar(1)
  • change_yn — varchar(1)