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)
);

Ответы (0 шт):