sql - 递归关系SQL错误

Question

我是 SQL 的新手，但遇到了问题。我想建立一个递归关系(一个与自身相关的表)，但是当我尝试执行我的代码时出现错误。它在没有 Coordinator_Office_ID 外键的情况下工作正常。

错误是:

The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.

Create table Logistican (
  Office_ID Number(10) Constraint nb_office Not NULL,
  Worker_ID Number(15) Constraint lg_worker not null,
  Name_logistican Varchar(20),
  Room Varchar(10) constraint log_room UNIQUE,
  Coordinator_Office_ID Integer,
  Primary key (Office_ID, Worker_ID),
  Constraint work_id Foreign key (Worker_ID) References worker(worker_ID) on       delete cascade,
  Constraint lg_cord_id Foreign key (Coordinator_Office_ID) References      Logistican(Office_ID)
);

Answer 1

是的，那是因为您定义了复合主键，例如 Primary key (Office_ID, Worker_ID)，因此您的 FK 应该包括它们，否则会导致 PFD(部分功能依赖)