Ограничения
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');