商城系统mysql数据表设计_商城数据库表设计介绍

/*Navicat MySQL Data Transfer

Source Server : yc

Source Server Version : 50726

Source Host : 47.100.224.4:3306

Source Database : ycshop

Target Server Type : MYSQL

Target Server Version : 50726

File Encoding : 65001

Date: 2019-05-24 17:30:35*/

SET FOREIGN_KEY_CHECKS=0;--------------------------------Table structure for cart------------------------------

DROP TABLE IF EXISTS`cart`;CREATE TABLE`cart` (

`carid`varchar(64) NOT NULL,

`userid`varchar(64) DEFAULT NULL COMMENT '用户表id',

`proid`varchar(64) DEFAULT NULL COMMENT '商品id',

`quantity`int(11) DEFAULT NULL COMMENT '数量',

`checked`int(11) DEFAULT NULL COMMENT '是否选择,1=已勾选,0=未勾选',

`createtime`datetime DEFAULT NULL COMMENT '创建时间',

`updatetime`datetime DEFAULT NULL COMMENT '更新时间',PRIMARY KEY(`carid`),KEY`FK_Reference_2` (`userid`),KEY`FK_Reference_3` (`proid`),CONSTRAINT `FK_Reference_2` FOREIGN KEY (`userid`) REFERENCES `user` (`userid`),CONSTRAINT `FK_Reference_3` FOREIGN KEY (`proid`) REFERENCES`product` (`proid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;--------------------------------Records of cart------------------------------

--------------------------------Table structure for category------------------------------

DROP TABLE IF EXISTS`category`;CREATE TABLE`category` (

`cateid`varchar(64) NOT NULL COMMENT '类别Id',

`parentid`varchar(64) DEFAULT NULL COMMENT '父类别id当id=0时说明是根节点,一级类别',

`name`varchar(50) DEFAULT NULL COMMENT '类别名称',

`status`int(1) DEFAULT '1' COMMENT '类别状态1-正常,2-已废弃',

`sortorder`int(4) DEFAULT NULL COMMENT '排序编号,同类展示顺序,数值相等则自然排序',