YdzvdmHi

1CREATE DATABASE IF NOT EXISTS gpt;
2
3USE gpt;
4
5CREATE TABLE IF NOT EXISTS users(
6
7    id BIGINT PRIMARY KEY AUTO_INCREMENT,
8    name VARCHAR(16),
9    surname VARCHAR(16),
10);
11
12CREATE TABLE IF NOT EXISTS fins(
13    id BIGINT PRIMARY KEY AUTO_INCREMENT,
14    fin VARCHAR(16)
15);
16
17CREATE TABLE IF NOT EXISTS departments(
18    id BIGINT PRIMARY KEY AUTO_INCREMENT,
19    fin VARCHAR(16)
20);
21
22CREATE TABLE IF NOT EXISTS roles(
23    id BIGINT PRIMARY KEY AUTO_INCREMENT,
24    boss INT(1)
25);
26
27CREATE TABLE IF NOT EXISTS addresses(
28    id BIGINT PRIMARY KEY AUTO_INCREMENT,
29    address VARCHAR(32)
30);
31
32CREATE TABLE IF NOT EXISTS employee(
33    id BIGINT PRIMARY KEY AUTO_INCREMENT,
34    salary DOUBLE,
35    userId BIGINT FOREIGN KEY REFERENCES users(userId),
36    departmentId BIGINT FOREIGN KEY REFERENCES departments(departmentId),
37    roleId BIGINT FOREIGN KEY REFERENCES roles(roleId)
38);