使用者
Create table auser 
(
    mobile char(10) primary key,
    name char(10),
    pwd char(40),
    email text,
    addr varchar(255),
    remark text
);

商品
Create table good 
(
    gid int  primary key,
    name varchar(255),
    place varchar(255),
    num int,
    price int
);
insert into good values(0,'高麗菜','高雄',5,100);

發票
create table buy 
(
    bid int primary key,
    mobile char(10) references auser(mobile),
    tel char(10),
    addr text,
    stype char(10) 
);
insert into buy values(0,'sss','','','');

發票明細
create table detail  
(
    did int primary key,
    bid int references buy(bid),
    gid int references good(gid),
    num int,
    price int
);
insert into detail values(0,0,2,0,0);