细化迭代3 UC1,UC2相关的数据库设计

1、客户表

DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Memberlevel` int(4) NOT NULL,
  `LoginName` char(12) DEFAULT NULL,
  `LoginPwd` char(12) DEFAULT NULL,
  `MemberName` char(20) DEFAULT NULL,
  `Phone` char(15) DEFAULT NULL,
  `Address` varchar(100) DEFAULT NULL,
  `Zip` char(10) DEFAULT NULL,
  `RegDate` datetime DEFAULT NULL,
  `LastDate` datetime DEFAULT NULL,
  `LoginTimes` int(4) DEFAULT NULL,
  `EMail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

2、客户级别表

DROP TABLE IF EXISTS `memberlevel`;
CREATE TABLE `memberlevel` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `LevelName` char(20) DEFAULT NULL,
  `Favourable` int(4) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

3、商品类别表

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `CateName` char(40) DEFAULT NULL,
  `CateDesc` text,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

4、商品表

DROP TABLE IF EXISTS `merchandise`;
CREATE TABLE `merchandise` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Category` int(4) NOT NULL,
  `MerName` char(40) DEFAULT NULL,
  `Price` decimal(8,2) DEFAULT NULL,
  `SPrice` decimal(8,2) DEFAULT NULL,
  `MerModel` char(40) DEFAULT NULL,
  `Picture` varchar(100) DEFAULT NULL,
  `MerDesc` text,
  `Manufacturer` char(60) DEFAULT NULL,
  `LeaveFactoryDate` datetime DEFAULT NULL,
  `Special` int(4) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;

5、订单明细表

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Member` int(4) NOT NULL,
  `Cart` int(4) NOT NULL,
  `OrderNO` char(20) DEFAULT NULL,
  `OrderDate` datetime DEFAULT NULL,
  `OrderStatus` int(4) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=gb2312;

6、系统用户表

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `AdminType` int(4) DEFAULT NULL,
  `AdminName` char(12) DEFAULT NULL,
  `LoginName` char(12) DEFAULT NULL,
  `LoginPwd` char(12) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

转载于:https://my.oschina.net/qt2015/blog/410329