1 |
|
---|
2 | CREATE TABLE dealership (
|
---|
3 | Tax_Nr varchar(50) primary key,
|
---|
4 | D_Name varchar(50) not null,
|
---|
5 | Email varchar(50) not null,
|
---|
6 | Pass varchar(50) not null,
|
---|
7 | CEO varchar(50),
|
---|
8 | Telephones varchar(200)[],
|
---|
9 | Addresses varchar(200)[] not null
|
---|
10 | );
|
---|
11 |
|
---|
12 | CREATE TYPE body_type AS ENUM ('Motorcycle', 'Car', 'Truck', 'Van');
|
---|
13 | CREATE TYPE color_type AS ENUM ('black', 'white', 'red', 'blue', 'green', 'yellow', 'orange', 'purple', 'silver', 'grey', 'cyan', 'magenta');
|
---|
14 |
|
---|
15 | CREATE TABLE vehicle (
|
---|
16 | VIN varchar(50) primary key,
|
---|
17 | Body body_type not null,
|
---|
18 | Model varchar(50) not null,
|
---|
19 | P_Year integer not null,
|
---|
20 | Engine varchar(100) not null,
|
---|
21 | Color color_type,
|
---|
22 | Price integer not null,
|
---|
23 | Status boolean not null,
|
---|
24 | Tax_Nr varchar(50) not null,
|
---|
25 | constraint fk_Dealership foreign key (Tax_Nr) references dealership(Tax_Nr)
|
---|
26 | );
|
---|
27 |
|
---|
28 | CREATE TABLE client (
|
---|
29 | EMBG varchar(50) primary key,
|
---|
30 | C_Name varchar(50) not null,
|
---|
31 | Email varchar(50) not null,
|
---|
32 | Pass varchar(50) not null,
|
---|
33 | Telephone varchar(50)
|
---|
34 | );
|
---|
35 |
|
---|
36 |
|
---|
37 | CREATE TABLE agreement (
|
---|
38 | A_Id serial primary key,
|
---|
39 | Price Integer not null,
|
---|
40 | Dependent varchar(200)[] not null,
|
---|
41 | Status boolean not null,
|
---|
42 | Datum date not null,
|
---|
43 | Tax_Nr varchar(50) not null,
|
---|
44 | VIN varchar(50) not null,
|
---|
45 | EMBG varchar(50) not null,
|
---|
46 | constraint fk_Dealership foreign key (Tax_Nr) references dealership(Tax_Nr),
|
---|
47 | constraint fk_Vehicle foreign key (VIN) references vehicle(VIN),
|
---|
48 | constraint fk_Client foreign key (EMBG) references client(EMBG)
|
---|
49 | );
|
---|
50 |
|
---|
51 | CREATE TABLE payment(
|
---|
52 | P_Id serial primary key,
|
---|
53 | Bank varchar(50) not null,
|
---|
54 | Account varchar(100) not null,
|
---|
55 | Amount integer not null,
|
---|
56 | EMBG varchar(50) not null,
|
---|
57 | A_Id integer not null,
|
---|
58 | constraint fk_Agreement foreign key (A_Id) references agreement(A_Id),
|
---|
59 | constraint fk_Client foreign key (EMBG) references client(EMBG)
|
---|
60 | );
|
---|