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')