succbak/P443发版备份/P443发版前/测试环境/新增的表结构/dwd_d_userbase_source_code.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 正式环境
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 127.0.0.1:27083
 Source Schema         : jianyu_subjectdb_test

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 20/01/2024 10:21:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dwd_d_userbase_source_code
-- ----------------------------
DROP TABLE IF EXISTS `dwd_d_userbase_source_code`;
CREATE TABLE `dwd_d_userbase_source_code`  (
  `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '分类代码',
  `pcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '父级代码',
  `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分类级别',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '分类名称',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '备注',
  PRIMARY KEY (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户来源维表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;