商家店鋪表
* * * * *
CREATe TABLE `ke_shops` (
shopId int(11) unsigned not null auto_increment,
shopName varchar(20) not null,
userId int(11) not null,
telephone varchar(20) not null,
shopImg varchar(150) default null,
areaId int(11) default null,
areaIdPath varchar(255) default null,
primary key (`shopId`)
) ENGINE=InnoDB default CHARSET=UTF8;
店鋪各個積分表
* * * * *
CREATE TABLE `ke_shop_score` (
scoreId int(11) unsigned not null auto_increment,
shopId int(11) not null,
totalScore int(11) not null default '0',
goodsScore int(11) not null default '0',
primary key (`scoreId`),
UNIQUE KEY `shopId` (`shopId`) USING BTREE
) ENGINE=InnoDB default CHARSET=UTF8;
運費重量表
* * * * *
CREATE TABLE `ke_shop_feight` (
feightId int(11) unsigned not null auto_increment,
shopId int(11) not null,
areaId int(11) not null,
freight int(11) not null,
createTime datetime not null,
primary key (`feightId`),
unique key `shopId`(`shopId`, `areaId`)
) ENGINE=InnoDB default CHARSET=UTF8;
