Job_recommendation&employ_system

Tables (8)

com_info

  • id — int(11) — Primary key — NOT NULL
  • com_id — int(11) — Foreign key → job_planet.id
  • com_bis — varchar(100)
  • com_emp — varchar(50)
  • com_div — varchar(50)
  • com_est — varchar(50)
  • com_capital — varchar(50)
  • com_rev — varchar(50)
  • com_sal — varchar(50)
  • com_ceo — varchar(50)
  • com_main_bis — varchar(200)
  • com_en — varchar(50)
  • com_page — varchar(100)
  • com_address — varchar(100)
  • com_rel_com — varchar(200)

department

  • department_key — int(11) — Primary key — NOT NULL
  • department_name — varchar(30)

job_planet

  • id — int(11) — Primary key — NOT NULL
  • com_name — varchar(50)
  • com_relation — float
  • mean_star — float
  • com_review — float
  • mean_sal — float
  • welfare_sal — float
  • wo_la_bal — float
  • com_cul — float
  • opportunity — float
  • com_head — float
  • com_rec — float
  • CEO_sup — float
  • growth_pos — float

payment_info

  • payment_id — int(11) — Primary key — NOT NULL
  • badge_id — int(11) — Foreign key → user_info.BADGE — NOT NULL
  • payment — int(11)
  • payment_type — varchar(30)
  • payment_date — datetime — NOT NULL

user_com

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user_info.BADGE
  • com_id — int(11) — Foreign key → job_planet.id
  • com_relation — float
  • mean_star — float
  • com_review — float
  • mean_sal — float — NOT NULL
  • welfare_sal — float — NOT NULL
  • wo_la_bal — float — NOT NULL
  • com_cul — float — NOT NULL
  • opportunity — float — NOT NULL
  • com_head — float — NOT NULL
  • com_rec — float — NOT NULL
  • CEO_sup — float — NOT NULL
  • growth_pos — float — NOT NULL

user_info

  • BADGE — int(11) — Primary key — NOT NULL
  • name — varchar(30)
  • department — int(11) — Foreign key → department.department_key
  • join_date — datetime — NOT NULL
  • gender — varchar(10)
  • position — varchar(20)

user_rec

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user_info.BADGE
  • mean_sal — float
  • mean_star — float
  • com_review_seg — float
  • welfare_sal — float
  • wo_la_bal — float
  • com_cul — float
  • opportunity — float
  • com_head — float
  • growth_pos_seg — float
  • com_rec_seg — float
  • CEO_sup_seg — float
  • com_result — varchar(200)

user_score

  • user_tb_id — int(11) — Primary key — NOT NULL
  • badge_id — int(11) — Foreign key → user_info.BADGE — NOT NULL
  • score — int(11)
  • test_date — datetime — NOT NULL
  • test_type — varchar(50)