编辑代码

create database test;
use test;

create table t_comp(
    comp_code varchar(50) primary key,
    comp_name varchar(50),
    comp_add varchar(50)
);

insert into t_comp values("001","star","5B313_公司1");
select * from t_comp;

create table t_manage(
    item_code varchar(50) primary key,
    item_name varchar(50),
    spec varchar(50),
    price float,
    item_exp date,
    comp_code varchar(50),
    toc float,
    foreign key(comp_code) references t_comp(comp_code)
);
insert into t_manage values("00101","wangzai","A1",30,"2023-12-1","001",0);