一个小时学会MySQL数据库 - 张果(7)_H5之家 - 中国HTML5教程资源分享第一站

Address; ArticleComment; ArticleType; Articles; DictSub; DictTop; OrderPdt; Orders; ProductComment; Products; Users; Address ( `AddressId` auto_increment comment , `UserId` comment , `Province` , `City` , `County` , `Street` , `RevName` , `PostCode` , `Mobile` , `Phone` , `IsDefault` bool comment , primary key (AddressId) ); ; ArticleComment ( `ArticleCommentId` auto_increment comment , `ArticleId` comment , `UserId` comment , `ArticleCommentContent` , `ArticleCommentDate` comment , `ArticleCommentState` comment , `ArticleRemark` , `ArticleCommentReserver1` , `ArticleCommentReserver2` , primary key (ArticleCommentId) ); ; ArticleType ( `ArticleTypeId` auto_increment comment , `ArticleTypeName` , `ArticleTypeState` comment , `ArticleTypeDesc` , `ArticleTypePicture` , `ArticleTypeReserve1` , `ArticleTypeReserve2` , primary key (ArticleTypeId) ); ; Articles ( `ArticleId` auto_increment comment , `ArticleTypeId` comment , `ArticleTitle` , `ArticleContent` , `ArticleDate` comment , `ArticleAuthor` , `ArticleFileName` , `ArticleThumbNail` , `ArticleAddition` , `ArticleLevel` , `ArticleIsAllowComment` comment , `ArticleState` comment , `ArticleHotCount` , `ArticleReserve1` , `ArticleReserve2` , `ArticleReserve3` numeric(, primary key (ArticleId) ); ; DictSub ( `SubId` auto_increment comment , `DictId` comment , `SubName` , `SubDesc` , `SubReserve1` , primary key (SubId) ); ; DictTop ( `DictId` auto_increment comment , `DictName` , `DictDesc` , `DictReserve1` , primary key (DictId) ); ; OrderPdt ( `OrderPdtId` auto_increment comment , `Id` comment , `UserId` comment , `OrderId` , `PdtAmount` , `PdtPrice` , `PdtReserve1` , `PdtReserve2` , primary key (OrderPdtId) ); ; Orders ( `OrderId` auto_increment comment , `AddressId` comment , `OrderState` comment , `ExpressNO` , `ExpressName` , `PayMoney` , `PayedMoney` , `SendInfo` , `BuyDate` comment , `PayDate` , `SendDate` , `ReceivDate` , `OrderMessage` , `UserId` , `OrderReserve1` , `OrderReserve2` , `OrderReserve3` , primary key (OrderId) ); ; ProductComment ( `ProductCommentId` auto_increment comment , `ProductId` comment , `UserId` comment , `ProductCommentContent` , `ProductCommentDate` comment , `ProductCommentState` , `ProductCommentRemark` , `ProductCommentReserve1` , `ProductCommentReserve2` , primary key (ProductCommentId) ); ; Products ( `Id` auto_increment comment , `Name` , `SubIdColor` comment , `SubIdBrand` comment , `SubIdInlay` comment , `SubIdMoral` comment , `SubIdMaterial` comment , `SubIdTopLevel` comment , `MarketPrice` , `MyPrice` comment , `Discount` comment , `Picture` , `Amount` , `Description` , `State` comment , `AddDate` comment , `Hang` , `RawStone` , `Size` , `ExpressageName` , `Expressage` , `AllowComment` comment , `Reserve1` , `Reserve2` , `Reserve3` , primary key (Id) ); ; Users ( `UserId` auto_increment comment , `UserName` , `Password` , `Email` , `Sex` , `State` comment , `RightCode` , `RegDate` comment , `RegIP` , `LastLoginDate` , `UserReserve1` , `UserReserve2` , `UserReserve3` , primary key (UserId) ); ; FK_AddressBelongUser foreign key (UserId) ; FK_ArticleCommentForArticle foreign key (ArticleId) ; FK_ArticleCommentForUser foreign key (UserId) ; FK_ArticleBelongType foreign key (ArticleTypeId) ; FK_BelongDict foreign key (DictId) ; FK_BelongOrder foreign key (OrderId) ; FK_CartForUser foreign key (UserId) ; FK_OrderDepProduct foreign key (Id) ; FK_OrderBelongAddress foreign key (AddressId) ; FK_ProductCommentBelongUsers foreign key (UserId) ; FK_ProductCommentForProduct foreign key (ProductId) ; FK_BelongBrand foreign key (SubIdMaterial) ; FK_BelongColor foreign key (SubIdBrand) ; FK_BelongInlay foreign key (SubIdInlay) ; FK_BelongMaterial foreign key (SubIdColor) ; FK_BelongMoral foreign key (SubIdTopLevel) ; FK_BelongTopLevel foreign key (SubIdMoral) ;