zXW3QPzV

1create table if not exists studio (
2idstudio serial primary key,
3namestudio varchar (30) not null,
4moneystudio float8,
5clientorderstudio integer
6);
7create table if not exists clientorder (
8idclientorder serial primary key,
9servicesclientorder varchar (30) not null,
10programmerclientorder integer,
11designerclientorder integer,
12managerclientorder integer,
13price float8
14);
15create table if not exists services (
16idservice serial primary key,
17nameservice varchar (30) not null,
18descriptionservice text not null,
19priceservice float8,
20timeservice varchar (30),
21idstudio integer,
22Foreign key (idstudio) references studio(idstudio)
23);
24create table if not exists person (
25idperson serial primary key,
26positionperson integer1 not null,
27dateperson date not null,
28paymentperson float8,
29lastnameperson varchar(30),
30firstnameperson varchar(30),
31patronymicperson varchar(30),
32idstudio integer,
33Foreign key (idstudio) references studio(idstudio)
34);
35create table if not exists provideservices (
36idclientorder integer ,
37Foreign key (idclientorder) references clientorder(idclientorder),
38readyservice boolean,
39idservice integer ,
40Foreign key (idservice) references services(idservice)
41);
42create table if not exists portfolio (
43idexample serial primary key,
44timeexample varchar (30),
45customerexample varchar (60),
46linkexample varchar (60) not null,
47idstudio integer,
48Foreign key (idstudio) references studio(idstudio),
49);
50create table if not exists office (
51address varchar (60),
52dateoffice date,
53personaloffice integer,
54idstudio integer,
55Foreign key (idstudio) references studio(idstudio)
56);
57
58insert into studio (namestudio, moneystudio, clientorderstudio) values
59('Web', '800000','145'),
60('Urus', '928198', '123'),
61('Keto', '3000', '2');
62insert into clientorder (serviseclientorder, programmerclientorder, designerclientorder, managerclientorder, price) values
63('1,2','1','1','1','50000'),
64('2','2','2','2','30000'),
65('1','2','1','2','20000');
66insert into services (nameservice,descriptionservice,priceservice,timeservice)
67('Ter','sdasdasd','999999','2-3 days'),
68('yul','dqeqweq','283129','3 months');
69insert into person (positionperson, dateperson, paymentperson, lastnameperson, firstnameperson, patronymicperson) values
70('1,2', '10.12.2000', '90000', 'Всеволод', 'Хабалов', 'Никонович'),
71('1,2', '13.10.2005', '60000', 'Дементий', 'Яндульский', 'Афанасиевич'),
72('1','10.10.2010', '70000','Изольда', 'Беломестныха', 'Мироновна');
73insert into provideservices (readyservice) values
74('false'),
75('false'),
76('false');
77insert into portfolio (timeexample, customerexample, linkexample) values
78('10.10.2004', 'Lukoil', 'Lukoil.com'),
79('16.12.2003', 'KFC', 'KFC.com');
80insert into office (address, dateoffice, personaloffice) values
81('Moscow', '10.12.1998', '15'),
82('Saint-Peterburg', '18.11.2014, '5');