CREATE TABLE positions (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	sap_id BIGINT UNIQUE,
	title VARCHAR(255),
	location VARCHAR(255),
	grade VARCHAR(255),
	classification VARCHAR(255),
	division_id INT,
	branch_id INT,
	section_id INT,
	org_unit_id INT,
	ee_group_id TINYINT,
	ee_subgroup_id TINYINT,
	work_schedule_rule INT,
	FOREIGN KEY fk_division (division_id) REFERENCES divisions (id),
	FOREIGN KEY fk_branch (branch_id) REFERENCES branches (id),
	FOREIGN KEY fk_section (section_id) REFERENCES sections (id),
	FOREIGN KEY fk_org_unit (org_unit_id) REFERENCES org_units (id),
	FOREIGN KEY fk_ee_group (ee_group_id) REFERENCES ee_groups (id),
	FOREIGN KEY fk_ee_subgroup (ee_subgroup_id) REFERENCES ee_subgroups (id)
);
