create database XjhDemo

go
use XjhDemo
go

--商品类别
Create table Sort
(
SortId int primary key identity(1,1),--类别Id
SortFatherId int foreign key references Sort(SortId),--FatherId父类ID
SortName varchar(30) not null --类别名称
)
go
---大类潮流女装
insert into Sort values(null,'潮流女装')
insert into Sort values(1,'女装内衣')--中类女装内衣
insert into Sort values(2,'文胸/塑型')
insert into Sort values(2,'内衣套装')
insert into Sort values(2,'女式保暖')
insert into Sort values(2,'女式内裤')
insert into Sort values(2,'睡衣/家居服')

insert into Sort values(1,'女装上装')--中类女装上装
insert into Sort values(8,'女式T恤')
insert into Sort values(8,'女式皮衣')
insert into Sort values(8,'女式针织衫/毛衣')
insert into Sort values(8,'女式大衣/风衣')
insert into Sort values(8,'女式外套/夹克')
insert into Sort values(8,'女式羽绒服')
insert into Sort values(8,'打底衫')
insert into Sort values(8,'女式马甲/ 背心')
insert into Sort values(8,'衬衫/雪纺衫')
insert into Sort values(8,'女式棉服')
insert into Sort values(8,'女式西服')

insert into Sort values(1,'女装下装/裙装')--中类女装下装/裙装
insert into Sort values(20,'礼服')
insert into Sort values(20,'女式牛仔裤')
insert into Sort values(20,'裙裤')
insert into Sort values(20,'女式休闲裤')
insert into Sort values(20,'连衣裙')
insert into Sort values(20,'半身裙')
insert into Sort values(20,'打底裤')

insert into Sort values(1,'女装搭配')--中类女装搭配
insert into Sort values(28,'单鞋')

---大类时尚男装
insert into Sort values(null,'时尚男装')
insert into Sort values(30,'男装上装')--中类男装上装
insert into Sort values(31,'男式针织衫/毛衣')
insert into Sort values(31,'男式衬衫')
insert into Sort values(31,'男式外套/夹克')
insert into Sort values(31,'男式卫衣')
insert into Sort values(31,'男式棉服')
insert into Sort values(31,'男式风衣/大衣')
insert into Sort values(31,'男式西服')
insert into Sort values(31,'男式羽绒服')
insert into Sort values(31,'男式马甲/背心')
insert into Sort values(31,'男式T恤')

insert into Sort values(30,'男装下装')--中类男装下装
insert into Sort values(42,'男式牛仔裤')
insert into Sort values(42,'男式西裤')

insert into Sort values(30,'男装内衣')--中类男装内衣
insert into Sort values(45,'男式保暖')
insert into Sort values(45,'男式睡衣/居家服')
insert into Sort values(45,'男式内裤')

---大类运动户外
insert into Sort values(null,'运动户外')
insert into Sort values(49,'运动服装')--中类运动服装
insert into Sort values(50,'冲锋衣')
insert into Sort values(50,'运动下装')
insert into Sort values(50,'运动帽')
insert into Sort values(50,'运动袜子')
insert into Sort values(50,'运动T恤/POLO衫')
insert into Sort values(50,'运动夹克/外套')
insert into Sort values(50,'运动卫衣/套头衫')
insert into Sort values(50,'运动羽绒服/棉衣')
insert into Sort values(50,'健身服装')
insert into Sort values(50,'运动套装')

insert into Sort values(49,'运动鞋')--中类运动鞋
insert into Sort values(61,'训练鞋/健身鞋')
insert into Sort values(61,'帆布鞋')
insert into Sort values(61,'运动沙滩鞋/拖鞋')
insert into Sort values(61,'登山鞋')
insert into Sort values(61,'其他运动鞋')
insert into Sort values(61,'网球鞋')
insert into Sort values(61,'篮球鞋')
insert into Sort values(61,'足球鞋')
insert into Sort values(61,'板鞋/休闲鞋')
insert into Sort values(61,'跑步鞋')

insert into Sort values(49,'户外用品')--中类户外用品
insert into Sort values(72,'游泳用具')
insert into Sort values(72,'户外配件')
insert into Sort values(72,'体育用品')
insert into Sort values(72,'户外背包')
insert into Sort values(72,'户外工具')
insert into Sort values(72,'旅游用品')

--大类箱包手袋
insert into Sort values(null,'箱包手袋')
insert into Sort values(79,'潮流女包')--中类潮流女包
insert into Sort values(80,'女式双肩包')
insert into Sort values(80,'女式手提包')
insert into Sort values(80,'女式斜挎包')
insert into Sort values(80,'女式钱包')
insert into Sort values(80,'女式手包')
insert into Sort values(80,'女式单肩包')

insert into Sort values(79,'时尚男包')--中类时尚男包
insert into Sort values(87,'男式斜挎包')
insert into Sort values(87,'男式双肩包')
insert into Sort values(87,'男式手提包')
insert into Sort values(87,'男式单肩包')
insert into Sort values(87,'男式手包')
insert into Sort values(87,'商务包/公文包')
insert into Sort values(87,'男式钱包')

insert into Sort values(79,'功能箱包')--中类功能箱包
insert into Sort values(95,'运动休闲包')
insert into Sort values(95,'拉杆箱')
insert into Sort values(95,'旅行包')

--大类家居家纺
insert into Sort values(null,'家居家纺')
insert into Sort values(99,'家纺')--中类家纺
insert into Sort values(100,'蚊帐/凉席')
insert into Sort values(100,'床垫/床褥')
insert into Sort values(100,'抱枕坐垫')
insert into Sort values(100,'拖鞋')
insert into Sort values(100,'毛巾家纺')
insert into Sort values(100,'床品件套')
insert into Sort values(100,'家居服')
insert into Sort values(100,'被子')
insert into Sort values(100,'毛巾被/毯')
insert into Sort values(100,'枕芯枕套')

insert into Sort values(99,'生活日用')-- 中类生活日用
insert into Sort values(111,'清洁护理')
insert into Sort values(111,'拖 鞋')
insert into Sort values(111,'茶具/杯具')
insert into Sort values(111,'保鲜盒')
insert into Sort values(111,'婴幼儿用品')
insert into Sort values(111,'居家创意')
insert into Sort values(111,'炊具刀具')
insert into Sort values(111,'家装软饰')
insert into Sort values(111,'浴室用品')
insert into Sort values(111,'收纳整理')
insert into Sort values(111,'洗晒用品')
insert into Sort values(111,'桌面摆设')
insert into Sort values(111,'卫浴配件')
insert into Sort values(111,'厨房布艺')

--大类美容妆品
insert into Sort values(null,'美容妆品')
insert into Sort values(126,'面部护理')--中类面部护理
insert into Sort values(127,'面部护理套装')
insert into Sort values(127,'眼膜/眼霜')
insert into Sort values(127,'眼部精华/乳液')
insert into Sort values(127,'卸妆油/乳/液')
insert into Sort values(127,'面膜面贴')
insert into Sort values(127,'爽肤水')
insert into Sort values(127,'洁面乳')
insert into Sort values(127,'面乳面霜')
insert into Sort values(127,'精华露')

insert into Sort values(126,'身体洗护')--中类身体洗护
insert into Sort values(137,'牙膏/牙粉/漱口水')
insert into Sort values(137,'护理油')
insert into Sort values(137,'口罩')
insert into Sort values(137,'卫生护垫')
insert into Sort values(137,'身体洗护套装')
insert into Sort values(137,'防晒隔离')
insert into Sort values(137,'冰/暖宝贴')
insert into Sort values(137,'沐浴露')
insert into Sort values(137,'染发/造型')
insert into Sort values(137,'洗发护发')
insert into Sort values(137,'牙刷/牙线')
insert into Sort values(137,'手工/香皂')
insert into Sort values(137,'润肤乳/霜')

insert into Sort values(126,'香氛彩妆')--中类香氛彩妆
insert into Sort values(151,'粉饼')
insert into Sort values(151,'中性香水/香氛')
insert into Sort values(151,'香水/香氛套装')
insert into Sort values(151,'唇膏唇彩')
insert into Sort values(151,'粉底/遮瑕')
insert into Sort values(151,'眼影/眼线')
insert into Sort values(151,'睫毛膏')

--大类国际名品
insert into Sort values(null,'国际名品')
insert into Sort values(159,'奢侈名包')--中类奢侈名包
insert into Sort values(160,'钱包')
insert into Sort values(160,'男包')
insert into Sort values(160,'女包')

insert into Sort values(159,'数码家电')--中类数码家电
insert into Sort values(164,'数码配件')
insert into Sort values(164,'保健器材')
insert into Sort values(164,'3C小家电')

insert into Sort values(159,'时尚臻饰')--中类时尚臻饰
insert into Sort values(168,'围巾/丝巾')
insert into Sort values(168,'钥匙扣')
insert into Sort values(168,'高级雨具')
insert into Sort values(168,'链饰/耳饰')
insert into Sort values(168,'手套')
insert into Sort values(168,'帽子')
insert into Sort values(168,'太阳镜')
insert into Sort values(168,'皮带')
insert into Sort values(168,'领带')
insert into Sort values(168,'腕表')
insert into Sort values(168,'名笔')
insert into Sort values(168,'戒指')

--大类食品饮料
insert into Sort values(null,'食品饮料')
insert into Sort values(181,'休闲零食')--休闲零食
insert into Sort values(182,'膨化食品')
insert into Sort values(182,'糕点/饼干/小食')

insert into Sort values(181,'酒类饮品')--中类酒类饮品
insert into Sort values(185,'白酒')
insert into Sort values(185,'果酒')
insert into Sort values(185,'冰酒')
insert into Sort values(185,'果汁')
insert into Sort values(185,'红酒/葡萄酒')

insert into Sort values(181,'粮油干货')--中类
insert into Sort values(191,'食用油/橄榄油')
insert into Sort values(191,'营养保健')

 

--商品品牌 3
Create table Brand
(
BrandId int primary key identity(1,1),--品牌ID
BrandName varchar(30) not null,--品牌名称
SortId int foreign key references Sort(SortId),--类别外键
)
go
--潮流女装
--女装内衣>文胸/塑型

insert into Brand values('shirley of hollywood',3)
insert into Brand values('古今',3)
insert into Brand values('奇丽尔',3)
insert into Brand values('思薇雅',3)
insert into Brand values('曼黛玛琏',3)
insert into Brand values('欣姿芳',3)
insert into Brand values('汎迷丝',3)
insert into Brand values('罗丝美',3)
--女装内衣>内衣套装
insert into Brand values('罗丝美',4)
--女装内衣>女式保暖
insert into Brand values('大朴',5)
insert into Brand values('思薇雅',5)
insert into Brand values('舒雅',5)
--女装内衣>女式内裤
insert into Brand values('shirley of hollywood',6)
insert into Brand values('古今',6)
insert into Brand values('大朴',6)
insert into Brand values('欣姿芳',6)
insert into Brand values('汎迷丝',6)
insert into Brand values('罗丝美',6)
--女装内衣>睡衣/家居服
insert into Brand values('伊丝芬',7)
insert into Brand values('古今',7)
insert into Brand values('思薇雅',7)
insert into Brand values('汎迷丝',7)
insert into Brand values('罗丝美',7)
insert into Brand values('英第爱纳',7)
--女装上装>女式T恤
insert into Brand values('3RD ROOM',9)
insert into Brand values('Bear-Two',9)
insert into Brand values('COCODEAL',9)
insert into Brand values('Emely Sweetie',9)
insert into Brand values('GOZO',9)
insert into Brand values('MOS Mind Bridge',9)
insert into Brand values('安魅力',9)
insert into Brand values('欧莎莉',9)
insert into Brand values('法妮',9)
insert into Brand values('箱子',9)
--女装上装>女式皮衣
insert into Brand values('Emely Sweetie',10)
insert into Brand values('Mind Bridge',10)
insert into Brand values('双星宝贝',10)
insert into Brand values('箱子',10)
--女装上装>女式针织衫/毛衣
insert into Brand values('Bear-Two',11)
insert into Brand values('COCODEAL',11)
insert into Brand values('Emely Sweetie',11)
insert into Brand values('ForeverNew',11)
insert into Brand values('Klein Plus',11)
insert into Brand values('Mikibana',11)
insert into Brand values('Mind Bridge',11)
insert into Brand values('珂迪兹',11)
insert into Brand values('欧莎莉',11)
--女装上装>女式大衣/风衣
insert into Brand values('3RD ROOM',12)
insert into Brand values('Bear-Two',12)
insert into Brand values('Emely Sweetie',12)
insert into Brand values('ForeverNew',12)
insert into Brand values('GOZO',12)
insert into Brand values('Klein Plus',12)
insert into Brand values('Loved Rose',12)
insert into Brand values('Mikibana',12)
insert into Brand values('Mind Bridge',12)
insert into Brand values('双星宝贝',12)
--女装上装>女式外套/夹克
insert into Brand values('3RD ROOM',13)
insert into Brand values('Bear-Two',13)
insert into Brand values('COCODEAL',13)
insert into Brand values('ForeverNew',13)
insert into Brand values('GOZO',13)
insert into Brand values('Lachapelle Sport',13)
insert into Brand values('MOS',13)
insert into Brand values('Mind Bridge',13)
insert into Brand values('UGIZ',13)
--女装上装>女式羽绒服
insert into Brand values('COCODEAL',14)
insert into Brand values('Loved Rose',14)
insert into Brand values('Mind Bridge',14)
insert into Brand values('箱子',14)
--女装上装>打底衫
insert into Brand values('Mikibana',15)
insert into Brand values('汎迷丝',15)
insert into Brand values('纳薇',15)
insert into Brand values('舒朗',15)
insert into Brand values('英第爱纳',15)
--女装上装>女式马甲/ 背心
insert into Brand values('安魅力',16)
insert into Brand values('龙笛',16)
insert into Brand values('MLB',16)
insert into Brand values('碧可',16)
--女装上装>衬衫/雪纺衫
insert into Brand values('Emely Sweetie',17)
insert into Brand values('Mind Bridge',17)
insert into Brand values('COCODEAL',17)
insert into Brand values('Emely Sweetie',17)
--女装上装>女式棉服
insert into Brand values('Mikibana',18)
insert into Brand values('Mind Bridge ',18)
insert into Brand values('佳可',18)
insert into Brand values('双星宝贝',18)
insert into Brand values('箱子',18)
insert into Brand values('米娜',18)
insert into Brand values('艾珂黛米',18)
insert into Brand values('龙笛',18)
--女装上装>女式西服
insert into Brand values('Lachapelle Sport',19)
insert into Brand values('Mikibana',19)
insert into Brand values('埃迪拉',19)
insert into Brand values('安魅力',19)
insert into Brand values('纳薇',19)
insert into Brand values('艾珂黛米',19)
--女装下装/裙装>礼服
insert into Brand values('Emely Sweetie',21)
insert into Brand values('衣爵士特',21)
insert into Brand values('龙笛',21)
--女装下装/裙装>女式牛仔裤
insert into Brand values('箱子',22)
insert into Brand values('碧可',22)
insert into Brand values('佳可',22)
insert into Brand values('Mind Bridge',22)
insert into Brand values('安魅力',22)
insert into Brand values('米娜',22)
--女装下装/裙装>裙裤
insert into Brand values('埃迪拉',23)
insert into Brand values('欧莎莉',23)
insert into Brand values('Emely Sweetie',23)
insert into Brand values('Bear-Two',23)
insert into Brand values('衣索',23)
insert into Brand values('米娜',23)
--女装下装/裙装>女式休闲裤
insert into Brand values('Mind Bridge',24)
insert into Brand values('安魅力',24)
insert into Brand values('Lachapelle Sport',24)
insert into Brand values('箱子',24)
insert into Brand values('欧莎莉',24)
insert into Brand values('特芙娜',24)
--女装下装/裙装>连衣裙
insert into Brand values('Mind Bridge',25)
insert into Brand values('3RD ROOM',25)
insert into Brand values('埃迪拉',25)
insert into Brand values('拉夏贝尔',25)
insert into Brand values('安魅力',25)
insert into Brand values('欧莎莉',25)
--女装下装/裙装>半身裙
insert into Brand values('埃迪拉',26)
insert into Brand values('MOS',26)
insert into Brand values('安魅力',26)
insert into Brand values('ForeverNew',26)
insert into Brand values('COCODEAL',26)
insert into Brand values('艾珂黛米',26)
insert into Brand values('Loved Rose',26)
--女装下装/裙装>打底裤
insert into Brand values('MOS',27)
insert into Brand values('Mikibana',27)
insert into Brand values('odbo',27)
insert into Brand values('双星宝贝',27)
insert into Brand values('欧莎莉',27)
insert into Brand values('米娜',27)
insert into Brand values('纳薇',27)
insert into Brand values('雪儿',27)
--女装搭配>单鞋
insert into Brand values('夏伊朵',29)
go

