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)