There is no unique constraint matching given keys
there is no unique constraint matching given keys for referenced table "accounting_of_received_calls"
Такую ошибку выводит, что нужно менять?
CREATE TABLE employee_accounting
(
id_employee INTEGER PRIMARY KEY NOT NULL,
first_name CHARACTER VARYING(30),
last_name CHARACTER VARYING(30),
patronymic CHARACTER VARYING(30),
phone CHARACTER VARYING(30),
date_of_issue DATE,
passport_SaN BIGINT,
department_code BIGINT,
residential_address VARCHAR(250),
date_of_birth DATE,
position_ CHARACTER VARYING(30)
);
CREATE TABLE employee_vehicle_accounting
(
number_car INTEGER PRIMARY KEY NOT NULL,
mark VARCHAR(30),
type_ VARCHAR(30),
category VARCHAR(10),
year_of_issue INTEGER NOT NULL,
passport_series BIGINT NOT NULL,
colour CHARACTER VARYING(30)
);
CREATE TABLE vip_customer_accounting
(
id_call INTEGER PRIMARY KEY NOT NULL,
id_client SERIAL NOT NULL,
first_name CHARACTER VARYING(30),
last_name CHARACTER VARYING(30),
patronymic CHARACTER VARYING(30),
discounts INTEGER CHECK (discounts > 0 ),
phone CHARACTER VARYING(30),
address VARCHAR(250)
);
CREATE TABLE accounting_of_received_calls
(
id_call INTEGER,
id_employee INTEGER REFERENCES employee_accounting (id_employee),
number_car INTEGER REFERENCES employee_vehicle_accounting (number_car),
date_time TIMESTAMP NOT NULL,
phone CHARACTER VARYING(30),
address VARCHAR(250),
destination VARCHAR(250),
CONSTRAINT aor_calls PRIMARY KEY (id_call, id_employee, number_car, destination)
);
CREATE TABLE vip_calls
(
vip_call INTEGER REFERENCES vip_customer_accounting (id_call),
received_call INTEGER REFERENCES accounting_of_received_calls (id_call)
);
CREATE TABLE rates
(
destination VARCHAR(250) PRIMARY KEY NOT NULL,
mileage SMALLINT,
price INTEGER CHECK (price > 0)
);
CREATE TABLE rate_calls
(
rate_dest VARCHAR(250) NOT NULL REFERENCES rates (destination),
calls_dest VARCHAR(250) NOT NULL REFERENCES accounting_of_received_calls (destination)
);