外键引用了无效的表

create table department(
	D_id char(9) primary key,
	D_name varchar(10) unique,
	aAddress varchar(20),
	D_num smallint,
	D_time datetime,
	MW_id char(12),
	foreign key (MW_id) references worker(W_id)
);
create table worker(
	W_id char(12) primary key,
	D_id char(9),
	W_name varchar(10) not null,
	W_sex char(2),
	W_age smallint,
	W_address varchar(50),
	D_pid char(12),
	foreign key(D_id) references department(D_id),
	foreign key(D_pid) references worker(W_id)
);

创建第一个表时，第二个表还未创建。

解决方法：https://bbs.csdn.net/topics/350248965

建议先建表，然后再添加外键完整性约束。