--时尚男装
--男装上装>男式针织衫/毛衣
insert into Brand values('马克华菲',32)
insert into Brand values('克莱蒙梭',32)
insert into Brand values('SHAKE',32)
insert into Brand values('TONY JEANS',32)
insert into Brand values('威斯康尼',32)
--男装上装>男式衬衫
insert into Brand values('LLSibling',33)
insert into Brand values('JAMES EARL',33)
insert into Brand values('马克华菲',33)
insert into Brand values('By Creations',33)
--男装上装>男式外套/夹克
insert into Brand values('LLSibling',34)
insert into Brand values('马克华菲',34)
insert into Brand values('TONY JEANS',34)
insert into Brand values('克莱蒙梭',34)
insert into Brand values('TONY WEAR',34)
insert into Brand values('camel',34)
insert into Brand values('威斯康尼',34)
--男装上装>男式卫衣
insert into Brand values('暇步士',35)
--男装上装>男式棉服
insert into Brand values('SHAKE',36)
insert into Brand values('克莱蒙梭',36)
--男装上装>男式风衣/大衣
insert into Brand values('TONY JEANS',37)
insert into Brand values('克莱蒙梭',37)
insert into Brand values('威斯康尼',37)
insert into Brand values('马克华菲',37)
--装上装>男式西服
insert into Brand values('By Creations',38)
insert into Brand values('LLSibling',38)
insert into Brand values('TONY WEAR',38)
insert into Brand values('克莱蒙梭',38)
insert into Brand values('威斯康尼',38)
insert into Brand values('柏朗亚高',38)
insert into Brand values('马克华菲',38)
--男装上装>男式羽绒服
insert into Brand values('TONY JEANS',39)
insert into Brand values('克莱蒙梭',39)
insert into Brand values('威斯康尼',39)
insert into Brand values('帕蒂索',39)
insert into Brand values('暇步士',39)
insert into Brand values('耐克',39)
insert into Brand values('阿迪达斯',39)
insert into Brand values('马克华菲',39)
--男装上装>男式马甲/背心
insert into Brand values('SHAKE',40)
insert into Brand values('camel',40)

--男装上装>男式T恤
insert into Brand values('LLSibling',41)
insert into Brand values('TONY WEAR',41)
insert into Brand values('威斯康尼',41)
insert into Brand values('柏朗亚高',41)
insert into Brand values('马克华菲',41)
insert into Brand values('马基堡',41)

--男装下装>男式牛仔裤
insert into Brand values('LLSibling',43)
insert into Brand values('SHAKE',43)
insert into Brand values('TONY JEANS',43)
insert into Brand values('camel',43)
insert into Brand values('暇步士',43)
insert into Brand values('马克华菲',43)
--男装下装>男式西裤
insert into Brand values('马克华菲',44)
--男装内衣>男式保暖
insert into Brand values('大朴',46)
insert into Brand values('莱舍万',46)
--男装内衣>男式睡衣/居家服
insert into Brand values('英第爱纳',47)
--男装内衣>男式内裤
insert into Brand values('大朴',48)
insert into Brand values('莱舍万',48)

--运动户外
--运动服装>冲锋衣
insert into Brand values('NORTHLAND',51)
insert into Brand values('乐途',51)
--运动服装>运动下装
insert into Brand values('MLB',52)
insert into Brand values('happy tee',52)
insert into Brand values('乐途',52)
insert into Brand values('克郎托天',52)
insert into Brand values('彪马',52)
insert into Brand values('耐克',52)
insert into Brand values('阿迪达斯',52)
--运动服装>运动帽
insert into Brand values('MLB',53)
insert into Brand values('耐克',53)
--运动服装>运动袜子
insert into Brand values('MLB',54)
insert into Brand values('adidas kids',54)
insert into Brand values('阿迪达斯',54)
--运动服装>运动T恤/POLO衫
insert into Brand values('MLB',55)
insert into Brand values('克郎托天',55)
insert into Brand values('彪马',55)
insert into Brand values('耐克',55)
insert into Brand values('阿迪达斯',55)
--运动服装>运动夹克/外套
insert into Brand values('MLB',56)
insert into Brand values('happy tee',56)
insert into Brand values('乐途',56)
insert into Brand values('日高',56)
insert into Brand values('李宁',56)
insert into Brand values('耐克',56)
insert into Brand values('阿迪达斯',56)
--运动服装>运动卫衣/套头衫
insert into Brand values('MLB',57)
insert into Brand values('happy tee',57)
insert into Brand values('乐途',57)
insert into Brand values('李宁',57)
insert into Brand values('耐克',57)
insert into Brand values('阿迪达斯',57)
--运动服装>运动羽绒服/棉衣
insert into Brand values('耐克',58)
insert into Brand values('阿迪达斯',58)
--运动服装>健身服装
insert into Brand values('touch aero',59)
--运动服装>运动套装
insert into Brand values('MLB',60)

--运动鞋>训练鞋/健身鞋
insert into Brand values('adidas kids',62)
insert into Brand values('耐克',62)
insert into Brand values('阿迪达斯',62)
--运动鞋>帆布鞋
insert into Brand values('匡威',63)
insert into Brand values('范斯',63)
--运动鞋>运动沙滩鞋/拖鞋
insert into Brand values('Crocs',64)
insert into Brand values('MLB',64)
insert into Brand values('彪马',64)
insert into Brand values('耐克',64)
--运动鞋>登山鞋
insert into Brand values('日高',65)
--运动鞋>其他运动鞋
insert into Brand values('Crocs',66)
insert into Brand values('adidas kids',66)
insert into Brand values('耐克',66)
insert into Brand values('阿迪达斯',66)
--运动鞋>网球鞋
insert into Brand values('阿迪达斯',67)
--运动鞋>篮球鞋
insert into Brand values('李宁',68)
insert into Brand values('耐克',68)
insert into Brand values('阿迪达斯',68)
--运动鞋>足球鞋
insert into Brand values('adidas kids',69)
insert into Brand values('耐克',69)
insert into Brand values('阿迪达斯',69)
--运动鞋>板鞋/休闲鞋
insert into Brand values('Crocs',70)
insert into Brand values('Lecoq',70)
insert into Brand values('SKECHERS',70)
insert into Brand values('匡威',70)
insert into Brand values('新百伦',70)
insert into Brand values('耐克',70)
insert into Brand values('范斯',70)
insert into Brand values('阿迪达斯',70)
--运动鞋>跑步鞋
insert into Brand values('SKECHERS',71)
insert into Brand values('adidas kids',71)
insert into Brand values('新百伦',71)
insert into Brand values('耐克',71)
insert into Brand values('阿迪达斯',71)

--户外用品>游泳用具
insert into Brand values('洲克',73)
insert into Brand values('洲克',73)
--户外用品>户外配件
insert into Brand values('克郎托天',74)
insert into Brand values('狼爪',74)
insert into Brand values('耐克',74)
--户外用品>体育用品
insert into Brand values('LP',75)
insert into Brand values('凯胜',75)
insert into Brand values('李宁',75)
insert into Brand values('红双喜',75)
insert into Brand values('耐克',75)
--户外用品>户外背包
insert into Brand values('JANSPORT',76)
insert into Brand values('日高',76)
insert into Brand values('李宁',76)
insert into Brand values('狼爪',76)
insert into Brand values('耐克',76)
insert into Brand values('阿迪达斯',76)
--户外用品>户外工具
insert into Brand values('希格',77)
--户外用品>旅游用品

 

-- 大类箱包手袋
-- 潮流女包>女式双肩包
insert into Brand values('Fancy',81)
insert into Brand values('GIPURI',81)
insert into Brand values('GUESS',81)
insert into Brand values('哥伦比亚',81)
insert into Brand values('新秀丽',81)
insert into Brand values('泰格斯',81)
--潮流女包>女式手提包
insert into Brand values('Fancy',82)
insert into Brand values('GUESS',82)
insert into Brand values('LOVCAT',82)
insert into Brand values('Rex',82)
insert into Brand values('木村井泓',82)
insert into Brand values('法赛纳',82)
insert into Brand values('泰格斯',82)
--潮流女包>女式斜挎包
insert into Brand values('Fancy',83)
insert into Brand values('GUESS',83)
insert into Brand values('LOVCAT',83)
--潮流女包>女式钱包
insert into Brand values('ELLE',84)
insert into Brand values('Fancy',84)
insert into Brand values('GUESS',84)
insert into Brand values('LOVCAT',84)
insert into Brand values('木村井泓',84)
--潮流女包>女式手包
insert into Brand values('Fancy',85)
insert into Brand values('LOVCAT',85)
insert into Brand values('法赛纳',85)
--潮流女包>女式单肩包
insert into Brand values('ELLE',86)
insert into Brand values('Fancy',86)
insert into Brand values('GUESS',86)
insert into Brand values('K-3',86)
insert into Brand values('LOVCAT',86)
insert into Brand values('Rex',86)
insert into Brand values('泰格斯',86)
--时尚男包>男式斜挎包
insert into Brand values('By Creations',88)
insert into Brand values('外交官',88)
insert into Brand values('希伯莱',88)
insert into Brand values('新秀丽',88)
insert into Brand values('泰格斯',88)
--时尚男包>男式双肩包
insert into Brand values('K-3',89)
insert into Brand values('哥伦比亚',89)
insert into Brand values('外交官',89)
insert into Brand values('新秀丽',89)
--时尚男包>男式手提包
insert into Brand values('AEEIKO',90)
insert into Brand values('By Creations',90)
insert into Brand values('外交官',90)
insert into Brand values('新秀丽',90)
insert into Brand values('轻旅行',90)
--时尚男包>男式单肩包
insert into Brand values('AEEIKO',91)
insert into Brand values('By Creations',91)
insert into Brand values('新秀丽',91)
--时尚男包>男式手包
insert into Brand values('AEEIKO',92)
--时尚男包>商务包/公文包
insert into Brand values('AEEIKO',93)
insert into Brand values('By Creations',93)
insert into Brand values('新秀丽',93)
insert into Brand values('皇冠',93)
insert into Brand values('铁塔',93)
--时尚男包>男式钱包
insert into Brand values('AEEIKO',94)
insert into Brand values('希伯莱',94)

--功能箱包>运动休闲包
insert into Brand values('SWISSWIN',96)
insert into Brand values('哥伦比亚',96)
insert into Brand values('外交官',96)
insert into Brand values('新秀丽',96)
insert into Brand values('轻旅行',96)
insert into Brand values('耐克',96)
insert into Brand values('木村井泓',96)
--功能箱包>拉杆箱
insert into Brand values('Esprit',97)
insert into Brand values('GUESS',97)
insert into Brand values('SWISSWIN',97)
insert into Brand values('外交官',97)
insert into Brand values('新秀丽',97)
insert into Brand values('皇冠',97)
insert into Brand values('美国海马',97)
insert into Brand values('雅士',97)
--功能箱包>旅行包
insert into Brand values('Esprit',98)
insert into Brand values('NORTHLAND',98)
insert into Brand values('SWISSWIN',98)
insert into Brand values('外交官',98)
insert into Brand values('威戈',98)
insert into Brand values('轻旅行',98)

