数据库第一次作业

 

 

 

 

 

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