Skip to content

Commit dda86f0

Browse files
elinabelelinabel
authored
Create README.md
1 parent 951505b commit dda86f0

1 file changed

Lines changed: 382 additions & 0 deletions

File tree

  • Урок 10.2 Ограничения

‎Урок 10.2 Ограничения/README.md‎

Lines changed: 382 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,382 @@
1+
# Ограничения
2+
```sql
3+
drop table internet_customer;
4+
```
5+
```sql
6+
create table internet_customer (
7+
customer_id serial not null,
8+
login varchar(20) not null,
9+
first_name character(20) not null,
10+
last_name character(20) not null,
11+
patronymic character varying(20) null,
12+
rating float default(0) not null,
13+
birthday date null
14+
);
15+
```
16+
```sql
17+
insert
18+
into
19+
public.internet_customer
20+
(login,
21+
first_name,
22+
last_name,
23+
patronymic,
24+
birthday)
25+
values
26+
('login1',
27+
'ivan',
28+
'petrov',
29+
null,
30+
'1987-01-03'),
31+
32+
('login2',
33+
'petr',
34+
'ivanov',
35+
'makarovich',
36+
'1991-10-11'),
37+
38+
('login3',
39+
'сергей',
40+
'иванов',
41+
'андреевич',
42+
'1995-11-02');
43+
```
44+
```sql
45+
select
46+
*
47+
from
48+
internet_customer;
49+
```
50+
```sql
51+
drop table internet_customer;
52+
```
53+
```sql
54+
create table internet_customer (
55+
customer_id serial not null,
56+
login varchar(20) not null check(length(login) >= 6),
57+
first_name character(20) not null,
58+
last_name character(20) not null,
59+
patronymic character varying(20) null,
60+
rating float default(0) not null constraint internet_customer_rating check(rating >= 0),
61+
birthday date null
62+
);
63+
```
64+
```sql
65+
insert
66+
into
67+
public.internet_customer
68+
(login,
69+
first_name,
70+
last_name,
71+
patronymic,
72+
birthday)
73+
values
74+
('login1',
75+
'ivan',
76+
'petrov',
77+
null,
78+
'1987-01-03'),
79+
('login2',
80+
'petr',
81+
'ivanov',
82+
'makarovich',
83+
'1991-10-11'),
84+
('login3',
85+
'сергей',
86+
'иванов',
87+
'андреевич',
88+
'1995-11-02');
89+
```
90+
91+
```sql
92+
drop table internet_customer;
93+
```
94+
```sql
95+
create table internet_customer (
96+
customer_id serial not null,
97+
login varchar(20) not null check(length(login) >= 6
98+
and login <> first_name
99+
and login <> last_name),
100+
first_name character(20) not null,
101+
last_name character(20) not null,
102+
patronymic character varying(20) null,
103+
rating float default(0) not null constraint internet_customer_rating check(rating >= 0),
104+
birthday date null
105+
);
106+
```
107+
```sql
108+
insert
109+
into
110+
public.internet_customer
111+
112+
(login,
113+
first_name,
114+
last_name,
115+
patronymic,
116+
birthday)
117+
values
118+
119+
('login1',
120+
'ivan',
121+
'petrov',
122+
null,
123+
'1987-01-03'),
124+
125+
('login2',
126+
'petr',
127+
'ivanov',
128+
'makarovich',
129+
'1991-10-11'),
130+
131+
('login3',
132+
'сергей',
133+
'иванов',
134+
'андреевич',
135+
'1995-11-02');
136+
```
137+
```sql
138+
drop table internet_customer;
139+
```
140+
```sql
141+
create table internet_customer (
142+
customer_id serial not null,
143+
login varchar(20) not null,
144+
first_name character(20) not null,
145+
last_name character(20) not null,
146+
patronymic character varying(20) null,
147+
rating float default(0) not null,
148+
birthday date null,
149+
check(length(login) >= 6
150+
and login <> first_name
151+
and login <> last_name),
152+
constraint internet_customer_rating check(rating >= 0)
153+
);
154+
```
155+
```sql
156+
drop table internet_customer;
157+
```
158+
```sql
159+
create table internet_customer (
160+
customer_id serial not null,
161+
login varchar(20) not null,
162+
first_name character(20) not null,
163+
last_name character(20) not null,
164+
patronymic character varying(20) null,
165+
rating float default(0) not null,
166+
birthday date null,
167+
check(length(login) >= 6
168+
and login <> first_name
169+
and login <> last_name
170+
and rating >= 0)
171+
);
172+
```
173+
```sql
174+
drop table internet_customer;
175+
```
176+
```sql
177+
create table internet_customer (
178+
customer_id serial not null,
179+
login varchar(20) not null unique,
180+
first_name character(20) not null,
181+
last_name character(20) not null,
182+
patronymic character varying(20) null,
183+
rating float default(0) not null,
184+
birthday date null,
185+
check(length(login) >= 6
186+
and login <> first_name
187+
and login <> last_name
188+
and rating >= 0),
189+
constraint internet_customer_unique_fi unique(first_name,
190+
last_name)
191+
);
192+
```
193+
```sql
194+
insert
195+
into
196+
public.internet_customer
197+
198+
(login,
199+
first_name,
200+
last_name,
201+
patronymic,
202+
birthday)
203+
values
204+
205+
('login1',
206+
'ivan',
207+
'petrov',
208+
null,
209+
'1987-01-03'),
210+
211+
('login2',
212+
'ivan',
213+
'sergeev',
214+
'makarovich',
215+
'1991-10-11'),
216+
217+
('login3',
218+
'сергей',
219+
'иванов',
220+
'андреевич',
221+
'1995-11-02');
222+
```
223+
```sql
224+
drop table internet_customer;
225+
```
226+
```sql
227+
create table internet_customer (
228+
customer_id serial primary key,
229+
login varchar(20) not null unique,
230+
first_name character(20) not null,
231+
last_name character(20) not null,
232+
patronymic character varying(20) null,
233+
rating float default(0) not null,
234+
birthday date null,
235+
check(length(login) >= 6
236+
and login <> first_name
237+
and login <> last_name
238+
and rating >= 0),
239+
constraint internet_customer_unique_fi unique(first_name,
240+
last_name)
241+
);
242+
```
243+
```sql
244+
drop table internet_customer;
245+
```
246+
```sql
247+
create table internet_customer (
248+
login varchar(20) primary key,
249+
first_name character(20) not null,
250+
last_name character(20) not null,
251+
patronymic character varying(20) null,
252+
rating float default(0) not null,
253+
birthday date null,
254+
check(length(login) >= 6
255+
and login <> first_name
256+
and login <> last_name
257+
and rating >= 0),
258+
constraint internet_customer_unique_fi unique(first_name,
259+
last_name)
260+
);
261+
```
262+
```sql
263+
insert
264+
into
265+
public.internet_customer
266+
267+
(login,
268+
first_name,
269+
last_name,
270+
patronymic,
271+
birthday)
272+
values
273+
274+
('login1',
275+
'ivan',
276+
'petrov',
277+
null,
278+
'1987-01-03'),
279+
280+
('login2',
281+
'ivan',
282+
'sergeev',
283+
'makarovich',
284+
'1991-10-11'),
285+
286+
('login3',
287+
'сергей',
288+
'иванов',
289+
'андреевич',
290+
'1995-11-02');
291+
```
292+
```sql
293+
drop table internet_customer;
294+
create table internet_customer (
295+
login varchar(20) not null unique,
296+
first_name character(20) not null,
297+
last_name character(20) not null,
298+
patronymic character varying(20) null,
299+
rating float default(0) not null,
300+
birthday date null,
301+
check(length(login) >= 6
302+
and login <> first_name
303+
and login <> last_name
304+
and rating >= 0),
305+
constraint internet_customer_unique_fi unique(first_name,
306+
last_name),
307+
primary key(first_name,
308+
last_name)
309+
);
310+
```
311+
```sql
312+
insert
313+
into
314+
public.internet_customer
315+
316+
(login,
317+
first_name,
318+
last_name,
319+
patronymic,
320+
birthday)
321+
values
322+
323+
('login1',
324+
'ivan',
325+
'petrov',
326+
null,
327+
'1987-01-03'),
328+
329+
('login2',
330+
'ivan',
331+
'sergeev',
332+
'makarovich',
333+
'1991-10-11'),
334+
335+
('login3',
336+
'сергей',
337+
'иванов',
338+
'андреевич',
339+
'1995-11-02');
340+
341+
```
342+
```sql
343+
select
344+
*
345+
from
346+
internet_customer;
347+
```
348+
```sql
349+
create table internet_order (
350+
internet_order_id serial primary key,
351+
internet_customer_id int references internet_customer(customer_id),
352+
film varchar(50)
353+
);
354+
```
355+
```sql
356+
insert
357+
into
358+
internet_order
359+
360+
(internet_customer_id,
361+
film)
362+
values
363+
364+
(1,
365+
'some film');
366+
```
367+
```sql
368+
select
369+
*
370+
from
371+
internet_order;
372+
```
373+
```sql
374+
insert
375+
into
376+
internet_order
377+
(internet_customer_id,
378+
film)
379+
values
380+
(4,
381+
'some film');
382+
```

0 commit comments

Comments
 (0)