23 lines
615 B
SQL
23 lines
615 B
SQL
CREATE TABLE divisions (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(255) NOT NULL UNIQUE
|
|
);
|
|
|
|
CREATE TABLE departments (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(255) NOT NULL,
|
|
division_id INT NOT NULL,
|
|
FOREIGN KEY (division_id) REFERENCES divisions(id) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE roles (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(255) NOT NULL,
|
|
department_id INT NOT NULL,
|
|
FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE CASCADE
|
|
);
|
|
|
|
ALTER TABLE users
|
|
ADD COLUMN division_id INT,
|
|
ADD COLUMN department_id INT,
|
|
ADD COLUMN role_id INT; |