下雪了

【数据库的创建】万恶的数据表……

因为实验报告和数据文件严重不符,只能手动修改了,这里记录一下…..
create table employee
(
employeeNo char(8) primary key,
employeename varchar(8),
sex char(1),
birthday datetime,
address varchar(50),
telephone varchar(20),
hiredate datetime,
department varchar(30),
headship varchar(6),
salary numeric(8,2)
);

create table customer
(
customerNo char(9) primary key,
customername varchar(40),
telephone varchar(20),
address varchar(40),
zip char(6)
);

create table product
(
productNo char(9) primary key,
productName varchar(40),
productClass varchar(20),
productPrice numeric(8,2)
);

create table orderMaster
(
orderNo char(12) primary key,
customerNo char(9),
foreign key (customerNo) references customer(customerNo),
saleNo char(8),
orderdate datetime,
orderSum numeric(8,2),
invoiceNo char(10)
);

create table orderDetail
(
orderNo char(12),
productNo char(9),
quantity int,
price int,
primary key (orderNo,productNo),
foreign key (orderNo) references orderMaster(orderNo),
foreign key (productNo) references product(productNo)
);