编辑代码

create database test;
use test;

create table t_comp(
    comp_code varchar(50) primary key,
    comp_name varchar(50),
    comp_add varchar(50)
);
create table t_manage(
    item_code varchar(50) primary key,
    item_name varchar(50),
    spec varchar(50),
    price float,
    exp date,
    comp_code varchar(50),
    toc float,
    foreign key (comp_code) references t_comp(comp_code)
);
create table t_wh(
    wh_code varchar(50) primary key,
    wh_name varchar(50),
    wh_add varchar(50),
    admin varchar(50)
);
create table t_trans(
    wh_code varchar(50) not null,
    item_code varchar(50) not null,
    date date not null,
    time time not null,
    number float,
    type varchar(50),
    trans_p varchar(50),
    trans_comp varchar(50),
    primary key(wh_code,item_code,date,time),
    foreign key (wh_code) references t_wh(wh_code),
    foreign key (item_code) references t_manage(item_code)
);


insert into t_comp values('001','star','5B313_公司1');
insert into t_manage values('00101','goods1','A1','30','2023-8-1','001','100');
insert into t_wh values('501','store1','5B313_仓库1','alice');
insert into t_trans values('501','00101','2023-6-1','15:00:00','200','m','tom','sun');
select * from t_comp;
select * from t_manage;
select * from t_wh;
select * from t_trans;