Ограничения

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Petr', 'Ivanov', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

select * from internet_customer;

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null check(length(login) >= 6),

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null constraint internet_customer_rating check(rating >= 0),

birthday date null

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Petr', 'Ivanov', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null check(length(login) >= 6 and login <> first_name and login <> last_name),

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null constraint internet_customer_rating check(rating >= 0),

birthday date null

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Petr', 'Ivanov', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name),

constraint internet_customer_rating check(rating >= 0)

);

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name and rating >= 0)

);

drop table internet_customer;

create table internet_customer (

customer_id serial not null,

login varchar(20) not null unique,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name and rating >= 0),

constraint internet_customer_unique_fi unique(first_name, last_name)

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Ivan', 'Sergeev', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

drop table internet_customer;

create table internet_customer (

customer_id serial primary key,

login varchar(20) not null unique,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name and rating >= 0),

constraint internet_customer_unique_fi unique(first_name, last_name)

);

drop table internet_customer;

create table internet_customer (

login varchar(20) primary key,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name and rating >= 0),

constraint internet_customer_unique_fi unique(first_name, last_name)

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Ivan', 'Sergeev', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

drop table internet_customer;

create table internet_customer (

login varchar(20) not null unique,

first_name character(20) not null,

last_name character(20) not null,

patronymic character varying(20) null,

rating float default(0) not null,

birthday date null,

check(length(login) >= 6 and login <> first_name and login <> last_name and rating >= 0),

constraint internet_customer_unique_fi unique(first_name, last_name),

primary key(first_name, last_name)

);

INSERT INTO public.internet_customer

(login, first_name, last_name, patronymic, birthday)

values

('login1', 'Ivan', 'Petrov', null, '1987-01-03'),

('login2', 'Ivan', 'Sergeev', 'Makarovich', '1991-10-11'),

('login3', 'Сергей', 'Иванов', 'Андреевич', '1995-11-02');

select * from internet_customer;

create table internet_order (

internet_order_id serial primary key,

internet_customer_id int references internet_customer(customer_id),

film varchar(50)

);

insert into internet_order

(internet_customer_id, film)

values 

(1, 'Some film');

select * from internet_order;

insert into internet_order

(internet_customer_id, film)

values 

(4, 'Some film');