|
1
|
use salarymarket;
|
|
2
|
CREATE TABLE company_compensation (
|
|
3
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
4
|
country varchar(255) NULL,
|
|
5
|
city varchar(255) NULL,
|
|
6
|
site VARCHAR(1) NULL,
|
|
7
|
matricule VARCHAR(255) NULL,
|
|
8
|
department VARCHAR(255) NULL,
|
|
9
|
`function` VARCHAR(255) NULL,
|
|
10
|
internal_grade VARCHAR(255) NULL,
|
|
11
|
gender VARCHAR(2) NULL,
|
|
12
|
birthday DATE NULL,
|
|
13
|
hiring_date DATE NULL,
|
|
14
|
function_code VARCHAR(255) NULL,
|
|
15
|
subfunction_code VARCHAR(255) NULL, -- changed instead of discipline_code
|
|
16
|
collaborative_path VARCHAR(255) NULL, -- changed instead of level_career_path
|
|
17
|
grade VARCHAR(255) NULL, -- changed instead of job_grade
|
|
18
|
number_employees_supervised INT NULL,
|
|
19
|
devise VARCHAR(10) NULL,
|
|
20
|
gross_annual_salary TEXT NULL,
|
|
21
|
number_monthly_salary VARCHAR(255) NULL,
|
|
22
|
type_overtime_pay VARCHAR(255) NULL,
|
|
23
|
seniority_bonus INT NULL, -- new
|
|
24
|
schooling_allowance INT NULL, -- new
|
|
25
|
meal_allowance INT NULL,
|
|
26
|
location_allowance VARCHAR(255) NULL,
|
|
27
|
transportation_allowance INT NULL,
|
|
28
|
other_bonuses_awarded_last_year INT NULL , -- changed instead of other_bonuses_awarded
|
|
29
|
fixed_allowances INT NULL,
|
|
30
|
eligibility_performance_bonus VARCHAR(10) NULL,
|
|
31
|
target_performance_bonus VARCHAR(255) NULL,
|
|
32
|
total_amount_performance_bonus_awarded TEXT NULL,
|
|
33
|
eligibility_commissions VARCHAR(1) NULL,
|
|
34
|
target_variable_sales_compensation VARCHAR(5) NULL ,
|
|
35
|
total_amount_sales_bonus_awarded VARCHAR(255) NULL,
|
|
36
|
total_amount_sales_commissions_awarded VARCHAR(255) NULL,
|
|
37
|
car_benefit_eligibility VARCHAR(1) NULL,
|
|
38
|
car_depreciation TEXT NULL,
|
|
39
|
annual_cost_car_depreciation TEXT NULL,
|
|
40
|
car_allocation_eligibility varchar(1) NULL ,
|
|
41
|
annual_cost_car_allocation TEXT NULL ,
|
|
42
|
poste VARCHAR(255) NULL,
|
|
43
|
companyId INT NULL,
|
|
44
|
FOREIGN KEY (companyId) REFERENCES company(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
45
|
);
|