急！！！！列表的唯一或主键不匹配问题

来源：百度知道 编辑：UC知道 时间：2024/07/02 19:17:13
差两个表的时候
create table table_bill(
bill_id number(10) primary key,
vendor_id number(10) not null,
bill_date date not null,
bill_due_date date not null,
bill_paid_flag number(1) not null,
bill_amount number(10) not null,
foreign key(vendor_id) references table_vendor(vendor_id)
);
create sequence seq_bill_id start with 10001 increment by 1 nocycle;

drop table table_bill_item;

create table table_bill_item(
bill_id number(10) not null,
dept_id number(5) not null,
bill_item_id number(10) primary key,
bill_item_expense number(10) not null,
foreign key(dept_id) references table_dept(dept_id),
foreign key(bill_id) references table_bill(bill_id)
);
create table table_bill(
bill_id number(10) primary key,
vendor_id number(10) not null,
bill_date date not null,
bill_due_date

开始时你创造了表：create table table_bill(
bill_id number(10) primary key,
vendor_id number(10) not null,
bill_date date not null,
bill_due_date date not null,
bill_paid_flag number(1) not null,
bill_amount number(10) not null,
foreign key(vendor_id) references table_vendor(vendor_id)
);
后来你只是删除了 table_bill_item; 而没有删除table_bill，直接又创建了一个table_bill表，所以最后的table_bill_item外键不知道你的参考表是哪个，因为有两个了
drop table table_bill_item;

create table table_bill_item(
bill_id number(10) not null,
dept_id number(5) not null,
bill_item_id number(10) primary key,
bill_item_expense number(10) not null,
foreign key(dept_id) references table_dept(dept_id),
foreign key(bill_id) references table_bill(bill_id)
);

create table table_bill(
bill_id number(10) primary key,
vendor_id number(10) not null,

LS正解