ㅁㅁㅁ
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)