数据库第一次作业7.17

create table employees(
id int primary key,
name varchar(50) not null,
age int,
gender char(10) not null default "unknown",
salary float);

create table orders(
id int primary key,
name varchar(100) not null,
price float,
quantity int,
category varchar(50));

create table invoices(
number int primary key auto_increment,
order_id int,foreign key(order_id) references orders(id), 
in_date date,
total_amount float,check(total_amount >0));