· 10 years ago · Sep 08, 2016, 05:24 AM
1drop table if exists orders;
2
3create table orders
4( order_id int(10) not null auto_increment primary key,
5 customer_id int(50) not null,
6 employee_id int(50) not null,
7 order_date date null, -- null or not?
8 shipper_id int(50) not null,
9 FOREIGN KEY `abc1` (employee_id) references employee(employee_id),
10 FOREIGN KEY `abc2` (shipper_id) references shippers(shipper_id)
11);