--大类家居家纺
--家纺>家居服
insert into Brand values('蔻姿',101)
insert into Brand values('蔻姿宝贝',101)
--家纺>床垫/床褥
insert into Brand values('富丽真金',102)
insert into Brand values('蔻姿',102)
--家纺>抱枕坐垫
insert into Brand values('TEMPUR',103)
insert into Brand values('巴芙洛',103)
insert into Brand values('蔻姿家居',103)
--家纺>拖鞋
insert into Brand values('MLB',104)
insert into Brand values('巴芙洛',104)
insert into Brand values('蔻姿家居',104)
--家纺>毛巾家纺
insert into Brand values('MLB',105)
insert into Brand values('优雅主妇',105)
insert into Brand values('内野',105)
insert into Brand values('大朴',105)
insert into Brand values('荳怡坊',105)
insert into Brand values('蔻姿宝贝',105)
insert into Brand values('蔻姿家居',105)
--家纺>床品件套
insert into Brand values('因为有你',106)
insert into Brand values('大朴',106)
insert into Brand values('富丽真金',106)
insert into Brand values('荳怡坊',106)
insert into Brand values('蓝丝',106)
insert into Brand values('蔻姿',106)
insert into Brand values('贵姿',106)
insert into Brand values('馨亭',106)
--家纺>家居服
insert into Brand values('MLB',107)
insert into Brand values('大朴',107)
--家纺>被子
insert into Brand values('大朴',108)
insert into Brand values('富丽真金',108)
insert into Brand values('蔻姿',108)
--家纺>毛巾被/毯
insert into Brand values('因为有你',109)
insert into Brand values('巴芙洛',109)
insert into Brand values('荳怡坊',109)
insert into Brand values('蓝丝',109)
--家纺>枕芯枕套
insert into Brand values('OLIVIER',110)
insert into Brand values('TEMPUR',110)
insert into Brand values('因为有你',110)
insert into Brand values('大朴',110)
insert into Brand values('富丽真金',110)
insert into Brand values('荳怡坊',110)
insert into Brand values('贵姿',110)
insert into Brand values('馨亭',110)

--生活日用>清洁护理
insert into Brand values('寿全斋',112)
insert into Brand values('张小泉',112)
insert into Brand values('得宝',112)
--生活日用>拖 鞋
insert into Brand values('巴芙洛',113)
insert into Brand values('莫老伯',113)
insert into Brand values('蔻姿',113)
--生活日用>茶具/杯具
insert into Brand values('hello bebe',114)
insert into Brand values('hello kitty',114)
insert into Brand values('乐扣乐扣',114)
insert into Brand values('优雅主妇',114)
insert into Brand values('张小泉',114)
insert into Brand values('膳魔师',114)
insert into Brand values('蔻姿',114)
insert into Brand values('虎牌',114)
--生活日用>保鲜盒
insert into Brand values('hello kitty',115)
insert into Brand values('乐扣乐扣',115)
--生活日用>婴幼儿用品
insert into Brand values('hello bebe',116)
insert into Brand values('hello kitty',116)
--生活日用>居家创意
insert into Brand values('EVEREARTH',117)
insert into Brand values('Maxim',117)
insert into Brand values('优雅主妇',117)
insert into Brand values('大朴',117)
insert into Brand values('愤怒的小鸟',117)
--生活日用>炊具刀具
insert into Brand values('WOLL',118)
insert into Brand values('库仑',118)
insert into Brand values('库格',118)
insert into Brand values('菲姐',118)
--生活日用>家装软饰
insert into Brand values('Coway',119)
insert into Brand values('森霖',119)
insert into Brand values('蔻姿',119)
insert into Brand values('蔻姿家居',119)
--生活日用>浴室用品
insert into Brand values('优雅主妇',120)
--生活日用>收纳整理
insert into Brand values('MLB',121)
insert into Brand values('优雅主妇',121)
insert into Brand values('巴芙洛',121)
insert into Brand values('蔻姿家居',121)
--生活日用>洗晒用品
insert into Brand values('优雅主妇',122)
--生活日用>桌面摆设
insert into Brand values('优雅主妇',123)
insert into Brand values('蔻姿',123)
--生活日用>卫浴配件
insert into Brand values('优雅主妇',124)
--生活日用>厨房布艺
insert into Brand values('优雅主妇',125)
insert into Brand values('巴芙洛',125)
insert into Brand values('张小泉',125)

--大类美容妆品
--面部护理>面部护理套装
insert into Brand values('SKII',128)
insert into Brand values('佰草集',128)
insert into Brand values('宠爱之名',128)
insert into Brand values('慧娜',128)
insert into Brand values('海皙蓝',128)
insert into Brand values('秀雅韩',128)
insert into Brand values('资生堂',128)
--面部护理>眼膜/眼霜
insert into Brand values('康绮墨丽',129)
insert into Brand values('朵露曼',129)
--面部护理>眼部精华/乳液
insert into Brand values('佰草集',130)
insert into Brand values('兰蔻',130)
insert into Brand values('曼丽妃丝柔',130)
insert into Brand values('海皙蓝',130)
insert into Brand values('高丝',130)
--面部护理>卸妆油/乳/液
insert into Brand values('兰蔻',131)
insert into Brand values('慧娜',131)
insert into Brand values('曼丽妃丝柔',131)
insert into Brand values('海皙蓝',131)
insert into Brand values('资生堂',131)
--面部护理>面膜面贴
insert into Brand values('佰草集',132)
insert into Brand values('兰蔻',132)
insert into Brand values('奥罗黎',132)
insert into Brand values('曼丽妃丝柔',132)
insert into Brand values('朵露曼',132)
insert into Brand values('水理肌',132)
insert into Brand values('海皙蓝',132)
insert into Brand values('雪肤魅',132)
--面部护理>爽肤水
insert into Brand values('兰蔻',133)
insert into Brand values('康绮墨丽',133)
insert into Brand values('曼丽妃丝柔',133)
insert into Brand values('秀雅韩',133)
insert into Brand values('朵露曼',133)
insert into Brand values('蔻瑞哲',133)
insert into Brand values('悦木之源',133)
--面部护理>洁面乳
insert into Brand values('资生堂',134)
insert into Brand values('康绮墨丽',134)
insert into Brand values('海皙蓝',134)
insert into Brand values('高丝',134)
insert into Brand values('玉兰油',134)
insert into Brand values('兰蔻',134)
insert into Brand values('佰草集',134)
--面部护理>面乳面霜
insert into Brand values('曼丽妃丝柔',135)
insert into Brand values('海皙蓝',135)
insert into Brand values('秀雅韩',135)
insert into Brand values('蔻瑞哲',135)
insert into Brand values('康绮墨丽',135)
insert into Brand values('兰蔻',135)
--面部护理>精华露
insert into Brand values('曼丽妃丝柔',136)
insert into Brand values('高丝',136)
insert into Brand values('海皙蓝',136)
insert into Brand values('秀雅韩',136)
insert into Brand values('雅诗兰黛',136)
insert into Brand values('兰蔻',136)
insert into Brand values('佰草集',136)

--身体洗护>牙膏/牙粉/漱口水
insert into Brand values('佳洁士',138)
insert into Brand values('皓乐齿',138)
insert into Brand values('美加净',138)
--身体洗护>护理油
insert into Brand values('朵露曼',139)
--身体洗护>口罩
insert into Brand values('小林',140)
--身体洗护>卫生护垫
insert into Brand values('护舒宝',141)
--身体洗护>身体洗护套装
insert into Brand values('东方宝石',142)
insert into Brand values('康绮墨丽',142)
insert into Brand values('欧舒丹',142)
insert into Brand values('资生堂',142)
--身体洗护>防晒隔离
insert into Brand values('佰草集',143)
insert into Brand values('兰芝',143)
insert into Brand values('兰蔻',143)
insert into Brand values('康绮墨丽',143)
--身体洗护>冰/暖宝贴
insert into Brand values('小林',144)

-- 身体洗护>沐浴露
insert into Brand values('东方宝石',145)
insert into Brand values('康绮墨丽',145)
insert into Brand values('欧舒丹',145)
insert into Brand values('舒肤佳',145)
insert into Brand values('资生堂',145)
--身体洗护>染发/造型
insert into Brand values('杰士派',146)
--身体洗护>洗发护发
insert into Brand values('康绮墨丽',147)
insert into Brand values('沙宣',147)
insert into Brand values('海飞丝',147)
insert into Brand values('潘婷',147)
insert into Brand values('资生堂',147)
insert into Brand values('飘柔',147)
--身体洗护>牙刷/牙线
insert into Brand values('佳洁士',148)
insert into Brand values('小林',148)
insert into Brand values('皓乐齿',148)
insert into Brand values('美加净',148)
--身体洗护>手工/香皂
insert into Brand values('康绮墨丽',149)
insert into Brand values('春风华佗',149)
insert into Brand values('舒肤佳',149)
--身体洗护>润肤乳/霜
insert into Brand values('兰蔻',150)
insert into Brand values('康绮墨丽',150)
insert into Brand values('欧舒丹',150)
insert into Brand values('资生堂',150)

--香氛彩妆>粉饼
insert into Brand values('曼丽妃丝柔',152)
--香氛彩妆>中性香水/香氛
insert into Brand values('Calvin Klein',153)
insert into Brand values('爱马仕',153)
--香氛彩妆>香水/香氛套装
insert into Brand values('Calvin Klein',154)
insert into Brand values('SALVATORE FERRAGAMO',154)
--香氛彩妆>唇膏唇彩
insert into Brand values('慧娜',155)
insert into Brand values('海皙蓝',155)
insert into Brand values('资生堂',155)
--香氛彩妆>粉底/遮瑕
insert into Brand values('曼丽妃丝柔',156)
insert into Brand values('海皙蓝',156)
--香氛彩妆>眼影/眼线
insert into Brand values('海皙蓝',157)
--香氛彩妆>睫毛膏
insert into Brand values('海皙蓝',158)

--大类国际名品
--奢侈名包>钱包
insert into Brand values('CHOLE',161)
insert into Brand values('COACH',161)
insert into Brand values('古驰',161)
insert into Brand values('巴宝莉',161)
insert into Brand values('马基堡',161)
--奢侈名包>男包
insert into Brand values('D&G',162)
insert into Brand values('埃麦尼吉尔多·杰尼亚',162)
insert into Brand values('安普里奥 阿玛尼',162)
insert into Brand values('巴宝莉',162)
insert into Brand values('杰尼亚',162)
--奢侈名包>女包
insert into Brand values('COACH',163)
insert into Brand values('DIESEL',163)
insert into Brand values('folli follie',163)
insert into Brand values('巴宝莉',163)
insert into Brand values('普拉达',163)

--数码家电>数码配件
insert into Brand values('arevo',165)
insert into Brand values('托卡诺',165)
insert into Brand values('泰格斯',165)
--数码家电>保健器材
insert into Brand values('傲胜',166)
--数码家电>3C小家电
insert into Brand values('三星',167)
insert into Brand values('松下',167)
insert into Brand values('耐克',167)
insert into Brand values('苹果',167)
insert into Brand values('荣事达',167)
insert into Brand values('西部数据',167)
insert into Brand values('金士顿',167)
insert into Brand values('飞利浦',167)

--中类时尚臻饰>围巾/丝巾
insert into Brand values('斯倍秀',169)
insert into Brand values('SKT',169)
--时尚臻饰>钥匙扣
insert into Brand values('COACH',170)
--时尚臻饰>高级雨具
insert into Brand values('富尔顿',171)
insert into Brand values('斯倍秀',171)
--时尚臻饰>链饰/耳饰
insert into Brand values('JCREW',172)
insert into Brand values('folli follie',172)
insert into Brand values('肯曼托',172)
--时尚臻饰>手套
insert into Brand values('By Creations',173)
insert into Brand values('SKT',173)
--时尚臻饰>帽子
insert into Brand values('斯倍秀',174)
--时尚臻饰>太阳镜
insert into Brand values('CHOLE',175)
insert into Brand values('COACH',175)
insert into Brand values('D&G',175)
insert into Brand values('SKT',175)
insert into Brand values('TOM FORD',175)
insert into Brand values('普拉达',175)
insert into Brand values('雷朋',175)
--时尚臻饰>皮带
insert into Brand values('AEEIKO',176)
insert into Brand values('By Creations',176)
insert into Brand values('D&G',176)
insert into Brand values('GAS',176)
insert into Brand values('古驰',176)
--时尚臻饰>领带
insert into Brand values('By Creations',177)
insert into Brand values('柏朗亚高',177)
--时尚臻饰>腕表
insert into Brand values('folli follie',178)
insert into Brand values('安普里奥 阿玛尼',178)
insert into Brand values('巴宝莉',178)
--时尚臻饰>名笔
insert into Brand values('梦特娇',179)
insert into Brand values('派克',179)
insert into Brand values('花花公子',179)
--时尚臻饰>戒指
insert into Brand values('乔易·塞纳多',180)
insert into Brand values('乔治 瑞维拉',180)
insert into Brand values('肯曼托',180)
-- 大类 食品饮料
-- 休闲零食>膨化食品
insert into Brand values('张君雅',183)
--休闲零食>糕点/饼干/小食
insert into Brand values('老太阳堂',184)
insert into Brand values('蜜兰诺',184)
insert into Brand values('凯年',184)
insert into Brand values('JKOS',184)

--中类酒类饮品>白酒
insert into Brand values('习将军',186)
--酒类饮品>果酒
insert into Brand values('蜜达康',187)
--酒类饮品>冰酒
insert into Brand values('北极冰',188)
--酒类饮品>果汁
insert into Brand values('小茶栽堂',189)
insert into Brand values('海地村柚子茶',189)
insert into Brand values('益人生食',189)
--酒类饮品>红酒/葡萄酒
insert into Brand values('万德卡庄',190)
insert into Brand values('习将军',190)
insert into Brand values('北极冰',190)
insert into Brand values('嘉德苏',190)
insert into Brand values('恩古拉',190)
insert into Brand values('拉菲罗斯柴尔德',190)
insert into Brand values('树百年',190)
insert into Brand values('澳洲奔富',190)

--中类粮油干货>食用油/橄榄油
insert into Brand values('优创',192)
insert into Brand values('百伊',192)
--粮油干货>营养保健
insert into Brand values('仁医师',193)
insert into Brand values('寿全斋',193)
insert into Brand values('益人生食',193)
insert into Brand values('诵康堂',193)
insert into Brand values('雷允上',193)
go

--商品筛选属性
create table Selection
(
SelectionId int primary key identity(1,1),--筛选属性ID
SelectionName varchar(300) not null,--筛选属性名称
SortId int foreign key references Sort(SortId)--商品类别ID为外键
)

