alter-user_roles.sql

ALTER TABLE [dbo].[user_roles] 
ADD id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY;

availabilities.sql

CREATE TABLE [availablities]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	user_role_id INT NOT NULL REFERENCES [dbo].[users](id),
	shift_id INT NOT NULL REFERENCES [dbo].[shifts](id),
	department_id INT NOT NULL REFERENCES [dbo].[departments](id),
	location_id INT NOT NULL REFERENCES [dbo].[locations](id)
);

cities.sql

CREATE TABLE [cities]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50) NOT NULL
);

companies.sql

CREATE TABLE [companies]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50) NOT NULL,
	city_id INT NOT NULL REFERENCES [dbo].[cities](id),
	industry_id INT NOT NULL REFERENCES [dbo].[industries](id)
);

days.sql

CREATE TABLE [days]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50),
);

departments.sql

CREATE TABLE [departments]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50)
);

industries.sql

CREATE TABLE [industries]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50)
);

locations.sql

CREATE TABLE [locations]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50)
);

positions.sql

CREATE TABLE [positions]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50)
);

reports.sql

CREATE TABLE [reports]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	title VARCHAR(50) NOT NULL,
	summary VARCHAR(128) NOT NULL,
	introduction VARCHAR(128) NOT NULL,
	body VARCHAR(256) NOT NULL,
	department_id INT NOT NULL REFERENCES [dbo].[departments](id),
	user_id INT NOT NULL REFERENCES [dbo].[users](id)
);

roles.sql

CREATE TABLE [roles]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50),
);

schedules.sql

CREATE TABLE [schedules]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50) NOT NULL,
	department_id INT NOT NULL REFERENCES [dbo].[departments](id),
	position_id INT NOT NULL REFERENCES [dbo].[positions](id),
	total_hours INT NOT NULL,
	day_id INT NOT NULL REFERENCES [dbo].[days](id)
);

shifts.sql

CREATE TABLE [shifts]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50)
);

teams.sql

CREATE TABLE [teams]
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	name VARCHAR(50) NOT NULL,
	user_roles INT NOT NULL REFERENCES [dbo].[user_roles](id),
	department_id INT NOT NULL REFERENCES [dbo].[departments](id),
	location_id INT NOT NULL REFERENCES [dbo].[locations](id)
);

user_roles.sql

CREATE TABLE [user_roles] 
(
	user_id INT NOT NULL REFERENCES [dbo].[users](id),
	role_id INT NOT NULL REFERENCES [dbo].[roles](id)
);

users.sql

CREATE TABLE [users] 
(
	id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	first_name VARCHAR(50) NOT NULL,
	last_name VARCHAR(50) NOT NULL,
	email VARCHAR(100) NOT NULL,
	role_id INT NOT NULL REFERENCES [dbo].[roles](id),
	position_id INT NOT NULL REFERENCES [dbo].[positions](id),
	department_id INT NOT NULL REFERENCES [dbo].[departments](id)
);