建供应表.sql

仓库管理系统

create table goods_in(
                        depot_id varchar(5),
                        goods_id varchar(6),
                        bm_id varchar(10) ,
                        g_In_time datetime ,
                        in_total int ,
                        do_man varchar(20),
                        foreign key (depot_id) references depot(depot_id),
                        foreign key (goods_id) references goods(goods_id),
                        foreign key (bm_id) references businessman(bm_id));