--大类潮流女装
--女装内衣>文胸/塑型
insert into Selection Values('厚度',3)
insert into Selection Values('功能',3)
insert into Selection Values('杯型',3)
insert into Selection Values('款式',3)
insert into Selection Values('面料',3)
--女装内衣>内衣套装
insert into Selection Values('面料',4)
--女装内衣>女式保暖
insert into Selection Values('分类',5)
insert into Selection Values('材质',5)
insert into Selection Values('厚度',5)
--女装内衣>女式内裤
insert into Selection Values('腰型',6)
insert into Selection Values('款式',6)
insert into Selection Values('材质',6)
insert into Selection Values('风格',6)
--女装内衣>睡衣/家居服
insert into Selection Values('款式',7)
insert into Selection Values('材质',7)
insert into Selection Values('厚度',7)
--中类女装上装>女式T恤
insert into Selection Values('厚薄',9)
insert into Selection Values('袖长',9)
insert into Selection Values('领型',9)
insert into Selection Values('面料',9)
--女装上装>女式皮衣
insert into Selection Values('厚薄',10)
insert into Selection Values('衣长',10)
insert into Selection Values('领型',10)
insert into Selection Values('面料',10)
--女装上装>女式针织衫/毛衣
insert into Selection Values('厚薄',11)
insert into Selection Values('袖长',11)
insert into Selection Values('季节',11)
insert into Selection Values('面料',11)
--女装上装>女式大衣/风衣
insert into Selection Values('厚薄',12)
insert into Selection Values('袖长',12)
insert into Selection Values('风格',12)
insert into Selection Values('面料',12)
--女装上装>女式外套/夹克
insert into Selection Values('厚薄',13)
insert into Selection Values('袖长',13)
insert into Selection Values('季节',13)
insert into Selection Values('面料',13)
--女装上装>女式羽绒服
insert into Selection Values('厚薄',14)
insert into Selection Values('衣长',14)
insert into Selection Values('领型',14)
insert into Selection Values('面料',14)
--女装上装>打底衫
insert into Selection Values('厚薄',15)
insert into Selection Values('袖型',15)
insert into Selection Values('领型',15)
insert into Selection Values('面料',15)
--女装上装>女式马甲/ 背心
insert into Selection Values('风格',16)
insert into Selection Values('款式',16)
insert into Selection Values('材质',16)
--女装上装>衬衫/雪纺衫
insert into Selection Values('厚薄',17)
insert into Selection Values('袖长',17)
insert into Selection Values('领型',17)
insert into Selection Values('季节',17)
insert into Selection Values('面料',17)
--女装上装>女式棉服
insert into Selection Values('厚薄',18)
insert into Selection Values('领型',18)
insert into Selection Values('季节',18)
insert into Selection Values('面料',18)
--女装上装>女式西服
insert into Selection Values('厚薄',19)
insert into Selection Values('袖长',19)
insert into Selection Values('领型',19)
insert into Selection Values('面料',19)
--女装下装/裙装>礼服
insert into Selection Values('风格',21)
insert into Selection Values('厚度',21)
insert into Selection Values('季节',21)
insert into Selection Values('款式',21)
insert into Selection Values('面料',21)
--女装下装/裙装>女式牛仔裤
insert into Selection Values('裤型',22)
insert into Selection Values('裤长',22)
insert into Selection Values('风格',22)
insert into Selection Values('面料',22)
--女装下装/裙装>裙裤
insert into Selection Values('厚薄',23)
insert into Selection Values('季节',23)
insert into Selection Values('风格',23)
insert into Selection Values('面料',23)
--女装下装/裙装>女式休闲裤
insert into Selection Values('裤型',24)
insert into Selection Values('裤长',24)
insert into Selection Values('风格',24)
insert into Selection Values('面料',24)
--女装下装/裙装>连衣裙
insert into Selection Values('厚薄',25)
insert into Selection Values('裙长',25)
insert into Selection Values('季节',25)
insert into Selection Values('面料',25)
--女装下装/裙装>半身裙
insert into Selection Values('厚薄',26)
insert into Selection Values('裙长',26)
insert into Selection Values('风格',26)
insert into Selection Values('面料',26)
--女装下装/裙装>打底裤
insert into Selection Values('裤型',27)
insert into Selection Values('裤长',27)
insert into Selection Values('风格',27)
insert into Selection Values('面料',27)
go
--女装搭配>单鞋
--insert into Selection Values('',)

--商品筛选属性值表
Create table SelectionValue
(
SelectionValueId int primary key identity(1,1),--筛选属性值ID
SelectionValueName varchar(300) not null,--筛选属性名称
SelectionId int foreign key references Selection(SelectionId)--筛选属性ID为外键
)

--潮流女装
--女装内衣>文胸/塑型
--厚度
insert into SelectionValue values('上薄下厚模杯',1)
insert into SelectionValue values('中模杯',1)
insert into SelectionValue values('厚模杯',1)
insert into SelectionValue values('薄模杯',1)
--功能
insert into SelectionValue values('上托',2)
insert into SelectionValue values('侧收',2)
insert into SelectionValue values('其他',2)
insert into SelectionValue values('可摘卸肩带',2)
insert into SelectionValue values('无痕',2)
insert into SelectionValue values('美背',2)
insert into SelectionValue values('聚拢',2)
insert into SelectionValue values('调整型',2)
--杯型
insert into SelectionValue values('1/2杯',3)
insert into SelectionValue values('3/4杯',3)
insert into SelectionValue values('全罩杯',3)
insert into SelectionValue values('抹胸',3)
insert into SelectionValue values('深V',3)
--款式
insert into SelectionValue values('可拆卸肩带',4)
insert into SelectionValue values('套装',4)
insert into SelectionValue values('抹胸',4)
insert into SelectionValue values('挂脖肩带',4)
insert into SelectionValue values('深V性感',4)
insert into SelectionValue values('美背',4)
--面料
insert into SelectionValue values('棉',5)
insert into SelectionValue values('莱卡',5)
insert into SelectionValue values('蕾丝',5)

--女装内衣>内衣套装
--面料
insert into SelectionValue values('网纱',6)
--女装内衣>女式保暖
--分类
insert into SelectionValue values('保暖内衣',7)
insert into SelectionValue values('保暖套装',7)
--材质
insert into SelectionValue values('棉质',8)
insert into SelectionValue values('羊毛',8)
insert into SelectionValue values('莫代尔',8)
--厚度
insert into SelectionValue values('中厚',9)
insert into SelectionValue values('加厚',9)
--女装内衣>女式内裤
--腰型
insert into SelectionValue values('中腰',10)
insert into SelectionValue values('低腰',10)
--款式
insert into SelectionValue values('三角裤',11)
insert into SelectionValue values('平角裤',11)
--材质
insert into SelectionValue values('弹力棉',12)
insert into SelectionValue values('棉质',12)
insert into SelectionValue values('真丝',12)
insert into SelectionValue values('莫代尔',12)
--风格
insert into SelectionValue values('性感',13)
insert into SelectionValue values('欧美',13)
insert into SelectionValue values('淑女',13)
insert into SelectionValue values('简约',13)

--女装内衣>睡衣/家居服
--款式
insert into SelectionValue values('吊带裙',14)
insert into SelectionValue values('套装',14)
insert into SelectionValue values('睡袍',14)
insert into SelectionValue values('睡裙',14)
--材质
insert into SelectionValue values('夹棉',15)
insert into SelectionValue values('棉质',15)
insert into SelectionValue values('真丝',15)
--厚度
insert into SelectionValue values('中厚',16)
insert into SelectionValue values('其他',16)
insert into SelectionValue values('加厚',16)
insert into SelectionValue values('薄款',16)
insert into SelectionValue values('超薄',16)

--女装上装>女式T恤
--厚薄
insert into SelectionValue values('偏厚',17)
insert into SelectionValue values('偏薄',17)
insert into SelectionValue values('常规',17)
insert into SelectionValue values('薄',17)
--袖长
insert into SelectionValue values('七分袖',18)
insert into SelectionValue values('中袖',18)
insert into SelectionValue values('常规',18)
insert into SelectionValue values('短袖',18)
insert into SelectionValue values('长袖',18)
--领型
insert into SelectionValue values('V领',19)
insert into SelectionValue values('围巾领',19)
insert into SelectionValue values('圆领',19)
insert into SelectionValue values('立领',19)
insert into SelectionValue values('翻领',19)
insert into SelectionValue values('其他',19)
--面料
insert into SelectionValue values('棉类混纺',20)
insert into SelectionValue values('纯棉',20)
insert into SelectionValue values('聚酯纤维/化纤',20)
insert into SelectionValue values('其他',20)

--女装上装>女式皮衣
--厚薄
insert into SelectionValue values('偏厚',21)
insert into SelectionValue values('常规',21)
insert into SelectionValue values('薄',21)
--衣长
insert into SelectionValue values('中长',22)
insert into SelectionValue values('短款',22)
--领型
insert into SelectionValue values('V领',23)
insert into SelectionValue values('其他',23)
insert into SelectionValue values('圆领',23)
insert into SelectionValue values('立领',23)
insert into SelectionValue values('翻领',23)
--面料
insert into SelectionValue values('水洗皮(PU皮/皮革)',24)

--女装上装>女式针织衫/毛衣
--厚薄
insert into SelectionValue values('厚',25)
insert into SelectionValue values('薄',25)
insert into SelectionValue values('常规',25)
--袖长
insert into SelectionValue values('七分袖',26)
insert into SelectionValue values('无袖',26)
insert into SelectionValue values('常规',26)
insert into SelectionValue values('短袖',26)
insert into SelectionValue values('长袖',26)
--季节
insert into SelectionValue values('冬',27)
insert into SelectionValue values('夏',27)
insert into SelectionValue values('春',27)
insert into SelectionValue values('秋',27)
--面料
insert into SelectionValue values('涤纶',28)
insert into SelectionValue values('纯棉',28)
insert into SelectionValue values('羊毛',28)
insert into SelectionValue values('羊绒',28)
insert into SelectionValue values('聚酯纤维/化纤',28)

--女装上装>女式大衣/风衣
--厚薄
insert into SelectionValue values('厚',29)
insert into SelectionValue values('常规',29)
insert into SelectionValue values('薄',29)
--袖长
insert into SelectionValue values('七分袖',30)
insert into SelectionValue values('常规',30)
insert into SelectionValue values('长袖',30)
--风格
insert into SelectionValue values('休闲',31)
insert into SelectionValue values('日韩',31)
insert into SelectionValue values('欧美',31)
insert into SelectionValue values('淑女',31)
--面料
insert into SelectionValue values('桑蚕丝',32)
insert into SelectionValue values('涤纶',32)
insert into SelectionValue values('纯棉',32)
insert into SelectionValue values('羊毛',32)
insert into SelectionValue values('聚酯纤维/化纤',32)
--女装上装>女式外套/夹克
--厚薄
insert into SelectionValue values('厚',33)
insert into SelectionValue values('常规',33)
insert into SelectionValue values('薄',33)
--袖长
insert into SelectionValue values('七分袖',34)
insert into SelectionValue values('常规',34)
insert into SelectionValue values('短袖',34)
--季节
insert into SelectionValue values('冬',35)
insert into SelectionValue values('夏',35)
insert into SelectionValue values('春',35)
insert into SelectionValue values('秋',35)
--面料
insert into SelectionValue values('棉类混纺',36)
insert into SelectionValue values('纯棉',36)
insert into SelectionValue values('羊毛',36)
insert into SelectionValue values('涤纶',36)
insert into SelectionValue values('聚酯纤维/化纤',36)

--女装上装>女式羽绒服
--厚薄
insert into SelectionValue values('偏厚',37)
insert into SelectionValue values('厚',37)
--袖长
insert into SelectionValue values('常规',38)
insert into SelectionValue values('长袖',38)
--领型
insert into SelectionValue values('立领',39)
insert into SelectionValue values('连帽',39)
insert into SelectionValue values('面包领',39)
insert into SelectionValue values('高领',39)
--面料
insert into SelectionValue values('聚酯纤维/化纤',40)
insert into SelectionValue values('纯棉',40)

--女装上装>打底衫
--厚薄
insert into SelectionValue values('薄',41)
insert into SelectionValue values('适中',41)
--袖型
insert into SelectionValue values('吊带',42)
insert into SelectionValue values('无袖',42)
insert into SelectionValue values('长袖',42)
--领型
insert into SelectionValue values('V领',43)
insert into SelectionValue values('圆领',43)
insert into SelectionValue values('翻领',43)
--面料
insert into SelectionValue values('腈纶',44)
insert into SelectionValue values('莫代尔',44)
--女装上装>女式马甲/ 背心
--风格
insert into SelectionValue values('休闲',45)
insert into SelectionValue values('日韩',45)
insert into SelectionValue values('欧美',45)
insert into SelectionValue values('淑女',45)
--款式
insert into SelectionValue values('拉链',46)
insert into SelectionValue values('连帽',46)
--材质
insert into SelectionValue values('棉/丝光棉',47)
insert into SelectionValue values('涤纶',47)
insert into SelectionValue values('腈纶/化纤',47)
--女装上装>衬衫/雪纺衫
--厚薄
insert into SelectionValue values('偏薄',48)
insert into SelectionValue values('常规',48)
insert into SelectionValue values('薄',48)
--袖长
insert into SelectionValue values('七分袖',49)
insert into SelectionValue values('长袖',49)
insert into SelectionValue values('短袖',49)
--领型
insert into SelectionValue values('V领',50)
insert into SelectionValue values('圆领',50)
insert into SelectionValue values('立领',50)
insert into SelectionValue values('翻领',50)
--季节
insert into SelectionValue values('冬',51)
insert into SelectionValue values('夏',51)
insert into SelectionValue values('春',51)
insert into SelectionValue values('秋',51)
--面料
insert into SelectionValue values('桑蚕丝',52)
insert into SelectionValue values('纯棉',52)
insert into SelectionValue values('聚酯纤维/化纤',52)
insert into SelectionValue values('涤纶',52)
--女装上装>女式棉服
--厚薄
insert into SelectionValue values('偏厚',53)
insert into SelectionValue values('厚',53)
insert into SelectionValue values('常规',53)
--领型
insert into SelectionValue values('V领',54)
insert into SelectionValue values('立领',54)
insert into SelectionValue values('连帽',54)
insert into SelectionValue values('其他',54)
-- 季节
insert into SelectionValue values('冬',55)
insert into SelectionValue values('春',55)
insert into SelectionValue values('秋',55)
--面料
insert into SelectionValue values('棉类混纺',56)
insert into SelectionValue values('聚酯纤维/化纤',56)
insert into SelectionValue values('锦纶',56)
insert into SelectionValue values('其他',56)

-- 女装上装>女式西服
-- 厚薄
insert into SelectionValue values('偏薄',57)
insert into SelectionValue values('常规',57)
--袖长
insert into SelectionValue values('七分袖',58)
insert into SelectionValue values('常规',58)
insert into SelectionValue values('长袖',58)
--领型
insert into SelectionValue values('V领',59)
insert into SelectionValue values('低领',59)
insert into SelectionValue values('翻领',59)
insert into SelectionValue values('圆领',59)
insert into SelectionValue values('其他',59)
--面料
insert into SelectionValue values('亚麻',60)
insert into SelectionValue values('涤纶',60)
insert into SelectionValue values('纯棉',60)
insert into SelectionValue values('聚酯纤维/化纤',60)

