测试数据1.sql

毕业设计作品--超市管理系统

use DB_SMS
go

--1. 员工类型
insert into TB_EMPLOYEE_TYPE values('EMT200901081613', '管理员')
insert into TB_EMPLOYEE_TYPE values('EMT200901081614', '收银员')

--2. 员工信息
insert into TB_EMPLOYEE values('EMP200901081615', 'EMT200901081613', '张三', '111', 0)
insert into TB_EMPLOYEE values('EMP200901081616', 'EMT200901081614', '李四', '111', 0)

--3. 商品类型
insert into TB_GOODS_TYPE values('GT200901081617', '饮料', 0)
insert into TB_GOODS_TYPE values('GT200901081618', '王老吉', 'GT200901081617')
insert into TB_GOODS_TYPE values('GT200901081619', '冰红茶', 'GT200901081617')
insert into TB_GOODS_TYPE values('GT20090108161711', '凳子', 0)
insert into TB_GOODS_TYPE values('GT20090108161811', '镫子', 'GT20090108161711')
insert into TB_GOODS_TYPE values('GT20090108161911', '灯子', 'GT20090108161711')
insert into TB_GOODS_TYPE values('GT20090108161812', '棋子', '0')
insert into TB_GOODS_TYPE values('GT20090108161913', '机子', 'GT20090108161812')
insert into TB_GOODS_TYPE values('GT20090108161914', '啊冰红茶', 'GT200901081619')

--4. 商品信息
insert into TB_GOODS values('GS200901081620', 'GT200901081618', '王老吉哇哈哈', 100)
insert into TB_GOODS values('GS200901081621', 'GT200901081619', '冰红茶快线', 88)

--5. 会员信息
insert into TB_MEMBER values('MEM200901081622', '我是会员', '1234567890', 100)

--6. 供货商信息
insert into TB_PROVIDER values('PRO200901081623', '饮料供货商', '刺头', '0123')

--7. 销售单信息
insert into TB_SALE_SHEET values('SAS200901081623', 'MEM200901081622', 'EMP200901081616', 280, '2009-1-8 18:20')
insert into TB_SALE_SHEET values('SAS200901081624', 'MEM200901081622', 'EMP200901081616', 1000, '2009-1-8 18:21')

--8. 销售商品信息
insert into TB_SALE_GOODS values('SAG200901081625', 'GS200901081620', 5, 'SAS200901081624')
insert into TB_SALE_GOODS values('SAG200901081626', 'GS200901081621', 3, 'SAS200901081624')

--9. 进货单信息
insert into TB_STOCK_SHEET values('STS200901081627', 'EMP200901081615', 'PRO200901081623', 0, '2009-1-8 19:00')

--10. 进货商品信息
insert into TB_STOCK_GOODS values('STG200901081625', 'STS200901081627', 'GS200901081620', 4)
insert into TB_STOCK_GOODS values('STG200901081626', 'STS200901081627', 'GS200901081621', 10)

--11. 库存信息
insert into TB_STORAGE values('STO200901081628', 'GS200901081620', 4, '2009-1-8 20:00')
insert into TB_STORAGE values('STO200901081629', 'GS200901081621', 5, '2009-1-8 20:01')

--12. 供货表
insert into TB_SUPPLY values('SUP200901081630', 'PRO200901081623', 'GT200901081618')