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