--女装下装/裙装>礼服
--风格
insert into SelectionValue values('休闲',61)
insert into SelectionValue values('欧美',61)
insert into SelectionValue values('淑女',61)
--厚度
insert into SelectionValue values('厚',62)
insert into SelectionValue values('正常',62)
insert into SelectionValue values('薄',62)
--季节
insert into SelectionValue values('冬',63)
insert into SelectionValue values('夏',63)
insert into SelectionValue values('春',63)
insert into SelectionValue values('秋',63)
--款式
insert into SelectionValue values('抹胸型',64)
insert into SelectionValue values('吊带型',64)
insert into SelectionValue values('常规型',64)
insert into SelectionValue values('挂脖型',64)
insert into SelectionValue values('深v领',64)
--面料
insert into SelectionValue values('桑蚕丝',65)
insert into SelectionValue values('纯棉',65)
insert into SelectionValue values('聚酯纤维',65)
--女装下装/裙装>女式牛仔裤
--裤型
insert into SelectionValue values('修身裤',66)
insert into SelectionValue values('直筒裤',66)
insert into SelectionValue values('紧身裤',66)
insert into SelectionValue values('其他',66)
--裤长
insert into SelectionValue values('七分裤',67)
insert into SelectionValue values('短裤',67)
insert into SelectionValue values('长裤',67)
--风格
insert into SelectionValue values('休闲',68)
insert into SelectionValue values('日韩',68)
insert into SelectionValue values('时尚休闲',68)
insert into SelectionValue values('运动休闲',68)
--面料
insert into SelectionValue values('纯棉',69)
insert into SelectionValue values('聚酯纤维',69)
insert into SelectionValue values('混纺',69)
insert into SelectionValue values('其他',69)

--女装下装/裙装>裙裤
--厚薄
insert into SelectionValue values('厚',70)
insert into SelectionValue values('常规',70)
insert into SelectionValue values('薄',70)
--季节
insert into SelectionValue values('全年',71)
insert into SelectionValue values('冬',71)
insert into SelectionValue values('夏',71)
insert into SelectionValue values('春',71)
--风格
insert into SelectionValue values('休闲',72)
insert into SelectionValue values('性感',72)
insert into SelectionValue values('淑女',72)
insert into SelectionValue values('甜美',72)
--面料
insert into SelectionValue values('纯棉',73)
insert into SelectionValue values('涤纶',73)
insert into SelectionValue values('聚酯纤维/化纤',73)
insert into SelectionValue values('其它',73)

--女装下装/裙装>女式休闲裤
--裤型
insert into SelectionValue values('修身裤',74)
insert into SelectionValue values('打底裤',74)
insert into SelectionValue values('直筒裤',74)
insert into SelectionValue values('紧身裤',74)
--裤长
insert into SelectionValue values('七分裤',75)
insert into SelectionValue values('短裤',75)
insert into SelectionValue values('长裤',75)
--风格
insert into SelectionValue values('商务休闲',76)
insert into SelectionValue values('时尚休闲',76)
insert into SelectionValue values('日韩',76)
insert into SelectionValue values('欧美',76)
insert into SelectionValue values('淑女',76)
--面料
insert into SelectionValue values('涤纶',77)
insert into SelectionValue values('纯棉',77)
insert into SelectionValue values('聚酯纤维',77)
insert into SelectionValue values('其他',77)

--女装下装/裙装>连衣裙
--厚薄
insert into SelectionValue values('厚',78)
insert into SelectionValue values('常规',78)
insert into SelectionValue values('薄',78)
--裙长
insert into SelectionValue values('中长款',79)
insert into SelectionValue values('超短款',79)
insert into SelectionValue values('长款',79)
--季节
insert into SelectionValue values('冬',80)
insert into SelectionValue values('夏',80)
insert into SelectionValue values('春',80)
insert into SelectionValue values('秋',80)
--面料
insert into SelectionValue values('桑蚕丝',81)
insert into SelectionValue values('涤纶',81)
insert into SelectionValue values('纯棉',81)
insert into SelectionValue values('羊毛',81)
insert into SelectionValue values('聚酯纤维/化纤',81)
--女装下装/裙装>半身裙
--厚薄
insert into SelectionValue values('厚',82)
insert into SelectionValue values('常规',82)
insert into SelectionValue values('薄',82)
--裙长
insert into SelectionValue values('中长款',83)
insert into SelectionValue values('短款',83)
insert into SelectionValue values('长款',83)
--风格
insert into SelectionValue values('休闲',84)
insert into SelectionValue values('性感',84)
insert into SelectionValue values('日韩',84)
insert into SelectionValue values('欧美',84)
insert into SelectionValue values('淑女',84)
--面料
insert into SelectionValue values('涤纶',85)
insert into SelectionValue values('纯棉',85)
insert into SelectionValue values('羊毛',85)
insert into SelectionValue values('聚酯纤维/化纤',85)

--女装下装/裙装>打底裤
--裤型
insert into SelectionValue values('修身裤',86)
insert into SelectionValue values('直筒裤',86)
insert into SelectionValue values('紧身裤',86)
--裤长
insert into SelectionValue values('七分裤',87)
insert into SelectionValue values('短裤',87)
insert into SelectionValue values('长裤',87)
--风格
insert into SelectionValue values('时尚休闲',88)
insert into SelectionValue values('日韩',88)
insert into SelectionValue values('欧美',88)
insert into SelectionValue values('淑女',88)
--面料
insert into SelectionValue values('纯棉',89)
insert into SelectionValue values('聚酯纤维',89)
insert into SelectionValue values('其他',89)
go

--商品SKU属性
Create table SkuAttribute
(
SkuAttributeId int primary key identity(1,1),--Sku属性ID
SkuAttributeName varchar(300) not null,--Sku属性名称
SortId int foreign key references Sort(SortId)-- 类别外键
)

--大类潮流女装
--女装内衣>文胸/塑型
insert into SkuAttribute values('颜色',3)
insert into SkuAttribute values('尺码',3)
--女装内衣>内衣套装
insert into SkuAttribute values('颜色',4)
insert into SkuAttribute values('尺码',4)
--女装内衣>女式保暖
insert into SkuAttribute values('颜色',5)
insert into SkuAttribute values('尺码',5)
--女装内衣>女式内裤
insert into SkuAttribute values('颜色',6)
insert into SkuAttribute values('尺码',6)
--女装内衣>睡衣/家居服
insert into SkuAttribute values('颜色',7)
insert into SkuAttribute values('尺码',7)
--女装上装>女式T恤
insert into SkuAttribute values('颜色',9)
insert into SkuAttribute values('尺码',9)
--女装上装>女式皮衣
insert into SkuAttribute values('颜色',10)
insert into SkuAttribute values('尺码',10)
--女装上装>女式针织衫/毛衣
insert into SkuAttribute values('颜色',11)
insert into SkuAttribute values('尺码',11)
--女装上装>女式大衣/风衣
insert into SkuAttribute values('颜色',12)
insert into SkuAttribute values('尺码',12)
--女装上装>女式外套/夹克
insert into SkuAttribute values('颜色',13)
insert into SkuAttribute values('尺码',13)
--女装上装>女式羽绒服
insert into SkuAttribute values('颜色',14)
insert into SkuAttribute values('尺码',14)
--女装上装>打底衫
insert into SkuAttribute values('颜色',15)
insert into SkuAttribute values('尺码',15)
--女装上装>女式马甲/ 背心
insert into SkuAttribute values('颜色',16)
insert into SkuAttribute values('尺码',16)
--女装上装>衬衫/雪纺衫
insert into SkuAttribute values('颜色',17)
insert into SkuAttribute values('尺码',17)
--女装上装>女式棉服
insert into SkuAttribute values('颜色',18)
insert into SkuAttribute values('尺码',18)
--女装上装>女式西服
insert into SkuAttribute values('颜色',19)
insert into SkuAttribute values('尺码',19)

--中类女装下装/裙装>礼服
insert into SkuAttribute values('颜色',21)
insert into SkuAttribute values('尺码',21)
--女装下装/裙装>女式牛仔裤
insert into SkuAttribute values('颜色',22)
insert into SkuAttribute values('尺码',22)
--女装下装/裙装>裙裤
insert into SkuAttribute values('颜色',23)
insert into SkuAttribute values('尺码',23)
--女装下装/裙装>女式休闲裤
insert into SkuAttribute values('颜色',24)
insert into SkuAttribute values('尺码',24)
--女装下装/裙装>连衣裙
insert into SkuAttribute values('颜色',25)
insert into SkuAttribute values('尺码',25)
--女装下装/裙装>半身裙
insert into SkuAttribute values('颜色',26)
insert into SkuAttribute values('尺码',26)
--女装下装/裙装>打底裤
insert into SkuAttribute values('颜色',27)
insert into SkuAttribute values('尺码',27)
--女装搭配>单鞋
insert into SkuAttribute values('颜色',29)
insert into SkuAttribute values('尺码',29)

go

--商品SKU属性值
Create table SkuAttributeValue
(
SkuAttributeValueId int primary key identity(1,1),--SKU属性值ID
SkuAttributeValueName varchar(300) not null,--SKU属性值名称
SkuAttributeId int foreign key references SkuAttribute(SkuAttributeId)--Sku属性ID为外键
)
--女装内衣>文胸/塑型

--女装上装>女式西服
--颜色
insert into SkuAttributeValue values('米色',31)
insert into SkuAttributeValue values('黄色',31)
insert into SkuAttributeValue values('黑色',31)
insert into SkuAttributeValue values('灰蓝',31)
insert into SkuAttributeValue values('深桃色',31)
insert into SkuAttributeValue values('白色',31)
insert into SkuAttributeValue values('驼色',31)
insert into SkuAttributeValue values('兰灰',31)
insert into SkuAttributeValue values('碳墨',31)
insert into SkuAttributeValue values('蔚蓝色',31)
--尺码
insert into SkuAttributeValue values('S',32)
insert into SkuAttributeValue values('M',32)
insert into SkuAttributeValue values('L',32)
insert into SkuAttributeValue values('XL',32)

go

 

--商品表 8
Create table Commodity
(
CommodityId int primary key identity(1,1),-- 商品ID
CommodityName varchar(300) not null,--商品名称
MarketPrice numeric(8,2)not null,--市场价
CommodityAddTime DateTime not null,--商品上架时间
CommodityIntroduce varchar(5000),--商品介绍
BrandId int foreign key references Brand(BrandId),--品牌ID外键
SortId int foreign key references Sort(SortId),--类别ID外键
CSelectionAttribute varchar(300)-- 商品筛选属性
)
insert into Commodity values('Lachapelle Sport 拉夏贝尔 趣味系列',269.00,'2014-4-28','rBEhVlNDtxsIAAAAAAM6FMrJgP4AALiwANCJ1gAAzos660.jpg',92,19,'198,199,204,210')
insert into Commodity values('EDELA埃迪拉修身小西装96A402',789.00,'2014-4-12','',94,19,'198,201,202,210')
insert into Commodity values('Acque Demi 艾珂黛米 长袖高腰小西装外套',1688.00,'2014-4-12','',97,19,'198,201,205,210')
insert into Commodity values('Acque Demi 艾珂黛米 中袖修身短款小西装外套',1588.00,'2014-4-16','',97,19,'198,199,204,209')
insert into Commodity values('Mikibana文艺小西装M41TB1765',899.00,'2014-4-18','',97,19,'198,200,202,207')
insert into Commodity values('emely 安魅力 正品 长袖精致帅气小外套',1180.00,'2014-4-18','',95,19,'198,201,203,209')
insert into Commodity values('emely 安魅力 专柜正品 女装 西装短外套 韩版小西装',14800.00,'2014-4-18','',95,19,'198,201,206,209')
insert into Commodity values('纳薇一粒扣西装外套',899.00,'2014-4-25','',96,19,'197,200,206,208')
insert into Commodity values('Mikibana 经典桔色西装领上衣 S2145B11',1680.00,'2014-4-18','',93,19,'197,199,202,209')
insert into Commodity values('Mikibana 翻领西装 1418201',1580.00,'2014-5-25','',93,19,'197,200,204,207')
insert into Commodity values('Acque Demi 艾珂黛米 蕾丝设计长袖 小西装 W-525-028',1180.00,'2014-5-25','',94,19,'197,200,202,207')
insert into Commodity values('Acque Demi 艾珂黛米 长袖仿麂皮 休闲西装外套 W-279-101',1380.00,'2014-5-25','',94,19,'197,199,202,208')
insert into Commodity values('Acque Demi 艾珂黛米 长袖仿麂皮 休闲西装外套 W-279-046',1380.00,'2014-5-27','',94,19,'198,200,203,209')
insert into Commodity values('emely 安魅力 正品 女士优雅通勒OL小西装 5112302160',1580.00,'2014-5-27','',95,19,'198,201,204,210')
insert into Commodity values('emely 安魅力 正品 女装 短外套 韩版帅气小西装',1380.00,'2014-5-24','',95,19,'198,201,205,207')
insert into Commodity values('纳薇一季候风 西装时尚V型领',696.00,'2014-5-24','',96,19,'198,199,205,209')
insert into Commodity values('艾珂黛米 季候风 西装时尚V型领',1699.00,'2014-5-28','',97,19,'198,201,206,210')
insert into Commodity values('Naivee纳薇青春时尚西装',589.00,'2014-5-28','',96,19,'198,200,202,208')
insert into Commodity values('LachapelleSport拉夏贝尔运动趣味系列西装领两件套',399.00,'2014-5-29','',92,19,'198,200,203,209')
insert into Commodity values('naivee纳薇经典款修身西装',789.00,'2014-5-29','',96,19,'198,200,203,209')

go

