h4g8QKTE

1CREATE DATABASE IF NOT EXISTS gpt;
2
3USE gpt;
4
5CREATE TABLE IF NOT EXISTS addresses(
6    id BIGINT PRIMARY KEY NOT NULL,
7    address VARCHAR(16)
8);
9
10CREATE TABLE IF NOT EXISTS numbers(
11    id BIGINT PRIMARY KEY NOT NULL,
12    phoneNumber VARCHAR(16)
13);
14
15CREATE TABLE IF NOT EXISTS images(
16    id BIGINT PRIMARY KEY NOT NULL,
17    url VARCHAR(32)
18);
19
20CREATE TABLE IF NOT EXISTS departments(
21    id BIGINT PRIMARY KEY NOT NULL,
22    department VARCHAR(8)
23);
24
25CREATE TABLE IF NOT EXISTS jobs(
26    id BIGINT PRIMARY KEY NOT NULL,
27    departmentId BIGINT,
28    salary DOUBLE NOT NULL,
29    boss BIT NOT NULL,
30
31    FOREIGN KEY (departmenntId) REFERENCES departments(id)
32);
33
34CREATE TABLE IF NOT EXISTS users(
35    id BIGINT PRIMARY KEY AUTO_INCREMENT NOT NULL,
36
37    name VARCHAR(16) NOT NULL,
38    surname VARCHAR(16) NOT NULL,
39    fin VARCHAR(16) NOT NULL UNIQUE
40);