chaema
Tables (45)
account_emailaddress
- id — int(11) — Primary key — NOT NULL
- email — varchar(254) — NOT NULL
- verified — tinyint(1) — NOT NULL
- primary — tinyint(1) — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
account_emailconfirmation
- id — int(11) — Primary key — NOT NULL
- created — datetime(6) — NOT NULL
- sent — datetime(6)
- key — varchar(64) — NOT NULL
- email_address_id — int(11) — Foreign key → account_emailaddress.id — NOT NULL
auth_group
- id — int(11) — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — int(11) — Primary key — NOT NULL
- group_id — int(11) — Foreign key → auth_group.id — NOT NULL
- permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- codename — varchar(100) — NOT NULL
auth_sms
- phone_number — varchar(11) — Primary key — NOT NULL
- auth_number — int(11) — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
authtoken_token
- key — varchar(40) — Primary key — NOT NULL
- created — datetime(6) — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
backend_alarm
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- title — varchar(200)
- contents — longtext
- is_read — tinyint(1) — NOT NULL
- link_url — varchar(200)
- alarm_gubun_id — varchar(9) — Foreign key → backend_comcode.code_id
- receiver_id — int(11) — Foreign key → backend_user.id — NOT NULL
backend_alarmsetting
- id — int(11) — Primary key — NOT NULL
- allow_email — tinyint(1) — NOT NULL
- allow_fcm — tinyint(1) — NOT NULL
- allow_kakao — tinyint(1) — NOT NULL
- allow_sms — tinyint(1) — NOT NULL
- alarm_code_id — varchar(9) — Foreign key → backend_comcode.code_id
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
backend_comcode
- code_id — varchar(9) — Primary key — NOT NULL
- code_name — varchar(50) — NOT NULL
- code_topidx — varchar(2)
- code_topcd — varchar(9)
- code_use — tinyint(1) — NOT NULL
- comidx_id — varchar(2) — Foreign key → backend_comidx.idx_id — NOT NULL
backend_comidx
- idx_id — varchar(2) — Primary key — NOT NULL
- idx_name — varchar(50) — NOT NULL
- idx_use — tinyint(1) — NOT NULL
backend_compacode
- id — int(11) — Primary key — NOT NULL
- zikcode1 — varchar(5)
- zikname1 — varchar(200)
- zikcode2 — varchar(5)
- zikname2 — varchar(200)
- zikcode3 — varchar(5)
- zikname3 — varchar(200)
- paname1 — varchar(50)
backend_companybaseinfo
- id — int(11) — Primary key — NOT NULL
- custid — varchar(13)
- subject — varchar(10)
- main_category — varchar(2)
- mid_category — varchar(3)
- detail1_category — varchar(4)
- detail2_category — varchar(5)
- com_name — varchar(100)
- stock_code — varchar(6)
- finance_year — varchar(6)
- group_name — varchar(100)
- com_telno — varchar(20)
- com_addr — varchar(300)
- found_date — varchar(8)
- website — varchar(50)
- emp_count — varchar(10)
- gross_total — int(11)
backend_demand
- id — int(11) — Primary key — NOT NULL
- demand_ym — varchar(6) — NOT NULL
- demand_amount — int(11)
- paidup_ymdt — datetime(6) — NOT NULL
- paidup_yn — tinyint(1) — NOT NULL
- discount_ratio — double — NOT NULL
- hrprofile_id — int(11) — Foreign key — NOT NULL
- paidup_user_id — int(11) — Foreign key → backend_user.id
backend_faq
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- faq_title — varchar(100) — NOT NULL
- faq_text — longtext — NOT NULL
- faq_gubun_id — varchar(9) — Foreign key → backend_comcode.code_id — NOT NULL
backend_jikjong
- jikjong_mid_id — varchar(9) — Foreign key → backend_comcode.code_id — NOT NULL
- jikjong_comment — longtext
backend_jikjonglow
- id — int(11) — Primary key — NOT NULL
- compacode_id — int(11) — Foreign key → backend_compacode.id
- jikjong_low_id — varchar(9) — Foreign key → backend_comcode.code_id — NOT NULL
backend_notification
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- noti_event — varchar(1000)
- noti_category_id — varchar(9) — Foreign key → backend_comcode.code_id
- noti_level_id — varchar(9) — Foreign key → backend_comcode.code_id
backend_point
- id — int(11) — Primary key — NOT NULL
- point — int(11)
- point_gubun_id — varchar(9) — Foreign key → backend_comcode.code_id
- sugub_review_id — int(11) — Foreign key → company_profile_sugubreview.id
backend_qna
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- qna_email — varchar(254) — NOT NULL
- qna_phone — varchar(30)
- qna_title — varchar(100) — NOT NULL
- qna_text — longtext — NOT NULL
- qna_attach — varchar(100)
backend_user
- id — int(11) — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- email — varchar(255) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- is_admin — tinyint(1) — NOT NULL
- is_temp — tinyint(1) — NOT NULL
- phone — varchar(13)
- nickname — varchar(50)
- is_agree — tinyint(1) — NOT NULL
- is_privacy — tinyint(1) — NOT NULL
- profile_image — varchar(255)
chat_chatroom
- id — int(11) — Primary key — NOT NULL
- room_name — varchar(50)
- created_at — datetime(6) — NOT NULL
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
- is_end — tinyint(1) — NOT NULL
chat_chatroom_exit_participants
- id — int(11) — Primary key — NOT NULL
- chatroom_id — int(11) — Foreign key → chat_chatroom.id — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
chat_chatroom_participants
- id — int(11) — Primary key — NOT NULL
- chatroom_id — int(11) — Foreign key → chat_chatroom.id — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
chat_message
- id — char(32) — Primary key — NOT NULL
- content — longtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- author_id — int(11) — Foreign key → backend_user.id — NOT NULL
- chatroom_id — int(11) — Foreign key → chat_chatroom.id
company_profile_companyaccountinfo
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- account_name — varchar(50) — NOT NULL
- account_phone — varchar(13) — NOT NULL
- account_email — varchar(254) — NOT NULL
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id — NOT NULL
company_profile_companyimage
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- companyprofile_image — varchar(100)
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id — NOT NULL
company_profile_companyprofile
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- custname — varchar(100)
- custid — varchar(13)
- gross_total — int(11)
- homepage — varchar(100)
- introduce — longtext
- upjong — varchar(9)
- stock_gubun — varchar(1)
- group_company — varchar(50)
- load_addr_code — varchar(5)
- load_addr — varchar(50)
- load_addr_detail — varchar(50)
- post_addr_code — varchar(5)
- post_addr — varchar(50)
- post_addr_detail — varchar(50)
- nation — varchar(9)
- emp_count — int(11)
- manager_email — varchar(30)
- manager_phone — varchar(11)
- company_image — varchar(100)
- company_logo — varchar(100)
- ticket — int(11) — NOT NULL
- cmp_manager_id — int(11) — Foreign key → backend_user.id
- company_recuser_id — int(11) — Foreign key → backend_user.id
- status_cd_id — varchar(9) — Foreign key → backend_comcode.code_id
company_profile_companyprofile_user
- id — int(11) — Primary key — NOT NULL
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
company_profile_companyprofilecoworker
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- coworker_phone — varchar(11)
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id
- companyprofile_auth_id — varchar(9) — Foreign key → backend_comcode.code_id
- user_id — int(11) — Foreign key → backend_user.id
company_profile_estimate
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- hrprofile_id — int(11) — Foreign key
- sugub_id — int(11) — Foreign key → company_profile_sugub.id — NOT NULL
- user_id — int(11) — Foreign key → backend_user.id
- comments — longtext
company_profile_estimatefile
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- estimate_file — varchar(100)
- estimate_id — int(11) — Foreign key → company_profile_estimate.id — NOT NULL
company_profile_importpaymenthistory
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- pg — varchar(50)
- imp_uid — varchar(100)
- merchant_uid — varchar(100)
- paid_amount — int(11) — NOT NULL
- cancel_request_amount — int(11) — NOT NULL
- reason — varchar(500)
- apply_num — varchar(100)
- user_id — int(11) — Foreign key → backend_user.id — NOT NULL
company_profile_interview
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- interview_dt — datetime(6) — NOT NULL
- comments — longtext — NOT NULL
- addr_code — varchar(5) — NOT NULL
- addr — varchar(100) — NOT NULL
- addr_detail — varchar(100) — NOT NULL
- jobapp_id — int(11) — Foreign key → company_profile_jobapplicant.id — NOT NULL
- interview_email — varchar(50)
- interview_manager — varchar(50)
- interview_phone — varchar(50)
company_profile_jobadvertise (채용공고)
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- jobadvertise_title — longtext
- company_name — varchar(50)
- company_introduce — longtext
- company_name_yn — tinyint(1) — NOT NULL
- main_work — longtext
- main_work_yn — tinyint(1) — NOT NULL
- dpt_name — longtext
- dpt_name_yn — tinyint(1) — NOT NULL
- salary — longtext
- salary_yn — tinyint(1) — NOT NULL
- condition — longtext
- condition_yn — tinyint(1) — NOT NULL
- special_condition — longtext
- special_condition_yn — tinyint(1) — NOT NULL
- welfare — longtext
- welfare_yn — tinyint(1) — NOT NULL
- location — longtext
- location_yn — tinyint(1) — NOT NULL
- jobadvertise_addr_code — varchar(5)
- jobadvertise_addr — varchar(50)
- jobadvertise_addr_detail — varchar(500)
- jobadvertise_end_dt — date
- job_reward_amt1 — int(11) — NOT NULL
- job_reward_amt2 — int(11) — NOT NULL
- job_image — varchar(100)
- job_background_image — varchar(100)
- request_ticket — int(11) — NOT NULL
- jobtag_json — json
- job_manager_id — int(11) — Foreign key → backend_user.id
- job_reward_type_id — varchar(9) — Foreign key → backend_comcode.code_id
- job_reward_way_id — varchar(9) — Foreign key → backend_comcode.code_id
- jobadvertise_status_id — varchar(9) — Foreign key → backend_comcode.code_id
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
company_profile_jobanswer (공고별답변)
- id — int(11) — Primary key — NOT NULL
- job_answer_comment — varchar(1000)
- job_answer_type_id — varchar(9) — Foreign key → backend_comcode.code_id
- jobquestion_id — int(11) — Foreign key → company_profile_jobquestion.id — NOT NULL
company_profile_jobapplicant (채용지원자)
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- urlkey — varchar(100)
- applied_at — datetime(6) — NOT NULL
- applied_comment — longtext
- resume_pdf — varchar(100)
- resume_filename — varchar(100)
- applied_username — varchar(100)
- applied_phone — varchar(13)
- applied_birth — varchar(10)
- job_answers_json — json
- applied_status_id — varchar(9) — Foreign key → backend_comcode.code_id
- jobadvertise_id — int(11) — Foreign key → company_profile_jobadvertise.id
- resume_id — int(11) — Foreign key
- url_recuser_id — int(11) — Foreign key → backend_user.id
- user_id — int(11) — Foreign key → backend_user.id
- hrprofile_id — int(11) — Foreign key
- hrmanager_id — int(11) — Foreign key → backend_user.id
company_profile_jobquestion (공고별질문)
- id — int(11) — Primary key — NOT NULL
- job_question_comment — varchar(100)
- jobadvertise_id — int(11) — Foreign key → company_profile_jobadvertise.id
company_profile_sugub (수급의뢰서)
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- custid — varchar(13)
- chae_gigan — int(11)
- sugub_title — varchar(50)
- sugub_end_dt — date
- career_start — int(11)
- career_end — int(11)
- work_role — longtext
- work_position — varchar(50)
- sugub_gender_id — varchar(9) — Foreign key → backend_comcode.code_id
- age_start — int(11)
- age_end — int(11)
- work_load_addr_code — varchar(5)
- work_load_addr — varchar(100)
- work_load_addr_detail — varchar(500)
- work_post_addr_code — varchar(5)
- work_post_addr — varchar(100)
- work_post_addr_detail — varchar(500)
- salary_start — int(11)
- salary_end — int(11)
- bokri — longtext
- spec — longtext
- wrk_condition — longtext
- created_at — datetime(6) — NOT NULL
- apply_gubun — varchar(9)
- submit_doc — varchar(9)
- work_dept — varchar(50)
- hire_count — int(11)
- hire_type_id — varchar(9) — Foreign key → backend_comcode.code_id
- cont_chg_gb_id — varchar(9) — Foreign key → backend_comcode.code_id
- work_type_id — varchar(9) — Foreign key → backend_comcode.code_id
- work_type_comment — varchar(100)
- work_time_start — varchar(4)
- work_time_end — varchar(4)
- work_rest_start — varchar(4)
- work_rest_end — varchar(4)
- work_rest_comment — longtext
- salary_gubun_id — varchar(9) — Foreign key → backend_comcode.code_id
- salary_term — varchar(9)
- work_site_gubun — varchar(9)
- work_house_gubun — tinyint(1) — NOT NULL
- work_near_subway — varchar(9)
- work_traffic — longtext
- sugub_salary_adjust — tinyint(1) — NOT NULL
- chae_cd_id — varchar(9) — Foreign key → backend_comcode.code_id
- chae_gigan_type_id — varchar(9) — Foreign key → backend_comcode.code_id
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id
- education_cd_id — varchar(9) — Foreign key → backend_comcode.code_id
- manager_id — int(11) — Foreign key → backend_user.id
- sugub_career_gb_id — varchar(9) — Foreign key → backend_comcode.code_id
- sugub_jikjong_mid_id — varchar(9) — Foreign key → backend_comcode.code_id
- sugub_jikjong_top_id — varchar(9) — Foreign key → backend_comcode.code_id
- sugub_status_id — varchar(9) — Foreign key → backend_comcode.code_id
- user_id — int(11) — Foreign key → backend_user.id
- etc — longtext
- ot_daily — int(11) — NOT NULL
- ot_daily_yn — tinyint(1) — NOT NULL
- ot_holiday — int(11) — NOT NULL
- … +4
company_profile_sugub_sugub_jikjong_low
- id — int(11) — Primary key — NOT NULL
- sugub_id — int(11) — Foreign key → company_profile_sugub.id — NOT NULL
- comcode_id — varchar(9) — Foreign key → backend_comcode.code_id — NOT NULL
company_profile_sugubreview (리뷰)
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- review_comment — longtext
- hrprofile_id — int(11) — Foreign key
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
- user_id — int(11) — Foreign key → backend_user.id
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id
company_profile_sugubsign
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- damdang_id — int(11) — Foreign key → backend_user.id
- sanctioner_id — int(11) — Foreign key → backend_user.id
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
- sign_code_id — varchar(9) — Foreign key → backend_comcode.code_id
company_profile_sugubsuccess
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- chae_cd — varchar(100)
- sugub_jikjong — varchar(500)
- work_position — varchar(50)
- work_role — longtext
- sugub_career_gb — varchar(50)
- education_cd — varchar(50)
- salary_gubun — varchar(50)
- work_load_addr — varchar(100)
- spec — longtext
- bokri — longtext
- hrprofile_id — int(11) — Foreign key
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
- sugub_title — varchar(50)
employee_contract
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- contract_from — varchar(8)
- contract_to — varchar(8)
- direct_cost — int(11)
- contract_gigan — int(11)
- employee_id — int(11) — Foreign key — NOT NULL
- hrprofile_id — int(11) — Foreign key
- sugub_id — int(11) — Foreign key → company_profile_sugub.id
- companyprofile_id — int(11) — Foreign key → company_profile_companyprofile.id
- chae_cd_id — varchar(9) — Foreign key → backend_comcode.code_id
- is_confirm — tinyint(1) — NOT NULL
employee_contractfile
- id — int(11) — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6) — NOT NULL
- contract_file — varchar(100)
- contract_id — int(11) — Foreign key → employee_contract.id — NOT NULL