Create table Sku
(
SkuId int primary key identity(1,1),--SkuID
SkuPrice numeric(8,2)not null,--Sku价格
SkuQuanlity int not null,--Sku商品数量
SkuImg varchar(300) not null,--Sku图片
SkuCode varchar(300),--Sku码值
CommodityId int foreign key references Commodity(CommodityId)--商品Id外键
)
--女装上装>女式西服
--31-1 颜色-米色,32-11 尺码-S
insert into Sku values(269.00,300,'S85-241-0JP_11.jpg','31-1,32-11',1)
insert into Sku values(269.00,300,'S85-241-0JP_11.jpg','31-1,32-12',1)
insert into Sku values(269.00,300,'S85-241-0JP_11.jpg','31-1,32-13',1)
insert into Sku values(789.00,300,'A85-437-0I6_1.jpg','31-2,32-11',2)
insert into Sku values(789.00,300,'A85-437-0I6_1.jpg','31-2,32-12',2)
insert into Sku values(789.00,300,'A85-437-0I6_1.jpg','31-2,32-13',2)
insert into Sku values(789.00,300,'A85-437-0I6_1.jpg','31-2,32-14',2)
insert into Sku values(844.00,300,'A85-010-0B1_1.jpg','31-3,32-11',3)
insert into Sku values(844.00,300,'A85-010-0B1_1.jpg','31-3,32-12',3)
insert into Sku values(844.00,300,'A85-010-0B1_1.jpg','31-3,32-13',3)
insert into Sku values(844.00,300,'A85-010-0B1_1.jpg','31-3,32-14',3)
insert into Sku values(794.00,300,'A85-010-0B3_1.jpg','31-7,32-11',4)
insert into Sku values(794.00,300,'A85-010-0B3_1.jpg','31-7,32-12',4)
insert into Sku values(794.00,300,'A85-010-0B3_1.jpg','31-7,32-13',4)
insert into Sku values(794.00,300,'A85-010-0B3_1.jpg','31-7,32-14',4)
insert into Sku values(899.00,300,'A85-390-01C_00.jpg','31-4,32-11',5)
insert into Sku values(899.00,300,'A85-390-01C_00.jpg','31-4,32-12',5)
insert into Sku values(899.00,300,'A85-390-01C_00.jpg','31-4,32-13',5)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-8,32-11',6)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-8,32-12',6)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-8,32-13',6)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-9,32-11',6)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-9,32-12',6)
insert into Sku values(226.00,300,'A34-041-0FL_06.jpg','31-9,32-13',6)
insert into Sku values(298.00,300,'A34-041-0FC.jpg','31-9,32-11',7)
insert into Sku values(298.00,300,'A34-041-0FC.jpg','31-9,32-12',7)
insert into Sku values(298.00,300,'A34-041-0FC.jpg','31-9,32-13',7)
insert into Sku values(298.00,300,'A34-041-0FC.jpg','31-9,32-14',7)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-10,32-11',8)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-10,32-12',8)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-10,32-13',8)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-3,32-11',8)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-3,32-12',8)
insert into Sku values(889.00,300,'A34-345-0GX_05.jpg','31-3,32-13',8)
insert into Sku values(1680.00,300,'S85-211-0O9_1.jpg','31-5,32-13',9)
insert into Sku values(1680.00,300,'S85-211-0O9_1.jpg','31-5,32-14',9)
insert into Sku values(1580.00,300,'S85-388-0OU_1.jpg','31-1,32-11',10)
insert into Sku values(1580.00,300,'S85-388-0OU_1.jpg','31-1,32-12',10)
insert into Sku values(1580.00,300,'S85-388-0OU_1.jpg','31-1,32-13',10)
insert into Sku values(559.00,300,'A85-010-0BU_1.jpg','31-7,32-11',11)
insert into Sku values(559.00,300,'A85-010-0BU_1.jpg','31-7,32-12',11)
insert into Sku values(559.00,300,'A85-010-0BU_1.jpg','31-7,32-13',11)
insert into Sku values(694.00,300,'A85-010-0BO_1.jpg','31-2,32-11',12)
insert into Sku values(694.00,300,'A85-010-0BO_1.jpg','31-2,32-12',12)
insert into Sku values(694.00,300,'A85-010-0BO_1.jpg','31-2,32-13',12)
insert into Sku values(694.00,300,'A85-010-0BM_1.jpg','31-1,32-11',13)
insert into Sku values(694.00,300,'A85-010-0BM_1.jpg','31-1,32-12',13)
insert into Sku values(694.00,300,'A85-010-0BM_1.jpg','31-1,32-13',13)
insert into Sku values(694.00,300,'A85-010-0BM_1.jpg','31-1,32-14',13)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-1,32-11',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-1,32-12',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-1,32-13',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-1,32-14',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-9,32-11',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-9,32-12',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-9,32-13',14)
insert into Sku values(521.00,300,'A34-041-0FZ.jpg','31-9,32-14',14)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-4,32-11',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-4,32-12',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-4,32-13',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-4,32-14',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-7,32-11',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-7,32-12',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-7,32-13',15)
insert into Sku values(276.00,300,'A34-041-0F4.jpg','31-7,32-14',15)
insert into Sku values(696.00,300,'S85-432-0O0_1.jpg','31-2,32-11',16)
insert into Sku values(696.00,300,'S85-432-0O0_1.jpg','31-2,32-12',16)
insert into Sku values(696.00,300,'S85-432-0O0_1.jpg','31-2,32-13',16)
insert into Sku values(696.00,300,'S85-432-0O0_1.jpg','31-2,32-14',16)
insert into Sku values(1699.00,300,'S85-458-0OI_1.jpg','31-10,32-11',17)
insert into Sku values(1699.00,300,'S85-458-0OI_1.jpg','31-10,32-12',17)
insert into Sku values(1699.00,300,'S85-458-0OI_1.jpg','31-10,32-13',17)
insert into Sku values(1699.00,300,'S85-458-0OI_1.jpg','31-10,32-14',17)
insert into Sku values(589.00,300,'A85-345-0GL.jpg','31-3,32-11',18)
insert into Sku values(589.00,300,'A85-345-0GL.jpg','31-3,32-12',18)
insert into Sku values(589.00,300,'A85-345-0GL.jpg','31-3,32-13',18)
insert into Sku values(589.00,300,'A85-345-0GL.jpg','31-3,32-14',18)
insert into Sku values(399.00,300,'A85-241-0GA_1.jpg','31-10,32-12',19)
insert into Sku values(399.00,300,'A85-241-0GA_1.jpg','31-10,32-13',19)
insert into Sku values(399.00,300,'A85-241-0GA_1.jpg','31-10,32-14',19)
insert into Sku values(789.00,300,'A85-345-0EO_1.jpg','31-7,32-11',20)
insert into Sku values(789.00,300,'A85-345-0EO_1.jpg','31-7,32-12',20)
insert into Sku values(789.00,300,'A85-345-0EO_1.jpg','31-7,32-13',20)
go

Create table SkuPicture
(
SkuPictureId int primary key identity(1,1),--SKU相册ID
SkuPictureName varchar(300) not null,--Sku图片名
SkuId int foreign key references Sku(SkuId)--SkuId外键
)

insert into SkuPicture values('S85-241-0JP_11.jpg',1)
insert into SkuPicture values('S85-241-0JP_12.jpg',1)
insert into SkuPicture values('S85-241-0JP_13.jpg',1)
insert into SkuPicture values('S85-241-0JP_14.jpg',1)
insert into SkuPicture values('S85-241-0JP_15.jpg',1)
insert into SkuPicture values('S85-241-0JP_11.jpg',2)
insert into SkuPicture values('S85-241-0JP_12.jpg',2)
insert into SkuPicture values('S85-241-0JP_13.jpg',2)
insert into SkuPicture values('S85-241-0JP_14.jpg',2)
insert into SkuPicture values('S85-241-0JP_15.jpg',2)
insert into SkuPicture values('S85-241-0JP_11.jpg',3)
insert into SkuPicture values('S85-241-0JP_12.jpg',3)
insert into SkuPicture values('S85-241-0JP_13.jpg',3)
insert into SkuPicture values('S85-241-0JP_14.jpg',3)
insert into SkuPicture values('S85-241-0JP_15.jpg',3)
insert into SkuPicture values('A85-437-0I6_1.jpg',4)
insert into SkuPicture values('A85-437-0I6_2.jpg',4)
insert into SkuPicture values('A85-437-0I6_3.jpg',4)
insert into SkuPicture values('A85-437-0I6_4.jpg',4)
insert into SkuPicture values('A85-437-0I6_5.jpg',4)
insert into SkuPicture values('A85-437-0I6_1.jpg',5)
insert into SkuPicture values('A85-437-0I6_2.jpg',5)
insert into SkuPicture values('A85-437-0I6_3.jpg',5)
insert into SkuPicture values('A85-437-0I6_4.jpg',5)
insert into SkuPicture values('A85-437-0I6_5.jpg',5)
insert into SkuPicture values('A85-437-0I6_1.jpg',6)
insert into SkuPicture values('A85-437-0I6_2.jpg',6)
insert into SkuPicture values('A85-437-0I6_3.jpg',6)
insert into SkuPicture values('A85-437-0I6_4.jpg',6)
insert into SkuPicture values('A85-437-0I6_5.jpg',6)
insert into SkuPicture values('A85-437-0I6_1.jpg',7)
insert into SkuPicture values('A85-437-0I6_2.jpg',7)
insert into SkuPicture values('A85-437-0I6_3.jpg',7)
insert into SkuPicture values('A85-437-0I6_4.jpg',7)
insert into SkuPicture values('A85-437-0I6_5.jpg',7)
insert into SkuPicture values('A85-010-0B1_1.jpg',8)
insert into SkuPicture values('A85-010-0B1_2.jpg',8)
insert into SkuPicture values('A85-010-0B1_3.jpg',8)
insert into SkuPicture values('A85-010-0B1_4.jpg',8)
insert into SkuPicture values('A85-010-0B1_5.jpg',8)
insert into SkuPicture values('A85-010-0B1_1.jpg',9)
insert into SkuPicture values('A85-010-0B1_2.jpg',9)
insert into SkuPicture values('A85-010-0B1_3.jpg',9)
insert into SkuPicture values('A85-010-0B1_4.jpg',9)
insert into SkuPicture values('A85-010-0B1_5.jpg',9)
insert into SkuPicture values('A85-010-0B1_1.jpg',10)
insert into SkuPicture values('A85-010-0B1_2.jpg',10)
insert into SkuPicture values('A85-010-0B1_3.jpg',10)
insert into SkuPicture values('A85-010-0B1_4.jpg',10)
insert into SkuPicture values('A85-010-0B1_5.jpg',10)
insert into SkuPicture values('A85-010-0B1_1.jpg',11)
insert into SkuPicture values('A85-010-0B1_2.jpg',11)
insert into SkuPicture values('A85-010-0B1_3.jpg',11)
insert into SkuPicture values('A85-010-0B1_4.jpg',11)
insert into SkuPicture values('A85-010-0B1_5.jpg',11)
insert into SkuPicture values('A85-010-0B3_1.jpg',12)
insert into SkuPicture values('A85-010-0B3_2.jpg',12)
insert into SkuPicture values('A85-010-0B3_3.jpg',12)
insert into SkuPicture values('A85-010-0B3_4.jpg',12)
insert into SkuPicture values('A85-010-0B3_5.jpg',12)
insert into SkuPicture values('A85-010-0B3_1.jpg',13)
insert into SkuPicture values('A85-010-0B3_2.jpg',13)
insert into SkuPicture values('A85-010-0B3_3.jpg',13)
insert into SkuPicture values('A85-010-0B3_4.jpg',13)
insert into SkuPicture values('A85-010-0B3_5.jpg',13)
insert into SkuPicture values('A85-010-0B3_1.jpg',14)
insert into SkuPicture values('A85-010-0B3_2.jpg',14)
insert into SkuPicture values('A85-010-0B3_3.jpg',14)
insert into SkuPicture values('A85-010-0B3_4.jpg',14)
insert into SkuPicture values('A85-010-0B3_5.jpg',14)
insert into SkuPicture values('A85-010-0B3_1.jpg',15)
insert into SkuPicture values('A85-010-0B3_2.jpg',15)
insert into SkuPicture values('A85-010-0B3_3.jpg',15)
insert into SkuPicture values('A85-010-0B3_4.jpg',15)
insert into SkuPicture values('A85-010-0B3_5.jpg',15)
insert into SkuPicture values('A85-390-01C_00.jpg',16)
insert into SkuPicture values('A85-390-01C_021.jpg',16)
insert into SkuPicture values('A85-390-01C_003.jpg',16)
insert into SkuPicture values('A85-390-01C_0211.jpg',16)
insert into SkuPicture values('A85-390-01C_001.jpg',16)
insert into SkuPicture values('A85-390-01C_00.jpg',17)
insert into SkuPicture values('A85-390-01C_021.jpg',17)
insert into SkuPicture values('A85-390-01C_003.jpg',17)
insert into SkuPicture values('A85-390-01C_0211.jpg',17)
insert into SkuPicture values('A85-390-01C_001.jpg',17)
insert into SkuPicture values('A85-390-01C_00.jpg',18)
insert into SkuPicture values('A85-390-01C_021.jpg',18)
insert into SkuPicture values('A85-390-01C_003.jpg',18)
insert into SkuPicture values('A85-390-01C_0211.jpg',18)
insert into SkuPicture values('A85-390-01C_001.jpg',18)
insert into SkuPicture values('A34-041-0FL_06.jpg',19)
insert into SkuPicture values('A34-041-0FL_07.jpg',19)
insert into SkuPicture values('A34-041-0FL_08.jpg',19)
insert into SkuPicture values('A34-041-0FL_09.jpg',19)
insert into SkuPicture values('A34-041-0FL_10.jpg',19)
insert into SkuPicture values('A34-041-0FL_06.jpg',20)
insert into SkuPicture values('A34-041-0FL_07.jpg',20)
insert into SkuPicture values('A34-041-0FL_08.jpg',20)
insert into SkuPicture values('A34-041-0FL_09.jpg',20)
insert into SkuPicture values('A34-041-0FL_10.jpg',20)
insert into SkuPicture values('A34-041-0FL_06.jpg',21)
insert into SkuPicture values('A34-041-0FL_07.jpg',21)
insert into SkuPicture values('A34-041-0FL_08.jpg',21)
insert into SkuPicture values('A34-041-0FL_09.jpg',21)
insert into SkuPicture values('A34-041-0FL_10.jpg',21)
insert into SkuPicture values('A34-041-0FL.jpg',22)
insert into SkuPicture values('A34-041-0FL_02.jpg',22)
insert into SkuPicture values('A34-041-0FL_03.jpg',22)
insert into SkuPicture values('A34-041-0FL_04.jpg',22)
insert into SkuPicture values('A34-041-0FL_05.jpg',22)
insert into SkuPicture values('A34-041-0FL.jpg',23)
insert into SkuPicture values('A34-041-0FL_02.jpg',23)
insert into SkuPicture values('A34-041-0FL_03.jpg',23)
insert into SkuPicture values('A34-041-0FL_04.jpg',23)
insert into SkuPicture values('A34-041-0FL_05.jpg',23)
insert into SkuPicture values('A34-041-0FL.jpg',24)
insert into SkuPicture values('A34-041-0FL_02.jpg',24)
insert into SkuPicture values('A34-041-0FL_03.jpg',24)
insert into SkuPicture values('A34-041-0FL_04.jpg',24)
insert into SkuPicture values('A34-041-0FL_05.jpg',24)

