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));