数据库配置
系统功能结构图
系统数据关系图
系统用例图
创建数据库sql
use GoodsPurchase
--创建用户信息表user
create table [user]
(
userid varchar(50) primary key,
username varchar(50),
password varchar(50),
name varchar(50),
telephone varchar(20)
)
--创建水果商品信息表commodities
create table commodities
(
fruitid varchar(50) primary key,
fruitName varchar(50),
price float,
createtime datetime
)
--零售商信息表
create table retailer
(
retailerid varchar(50) primary key,
name varchar(50),
telephone varchar(50),
address varchar(100),
status int,
createtime datetime
)
--采购合同表contract
create table [contract]
(
contractid varchar(50) primary key,
barcode varchar(50),
[type] int,
accessoryid text, --零售商id
createtime datetime
)
--中间表middleTab
create table middleTab
(
middleid varchar(50) primary key,
contractid varchar(50) foreign key references [contract](contractid),
fruitid varchar(50) foreign key references commodities(fruitid),
number int
)