insert into SkuPicture values('A34-041-0FC.jpg',25)
insert into SkuPicture values('A34-041-0FC_02.jpg',25)
insert into SkuPicture values('A34-041-0FC_03.jpg',25)
insert into SkuPicture values('A34-041-0FC_04.jpg',25)
insert into SkuPicture values('A34-041-0FC_05.jpg',25)
insert into SkuPicture values('A34-041-0FC.jpg',26)
insert into SkuPicture values('A34-041-0FC_02.jpg',26)
insert into SkuPicture values('A34-041-0FC_03.jpg',26)
insert into SkuPicture values('A34-041-0FC_04.jpg',26)
insert into SkuPicture values('A34-041-0FC_05.jpg',26)
insert into SkuPicture values('A34-041-0FC.jpg',27)
insert into SkuPicture values('A34-041-0FC_02.jpg',27)
insert into SkuPicture values('A34-041-0FC_03.jpg',27)
insert into SkuPicture values('A34-041-0FC_04.jpg',27)
insert into SkuPicture values('A34-041-0FC_05.jpg',27)
insert into SkuPicture values('A34-041-0FC.jpg',28)
insert into SkuPicture values('A34-041-0FC_02.jpg',28)
insert into SkuPicture values('A34-041-0FC_03.jpg',28)
insert into SkuPicture values('A34-041-0FC_04.jpg',28)
insert into SkuPicture values('A34-041-0FC_05.jpg',28)
insert into SkuPicture values('A34-345-0GX_05.jpg',29)
insert into SkuPicture values('A34-345-0GX_06.jpg',29)
insert into SkuPicture values('A34-345-0GX_07.jpg',29)
insert into SkuPicture values('A34-345-0GX_08.jpg',29)
insert into SkuPicture values('A34-345-0GX_09.jpg',29)
insert into SkuPicture values('A34-345-0GX_05.jpg',30)
insert into SkuPicture values('A34-345-0GX_06.jpg',30)
insert into SkuPicture values('A34-345-0GX_07.jpg',30)
insert into SkuPicture values('A34-345-0GX_08.jpg',30)
insert into SkuPicture values('A34-345-0GX_09.jpg',30)
insert into SkuPicture values('A34-345-0GX_05.jpg',31)
insert into SkuPicture values('A34-345-0GX_06.jpg',31)
insert into SkuPicture values('A34-345-0GX_07.jpg',31)
insert into SkuPicture values('A34-345-0GX_08.jpg',31)
insert into SkuPicture values('A34-345-0GX_09.jpg',31)
insert into SkuPicture values('A34-345-0GX.jpg',32)
insert into SkuPicture values('A34-345-0GX_01.jpg',32)
insert into SkuPicture values('A34-345-0GX_02.jpg',32)
insert into SkuPicture values('A34-345-0GX_03.JPG',32)
insert into SkuPicture values('A34-345-0GX_04.JPG',32)
insert into SkuPicture values('A34-345-0GX.jpg',33)
insert into SkuPicture values('A34-345-0GX_01.jpg',33)
insert into SkuPicture values('A34-345-0GX_02.jpg',33)
insert into SkuPicture values('A34-345-0GX_03.JPG',33)
insert into SkuPicture values('A34-345-0GX_04.JPG',33)
insert into SkuPicture values('A34-345-0GX.jpg',34)
insert into SkuPicture values('A34-345-0GX_01.jpg',34)
insert into SkuPicture values('A34-345-0GX_02.jpg',34)
insert into SkuPicture values('A34-345-0GX_03.JPG',34)
insert into SkuPicture values('A34-345-0GX_04.JPG',34)
insert into SkuPicture values('S85-211-0O9_1.jpg',35)
insert into SkuPicture values('S85-211-0O9_2.jpg',35)
insert into SkuPicture values('S85-211-0O9_3.jpg',35)
insert into SkuPicture values('S85-211-0O9_4.jpg',35)
insert into SkuPicture values('S85-211-0O9_5.jpg',35)
insert into SkuPicture values('S85-211-0O9_1.jpg',36)
insert into SkuPicture values('S85-211-0O9_2.jpg',36)
insert into SkuPicture values('S85-211-0O9_3.jpg',36)
insert into SkuPicture values('S85-211-0O9_4.jpg',36)
insert into SkuPicture values('S85-211-0O9_5.jpg',36)
insert into SkuPicture values('S85-388-0OU_1.jpg',37)
insert into SkuPicture values('S85-388-0OU_2.jpg',37)
insert into SkuPicture values('S85-388-0OU_3.jpg',37)
insert into SkuPicture values('S85-388-0OU_4.jpg',37)
insert into SkuPicture values('S85-388-0OU_5.jpg',37)
insert into SkuPicture values('S85-388-0OU_1.jpg',38)
insert into SkuPicture values('S85-388-0OU_2.jpg',38)
insert into SkuPicture values('S85-388-0OU_3.jpg',38)
insert into SkuPicture values('S85-388-0OU_4.jpg',38)
insert into SkuPicture values('S85-388-0OU_5.jpg',38)
insert into SkuPicture values('S85-388-0OU_1.jpg',39)
insert into SkuPicture values('S85-388-0OU_2.jpg',39)
insert into SkuPicture values('S85-388-0OU_3.jpg',39)
insert into SkuPicture values('S85-388-0OU_4.jpg',39)
insert into SkuPicture values('S85-388-0OU_5.jpg',39)
insert into SkuPicture values('A85-010-0BU_1.jpg',40)
insert into SkuPicture values('A85-010-0BU_2.jpg',40)
insert into SkuPicture values('A85-010-0BU_3.jpg',40)
insert into SkuPicture values('A85-010-0BU_4.jpg',40)
insert into SkuPicture values('A85-010-0BU_5.jpg',40)
insert into SkuPicture values('A85-010-0BU_1.jpg',41)
insert into SkuPicture values('A85-010-0BU_2.jpg',41)
insert into SkuPicture values('A85-010-0BU_3.jpg',41)
insert into SkuPicture values('A85-010-0BU_4.jpg',41)
insert into SkuPicture values('A85-010-0BU_5.jpg',41)
insert into SkuPicture values('A85-010-0BU_1.jpg',42)
insert into SkuPicture values('A85-010-0BU_2.jpg',42)
insert into SkuPicture values('A85-010-0BU_3.jpg',42)
insert into SkuPicture values('A85-010-0BU_4.jpg',42)
insert into SkuPicture values('A85-010-0BU_5.jpg',42)
insert into SkuPicture values('A85-010-0BO_1.jpg',43)
insert into SkuPicture values('A85-010-0BO_2.jpg',43)
insert into SkuPicture values('A85-010-0BO_3.jpg',43)
insert into SkuPicture values('A85-010-0BO_4.jpg',43)
insert into SkuPicture values('A85-010-0BO_5.jpg',43)
insert into SkuPicture values('A85-010-0BO_1.jpg',44)
insert into SkuPicture values('A85-010-0BO_2.jpg',44)
insert into SkuPicture values('A85-010-0BO_3.jpg',44)
insert into SkuPicture values('A85-010-0BO_4.jpg',44)
insert into SkuPicture values('A85-010-0BO_5.jpg',44)
insert into SkuPicture values('A85-010-0BO_1.jpg',45)
insert into SkuPicture values('A85-010-0BO_2.jpg',45)
insert into SkuPicture values('A85-010-0BO_3.jpg',45)
insert into SkuPicture values('A85-010-0BO_4.jpg',45)
insert into SkuPicture values('A85-010-0BO_5.jpg',45)
insert into SkuPicture values('A85-010-0BM_1.jpg',46)
insert into SkuPicture values('A85-010-0BM_2.jpg',46)
insert into SkuPicture values('A85-010-0BM_3.jpg',46)
insert into SkuPicture values('A85-010-0BM_4.jpg',46)
insert into SkuPicture values('A85-010-0BM_5.jpg',46)
insert into SkuPicture values('A85-010-0BM_1.jpg',47)
insert into SkuPicture values('A85-010-0BM_2.jpg',47)
insert into SkuPicture values('A85-010-0BM_3.jpg',47)
insert into SkuPicture values('A85-010-0BM_4.jpg',47)
insert into SkuPicture values('A85-010-0BM_5.jpg',47)
insert into SkuPicture values('A85-010-0BM_1.jpg',48)
insert into SkuPicture values('A85-010-0BM_2.jpg',48)
insert into SkuPicture values('A85-010-0BM_3.jpg',48)
insert into SkuPicture values('A85-010-0BM_4.jpg',48)
insert into SkuPicture values('A85-010-0BM_5.jpg',48)
insert into SkuPicture values('A85-010-0BM_1.jpg',49)
insert into SkuPicture values('A85-010-0BM_2.jpg',49)
insert into SkuPicture values('A85-010-0BM_3.jpg',49)
insert into SkuPicture values('A85-010-0BM_4.jpg',49)
insert into SkuPicture values('A85-010-0BM_5.jpg',49)
insert into SkuPicture values('A34-041-0FZ.jpg',50)
insert into SkuPicture values('A34-041-0FZ_02.jpg',50)
insert into SkuPicture values('A34-041-0FZ_03.jpg',50)
insert into SkuPicture values('A34-041-0FZ_04.jpg',50)
insert into SkuPicture values('A34-041-0FZ_05.jpg',50)
insert into SkuPicture values('A34-041-0FZ.jpg',51)
insert into SkuPicture values('A34-041-0FZ_02.jpg',51)
insert into SkuPicture values('A34-041-0FZ_03.jpg',51)
insert into SkuPicture values('A34-041-0FZ_04.jpg',51)
insert into SkuPicture values('A34-041-0FZ_05.jpg',51)
insert into SkuPicture values('A34-041-0FZ.jpg',52)
insert into SkuPicture values('A34-041-0FZ_02.jpg',52)
insert into SkuPicture values('A34-041-0FZ_03.jpg',52)
insert into SkuPicture values('A34-041-0FZ_04.jpg',52)
insert into SkuPicture values('A34-041-0FZ_05.jpg',52)
insert into SkuPicture values('A34-041-0FZ.jpg',53)
insert into SkuPicture values('A34-041-0FZ_02.jpg',53)
insert into SkuPicture values('A34-041-0FZ_03.jpg',53)
insert into SkuPicture values('A34-041-0FZ_04.jpg',53)
insert into SkuPicture values('A34-041-0FZ_05.jpg',53)
insert into SkuPicture values('A34-041-0FZ_06.jpg',54)
insert into SkuPicture values('A34-041-0FZ_07.jpg',54)
insert into SkuPicture values('A34-041-0FZ_08.jpg',54)
insert into SkuPicture values('A34-041-0FZ_09.jpg',54)
insert into SkuPicture values('A34-041-0FZ_10.jpg',54)
insert into SkuPicture values('A34-041-0FZ_06.jpg',55)
insert into SkuPicture values('A34-041-0FZ_07.jpg',55)
insert into SkuPicture values('A34-041-0FZ_08.jpg',55)
insert into SkuPicture values('A34-041-0FZ_09.jpg',55)
insert into SkuPicture values('A34-041-0FZ_10.jpg',55)
insert into SkuPicture values('A34-041-0FZ_06.jpg',56)
insert into SkuPicture values('A34-041-0FZ_07.jpg',56)
insert into SkuPicture values('A34-041-0FZ_08.jpg',56)
insert into SkuPicture values('A34-041-0FZ_09.jpg',56)
insert into SkuPicture values('A34-041-0FZ_10.jpg',56)
insert into SkuPicture values('A34-041-0FZ_06.jpg',57)
insert into SkuPicture values('A34-041-0FZ_07.jpg',57)
insert into SkuPicture values('A34-041-0FZ_08.jpg',57)
insert into SkuPicture values('A34-041-0FZ_09.jpg',57)
insert into SkuPicture values('A34-041-0FZ_10.jpg',57)
insert into SkuPicture values('A34-041-0F4.jpg',58)
insert into SkuPicture values('A34-041-0F4_02.jpg',58)
insert into SkuPicture values('A34-041-0F4_03.jpg',58)
insert into SkuPicture values('A34-041-0F4_04.jpg',58)
insert into SkuPicture values('A34-041-0F4_05.jpg',58)
insert into SkuPicture values('A34-041-0F4.jpg',59)
insert into SkuPicture values('A34-041-0F4_02.jpg',59)
insert into SkuPicture values('A34-041-0F4_03.jpg',59)
insert into SkuPicture values('A34-041-0F4_04.jpg',59)
insert into SkuPicture values('A34-041-0F4_05.jpg',59)
insert into SkuPicture values('A34-041-0F4.jpg',60)
insert into SkuPicture values('A34-041-0F4_02.jpg',60)
insert into SkuPicture values('A34-041-0F4_03.jpg',60)
insert into SkuPicture values('A34-041-0F4_04.jpg',60)
insert into SkuPicture values('A34-041-0F4_05.jpg',60)
insert into SkuPicture values('A34-041-0F4.jpg',61)
insert into SkuPicture values('A34-041-0F4_02.jpg',61)
insert into SkuPicture values('A34-041-0F4_03.jpg',61)
insert into SkuPicture values('A34-041-0F4_04.jpg',61)
insert into SkuPicture values('A34-041-0F4_05.jpg',61)
insert into SkuPicture values('A34-041-0F4_06.jpg',62)
insert into SkuPicture values('A34-041-0F4_07.jpg',62)
insert into SkuPicture values('A34-041-0F4_08.jpg',62)
insert into SkuPicture values('A34-041-0F4_09.jpg',62)
insert into SkuPicture values('A34-041-0F4_10.jpg',62)
insert into SkuPicture values('A34-041-0F4_06.jpg',63)
insert into SkuPicture values('A34-041-0F4_07.jpg',63)
insert into SkuPicture values('A34-041-0F4_08.jpg',63)
insert into SkuPicture values('A34-041-0F4_09.jpg',63)
insert into SkuPicture values('A34-041-0F4_10.jpg',63)
insert into SkuPicture values('A34-041-0F4_06.jpg',64)
insert into SkuPicture values('A34-041-0F4_07.jpg',64)
insert into SkuPicture values('A34-041-0F4_08.jpg',64)
insert into SkuPicture values('A34-041-0F4_09.jpg',64)
insert into SkuPicture values('A34-041-0F4_10.jpg',64)
insert into SkuPicture values('A34-041-0F4_06.jpg',65)
insert into SkuPicture values('A34-041-0F4_07.jpg',65)
insert into SkuPicture values('A34-041-0F4_08.jpg',65)
insert into SkuPicture values('A34-041-0F4_09.jpg',65)
insert into SkuPicture values('A34-041-0F4_10.jpg',65)
insert into SkuPicture values('S85-432-0O0_1.jpg',66)
insert into SkuPicture values('S85-432-0O0_2.jpg',66)
insert into SkuPicture values('S85-432-0O0_3.jpg',66)
insert into SkuPicture values('S85-432-0O0_4.jpg',66)
insert into SkuPicture values('S85-432-0O0_5.jpg',66)
insert into SkuPicture values('S85-432-0O0_1.jpg',67)
insert into SkuPicture values('S85-432-0O0_2.jpg',67)
insert into SkuPicture values('S85-432-0O0_3.jpg',67)
insert into SkuPicture values('S85-432-0O0_4.jpg',67)
insert into SkuPicture values('S85-432-0O0_5.jpg',67)
insert into SkuPicture values('S85-432-0O0_1.jpg',68)
insert into SkuPicture values('S85-432-0O0_2.jpg',68)
insert into SkuPicture values('S85-432-0O0_3.jpg',68)
insert into SkuPicture values('S85-432-0O0_4.jpg',68)
insert into SkuPicture values('S85-432-0O0_5.jpg',68)
insert into SkuPicture values('S85-432-0O0_1.jpg',69)
insert into SkuPicture values('S85-432-0O0_2.jpg',69)
insert into SkuPicture values('S85-432-0O0_3.jpg',69)
insert into SkuPicture values('S85-432-0O0_4.jpg',69)
insert into SkuPicture values('S85-432-0O0_5.jpg',69)
insert into SkuPicture values('S85-458-0OI_1.jpg',70)
insert into SkuPicture values('S85-458-0OI_2.jpg',70)
insert into SkuPicture values('S85-458-0OI_3.jpg',70)
insert into SkuPicture values('S85-458-0OI_4.jpg',70)
insert into SkuPicture values('S85-458-0OI_5.jpg',70)
insert into SkuPicture values('S85-458-0OI_1.jpg',71)
insert into SkuPicture values('S85-458-0OI_2.jpg',71)
insert into SkuPicture values('S85-458-0OI_3.jpg',71)
insert into SkuPicture values('S85-458-0OI_4.jpg',71)
insert into SkuPicture values('S85-458-0OI_5.jpg',71)
insert into SkuPicture values('S85-458-0OI_1.jpg',72)
insert into SkuPicture values('S85-458-0OI_2.jpg',72)
insert into SkuPicture values('S85-458-0OI_3.jpg',72)
insert into SkuPicture values('S85-458-0OI_4.jpg',72)
insert into SkuPicture values('S85-458-0OI_5.jpg',72)
insert into SkuPicture values('S85-458-0OI_1.jpg',73)
insert into SkuPicture values('S85-458-0OI_2.jpg',73)
insert into SkuPicture values('S85-458-0OI_3.jpg',73)
insert into SkuPicture values('S85-458-0OI_4.jpg',73)
insert into SkuPicture values('S85-458-0OI_5.jpg',73)
insert into SkuPicture values('A85-345-0GL.jpg',74)
insert into SkuPicture values('A85-345-0GL_02.jpg',74)
insert into SkuPicture values('A85-345-0GL_05.jpg',74)
insert into SkuPicture values('A85-345-0GL_03.jpg',74)
insert into SkuPicture values('A85-345-0GL_04.jpg',74)
insert into SkuPicture values('A85-345-0GL.jpg',75)
insert into SkuPicture values('A85-345-0GL_02.jpg',75)
insert into SkuPicture values('A85-345-0GL_05.jpg',75)
insert into SkuPicture values('A85-345-0GL_03.jpg',75)
insert into SkuPicture values('A85-345-0GL_04.jpg',75)
insert into SkuPicture values('A85-345-0GL.jpg',76)
insert into SkuPicture values('A85-345-0GL_02.jpg',76)
insert into SkuPicture values('A85-345-0GL_05.jpg',76)
insert into SkuPicture values('A85-345-0GL_03.jpg',76)
insert into SkuPicture values('A85-345-0GL_04.jpg',76)
insert into SkuPicture values('A85-345-0GL.jpg',77)
insert into SkuPicture values('A85-345-0GL_02.jpg',77)
insert into SkuPicture values('A85-345-0GL_05.jpg',77)
insert into SkuPicture values('A85-345-0GL_03.jpg',77)
insert into SkuPicture values('A85-345-0GL_04.jpg',77)
insert into SkuPicture values('A85-241-0GA_1.jpg',78)
insert into SkuPicture values('A85-241-0GA_4.jpg',78)
insert into SkuPicture values('A85-241-0GA_5.jpg',78)
insert into SkuPicture values('A85-241-0GA_2.jpg',78)
insert into SkuPicture values('A85-241-0GA_3.jpg',78)
insert into SkuPicture values('A85-241-0GA_1.jpg',79)
insert into SkuPicture values('A85-241-0GA_4.jpg',79)
insert into SkuPicture values('A85-241-0GA_5.jpg',79)
insert into SkuPicture values('A85-241-0GA_2.jpg',79)
insert into SkuPicture values('A85-241-0GA_3.jpg',79)
insert into SkuPicture values('A85-241-0GA_1.jpg',80)
insert into SkuPicture values('A85-241-0GA_4.jpg',80)
insert into SkuPicture values('A85-241-0GA_5.jpg',80)
insert into SkuPicture values('A85-241-0GA_2.jpg',80)
insert into SkuPicture values('A85-241-0GA_3.jpg',80)
insert into SkuPicture values('A85-345-0EO_1.jpg',81)
insert into SkuPicture values('A85-345-0EO_2.jpg',81)
insert into SkuPicture values('A85-345-0EO_3.jpg',81)
insert into SkuPicture values('A85-345-0EO_4.jpg',81)
insert into SkuPicture values('A85-345-0EO_5.jpg',81)
insert into SkuPicture values('A85-345-0EO_1.jpg',82)
insert into SkuPicture values('A85-345-0EO_2.jpg',82)
insert into SkuPicture values('A85-345-0EO_3.jpg',82)
insert into SkuPicture values('A85-345-0EO_4.jpg',82)
insert into SkuPicture values('A85-345-0EO_5.jpg',82)
insert into SkuPicture values('A85-345-0EO_1.jpg',83)
insert into SkuPicture values('A85-345-0EO_2.jpg',83)
insert into SkuPicture values('A85-345-0EO_3.jpg',83)
insert into SkuPicture values('A85-345-0EO_4.jpg',83)
insert into SkuPicture values('A85-345-0EO_5.jpg',83)
go

