数据库第一次作业

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

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

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

;