t0p7JR4J

1drop table if exists holder cascade;
2drop table if exists car  cascade;
3drop table if exists places cascade;
4drop table if exists payment  cascade;
5
6
7drop sequence if exists holder_ids cascade;
8drop sequence if exists car_ids cascade;
9drop sequence if exists places_ids cascade;
10drop sequence if exists payment_ids cascade;
11
12
13
14create sequence holder_ids;
15create table if not exists holder(
16   id int primary key default nextval('holder_ids'),
17    name char(256) not null ,
18    adress char(100) not null ,
19   phone char(15) not null
20);
21
22
23
24create sequence places_ids;
25create table if not exists places(
26  id int primary key default nextval('places_ids'),
27  number_of_places int not null ,
28  conopy char
29
30);
31
32create sequence car_ids;
33create table if not exists car(
34  id int primary key default nextval('car_ids'),
35  mark char(20) not null ,
36  number_of_car char not null ,
37  colour char not null ,
38  holder_id int not null,
39  foreign key (holder_id) references holder(id)
40
41);
42
43
44create sequence payment_ids;
45create table if not exists payment(
46id int primary key default nextval('payment_ids'),
47  number_of_places int not null ,
48  car_id int not null ,
49  holder_id int not null,
50  foreign key (car_id) references  car(id),
51  foreign key (holder_id) references  holder(id)
52
53);
54
55insert into holder
56values (nextval('holder_ids'),'Аль_эзари Аднан Рашид','Ицxака Рабина 5','380931131084');
57insert into holder
58values (nextval('holder_ids'),'Дмитренко Александр Александрович','Заболотного 52','3809299123');
59
60insert into places
61values (nextval('places_ids'),52,'+');
62insert into places
63values (nextval('places_ids'),11,'-');
64
65insert into car
66values (nextval('car_ids'),'BMW','7777','чёрный',1);
67insert into car
68values (nextval('car_ids'),'Mercedes-Benz','3333','белый',2);
69
70insert into payment
71values (nextval('payment_ids'),52,1,1);
72insert into payment
73values (nextval('payment_ids'),22,2,2);
74
75Select * from holder;
76Select * from places;
77Select * from car;
78Select * from payment;