MySQL DDL练习(15-20)

最新推荐文章于 2024-09-12 18:05:56 发布

koiHHHH

最新推荐文章于 2024-09-12 18:05:56 发布

阅读量142

点赞数 3

文章标签： mysql java 前端

本文链接：https://blog.csdn.net/koiHHHH/article/details/138308961

版权

DDL

CREATE TABLE `xiaolaodi_cats`  (
  `catld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `catName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据分类名称',
  `dataFlag` tinyint(4) NULL DEFAULT 1 COMMENT '有效标志(1：有效 -1：删除)',
  `catCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类表标记字母',
  PRIMARY KEY (`catld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DDL

CREATE TABLE `xiaolaodi_datas`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `catld` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
  `dataName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据名称',
  `dataVal` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据值',
  `dataSort` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `dataFlag` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '有效标记(1：有效 -1：删除)',
  `subCatld` int(11) NULL DEFAULT 0 COMMENT '子分类ID',
  `subDateVal` int(11) NULL DEFAULT 0 COMMENT '子分类数据内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DDL

CREATE TABLE `xiaolaodi_express`  (
  `expressld` int(11) NOT NULL COMMENT '自增ID',
  `expressName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '快递名称',
  `dataFlag` tinyint(4) NOT NULL DEFAULT 1 COMMENT '删除标志（1：有效 -1：删除）',
  `expressCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递代码（主要用于物流插件）',
  `isShow` tinyint(4) NULL DEFAULT 1 COMMENT '是否启用（1：是 0：否）',
  PRIMARY KEY (`expressld`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DDL

CREATE TABLE `xiaolaodi_facorites`  (
  `facoriteld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `userld` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `createTime` datetime(0) NOT NULL COMMENT '创建时间',
  `goodsld` int(11) NULL DEFAULT NULL COMMENT '商品ID',
  `currShopPrice` decimal(11, 2) NOT NULL COMMENT '关注时的价格',
  PRIMARY KEY (`facoriteld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DDL

CREATE TABLE `xiaolaodi_items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `chargeMoney` int(11) NULL DEFAULT 0 COMMENT '充值金额',
  `giveMoney` decimal(11, 1) NULL DEFAULT NULL COMMENT '赠送金额',
  `itemSort` int(11) NULL DEFAULT 0 COMMENT '排序号',
  `dataFlag` tinyint(4) NULL DEFAULT 1 COMMENT '是否有效(1：有效 -1：删除)',
  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DDL

DROP TABLE IF EXISTS `xiaolaodi_shops`;
CREATE TABLE `marry_shops`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `shopld` int(11) NOT NULL DEFAULT 0 COMMENT '店铺ID',
  `catld` int(11) NOT NULL DEFAULT 0 COMMENT '所属分类ID',
  `commissionRate` decimal(11, 2) NULL DEFAULT NULL COMMENT '商家店铺分类佣金比例',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;