5建供给表.sql

来自「仓库管理系统」· SQL 代码 · 共 12 行

create table goods_out(
                        depot_id varchar(5),
                        goods_id varchar(6),
                        bm_id varchar(10) ,
                        g_out_time datetime ,
                        out_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));