--Recomment 推荐表 11
Create table ReComment
(
ReCommentId int primary key identity(1,1),--推荐表ID
ReCommentType varchar(300),--推荐类型
)
insert into ReComment values ('热卖推荐')
insert into ReComment values ('同类热销')
go

Create table RecommentSkuDetai
(
ReCommentId int foreign key references ReComment(RecommentId),--推荐表ID
SkuId int foreign key references Sku(SkuId),--SkuId
primary key(ReCommentId,SkuId),--联合主键
RecommentPrice numeric(8,2)not null,--热卖推荐价格
)
insert into RecommentSkuDetai values(1,1,248.00)
insert into RecommentSkuDetai values(1,4,540.00)
insert into RecommentSkuDetai values(1,8,720.00)

---同类热销---

insert into RecommentSkuDetai values(2,1,269.00)
insert into RecommentSkuDetai values(2,4,789.00)
insert into RecommentSkuDetai values(2,8,844.00)
insert into RecommentSkuDetai values(2,12,794.00)
insert into RecommentSkuDetai values(2,16,899.00)
insert into RecommentSkuDetai values(2,19,226.00)
insert into RecommentSkuDetai values(2,25,298.00)
insert into RecommentSkuDetai values(2,29,889.00)
go
--注册表--

create table Registration
(
RegisterId int primary key identity(1,1),
RegisterEmail varchar(30),
RegisterPassword varchar(12) not null,
IsActive bit,
RegisterTime smalldatetime,
)
--购物车--
create table ShoppingCart
(
SkuId int foreign key references Sku(SkuId),--skuId 外键
RegisterId int foreign key references Registration(RegisterId),--注册表Id外键
primary key(SkuId,RegisterId),--联合主键
BuyCommodityQuantity int,--数量
)
go
--收藏夹--
create table MyCollection
(
SkuId int foreign key references Sku(SkuId),--SkuId外键
RegisterId int foreign key references Registration(RegisterId),--注册表ID外键
primary key(SkuId,RegisterId),--联合主键
MyStoreTime DateTime,--收藏时间
)
go

Create table PayType --支付类型
(
PayTypeId int primary key identity(1,1),--支付类型ID
PayTypeValue varchar(30),--支付类型
)
insert into PayType values('在线支付')
insert into PayType values('现金支付')
insert into PayType values('银行电汇')
go
Create table PayWay --支付方式
(
PayWayId int primary key identity(1,1),
PayWayValue varchar(30),--支付方式
PayWayImg varchar(30),--支付图片
PayTypeId int foreign key references PayType(PayTypeId),--引用支付类型ID外键
)

insert into PayWay values('支付宝','brand_127X40_194.gif',1)
insert into PayWay values('中国建设银行','brand_127X40_208.gif',1)
insert into PayWay values('交通银行','brand_127X40_201.gif',1)
insert into PayWay values('浦发银行','brand_127X40_202.gif',1)
insert into PayWay values('广东发展银行','brand_127X40_203.gif',1)
insert into PayWay values('中信银行','brand_127X40_204.gif',1)
insert into PayWay values('深圳发展银行','brand_127X40_205.gif',1)
insert into PayWay values('中国工商银行','brand_127X40_206.gif',1)
insert into PayWay values('招商银行','brand_127X40_197.gif',1)
insert into PayWay values('中国银行','brand_127X40_199.gif',1)
insert into PayWay values('中国农业','brand_127X40_200.gif',1)
insert into PayWay values('货到付款','',2)
insert into PayWay values('银行电汇','',3)
go

Create table SendWay --配送方式
(
SendWayId int primary key identity(1,1),
SendWayName varchar(300),--配送方式
SendDescribe varchar(300),--配送描述
)
insert into SendWay values('中国邮政','邮政-商务投递')
insert into SendWay values('申通快递','申通快递')
insert into SendWay values('圆通快递','圆通快递')
insert into SendWay values('顺风速运','顺风速运')

go

Create table ConsigneeInfo --收货地址
(
ConsigneeId int primary key identity(1,1),--收货人详情ID
ConsigneeAddressName varchar(300),--收货地址名称
ConsigneeName varchar(300) not null,--收货人姓名
ConsigneeProvinceAddress varchar(500) not null,--所在地区
ConsigneeAddress varchar(500) not null,--联系地址
MoboPhone varchar(11),--手机
TelePhone varchar(15),--联系电话
ConsigneePostcode varchar(6),--邮编
Isdefault bit,--是否默认收货地址
RegisterId int foreign key references Registration(RegisterId),--用户ID外键
)

Create table Coupon --优惠券or实物券
(
CouponId int primary key identity(1,1),
CouponNumber varchar(100),--优惠券号码
CouponType varchar(100),--优惠券类别
CouponMoney decimal(8,2),--面值
CouponState varchar(30),--优惠券状态
CouponTime DateTime,--优惠券生效期
DeadTime DateTime,--优惠券失效日期
CouponRemark varchar(300),--优惠券说明
RegisterId int foreign key references Registration(RegisterId),--用户ID外键
)

Create table CoalitionOrders --合并订单
(
CoalitionOrdersId int primary key identity(1,1),
CoalitionOrdersNumber varchar(30),--合并的订单号
CoalitionOrdersMoney decimal(10,2),--订单总金额
CoalitionOrdersState varchar(300),--订单状态
)

Create table Orders
(
OrderId int primary key identity(1,1),--订单号Id
OrderNumber varchar(300),--订单号
OrderState varchar(30),--订单状态
OrderType varchar(30),--订单类型
OrderTime DateTime,--订单时间
OrderFirm varchar(300),--商品厂家
OrderMoney decimal(8,2),--订单金额
SendWayMoney decimal(8,2),--订单运费
RegisterId int foreign key references Registration(RegisterId),--引用用户ID为外键
CoalitionOrdersId int foreign key references CoalitionOrders(CoalitionOrdersId),--引用合并订单ID为外键
--ConsigneeId int foreign key references ConsigneeInfo(ConsigneeId),--引用收货地址ID为外键
ConsigneeId int,--引用收货地址ID为外键
PayWayId int foreign key references PayWay(PayWayId),--引用支付方式Id为外键
SendWayId int foreign key references SendWay(SendWayId),--配送方式ID外键
CouponId int,--优惠券Id外键
)

Create table OrderDetail --订单详情
(
OrderDetailId int primary key identity(1,1),--订单详情ID
SkuId int,--SkuId
OrderSKUPrice decimal(8,2),--订单商品价格
OrderCommodityQuantity int,--订单商品数量
OrderId int foreign key references Orders(OrderId),--引用订单ID为外键
)
Create table InvoiceInfo --发票信息
(
InvoiceId int primary key identity(1,1),
InvoiceType varchar(30),--发票类型
InvoiceHeader varchar(300),--发票抬头
CompanyName varchar(300),--公司名称
CompanyAddress varchar(300),--公司地址
TaxRegistryNo varchar(30),--税务登记号
BankAccount varchar(30),--开户银行及帐号
MailingAddress varchar(300),--发票寄送地址
OrderId int foreign key references Orders(OrderId),--引用订单ID为外键
RegisterId int foreign key references Registration(RegisterId),--引用用户Id为外键
)

 

转载于:https://www.cnblogs.com/simpleBlue3/p/3893614.html