[
{
"表名" : "ad",
"列名" : "AD_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "ad",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "URL",
"数据类型" : "varchar(300)",
"列描述" : "广告图片地址"
},
{
"表名" : "ad",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "广告图点击后的内容"
},
{
"表名" : "ad",
"列名" : "LINK_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "广告图点击后跳转的类型(文章, 商品)"
},
{
"表名" : "ad",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "广告图关联的商品品类"
},
{
"表名" : "ad",
"列名" : "LOCATION",
"数据类型" : "varchar(45)",
"列描述" : "广告图位置:首页和商品分类页"
},
{
"表名" : "ad",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "admin",
"列名" : "ADMIN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "admin",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : "是否删除"
},
{
"表名" : "admin",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "记录创建时间"
},
{
"表名" : "admin",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录创建人员"
},
{
"表名" : "admin",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : "最近一次更新时间"
},
{
"表名" : "admin",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "最近一次更新人员"
},
{
"表名" : "admin",
"列名" : "EMAIL",
"数据类型" : "varchar(40)",
"列描述" : "电子邮箱地址"
},
{
"表名" : "admin",
"列名" : "ID",
"数据类型" : "varchar(30)",
"列描述" : "用户ID"
},
{
"表名" : "admin",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "admin",
"列名" : "PASSWORD",
"数据类型" : "varchar(100)",
"列描述" : "密码(MD5)"
},
{
"表名" : "admin",
"列名" : "LASTLOGINTIME",
"数据类型" : "timestamp",
"列描述" : "最近一次登录时间"
},
{
"表名" : "admin",
"列名" : "FAILCOUNT",
"数据类型" : "int(11)",
"列描述" : "登录失败次数"
},
{
"表名" : "admin",
"列名" : "ISLOCKED",
"数据类型" : "tinyint(1)",
"列描述" : "是否锁定"
},
{
"表名" : "admin",
"列名" : "SUCCESSCOUNT",
"数据类型" : "int(11)",
"列描述" : "总登录次数"
},
{
"表名" : "admin",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "手机号码"
},
{
"表名" : "admin_role",
"列名" : "ADMINROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "admin_role",
"列名" : "ADMIN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "后台管理人员ID"
},
{
"表名" : "admin_role",
"列名" : "ROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "角色ID"
},
{
"表名" : "admin_role",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : "是否删除"
},
{
"表名" : "admin_role",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "记录创建时间"
},
{
"表名" : "admin_role",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录创建人员"
},
{
"表名" : "admin_role",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : "记录最后一次更新时间"
},
{
"表名" : "admin_role",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录最后一次更新人员"
},
{
"表名" : "admin_token",
"列名" : "ADMINTOKEN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "admin_token",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : "是否删除"
},
{
"表名" : "admin_token",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "记录创建时间"
},
{
"表名" : "admin_token",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录创建人员"
},
{
"表名" : "admin_token",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : "记录最近更新时间"
},
{
"表名" : "admin_token",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录最近更新人员"
},
{
"表名" : "admin_token",
"列名" : "ADMIN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "后台管理人员ID"
},
{
"表名" : "admin_token",
"列名" : "TOKENID",
"数据类型" : "varchar(36)",
"列描述" : "登录token"
},
{
"表名" : "admin_token",
"列名" : "LOGINTIME",
"数据类型" : "timestamp",
"列描述" : "登录时间"
},
{
"表名" : "admin_token",
"列名" : "EXPIRETIME",
"数据类型" : "timestamp",
"列描述" : "token过期时间"
},
{
"表名" : "application",
"列名" : "APPLICATION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "application",
"列名" : "APPLICATION_NAME",
"数据类型" : "varchar(60)",
"列描述" : "功能名称"
},
{
"表名" : "application",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "application",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "application",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "application",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "application",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "application",
"列名" : "APPLICATION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "功能编码"
},
{
"表名" : "application",
"列名" : "APPLICATION_DESC",
"数据类型" : "varchar(200)",
"列描述" : "功能描述"
},
{
"表名" : "application",
"列名" : "ROOTAPPLICATION",
"数据类型" : "varchar(45)",
"列描述" : "暂不使用"
},
{
"表名" : "area",
"列名" : "AREA_ID",
"数据类型" : "varchar(32)",
"列描述" : "主键ID"
},
{
"表名" : "area",
"列名" : "PARENT_ID",
"数据类型" : "varchar(32)",
"列描述" : "父级ID"
},
{
"表名" : "area",
"列名" : "DEPTH",
"数据类型" : "int(11)",
"列描述" : "地区深度"
},
{
"表名" : "area",
"列名" : "NAME",
"数据类型" : "varchar(32)",
"列描述" : "地区名称"
},
{
"表名" : "area",
"列名" : "POSTAL_CODE",
"数据类型" : "varchar(45)",
"列描述" : "邮政编码"
},
{
"表名" : "area",
"列名" : "SORT",
"数据类型" : "int(11)",
"列描述" : "地区排序"
},
{
"表名" : "article",
"列名" : "ARTICLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "article",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "article",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "内容"
},
{
"表名" : "article",
"列名" : "TITLE",
"数据类型" : "varchar(200)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "COVERIMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图"
},
{
"表名" : "article",
"列名" : "MEDIA_ID",
"数据类型" : "varchar(200)",
"列描述" : "微信公众号文章media_id"
},
{
"表名" : "article",
"列名" : "IS_FROM_OFFICIALACCOUNT",
"数据类型" : "tinyint(1)",
"列描述" : "是否引用公众号文章"
},
{
"表名" : "article",
"列名" : "LINK_TYPE",
"数据类型" : "varchar(50)",
"列描述" : "链接类型"
},
{
"表名" : "article",
"列名" : "PUBLISH_TIME",
"数据类型" : "timestamp",
"列描述" : "发布时间"
},
{
"表名" : "article",
"列名" : "DIGEST",
"数据类型" : "varchar(200)",
"列描述" : "摘要"
},
{
"表名" : "article",
"列名" : "NUMBER_OF_READING",
"数据类型" : "int(11)",
"列描述" : "浏览次数"
},
{
"表名" : "article",
"列名" : "ISPUBLISHED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发布"
},
{
"表名" : "article",
"列名" : "ARTICLE_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "内容类型(1-文案,2-音频,3-视频,4-官方资讯,5-活动通知)"
},
{
"表名" : "coupon",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "coupon",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "coupon",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon",
"列名" : "NAME",
"数据类型" : "varchar(45)",
"列描述" : "优惠券名称"
},
{
"表名" : "coupon",
"列名" : "TYPE",
"数据类型" : "varchar(45)",
"列描述" : "优惠现金或折扣(DISCOUNT, CASH)"
},
{
"表名" : "coupon",
"列名" : "VALID_START_DATE",
"数据类型" : "date",
"列描述" : "有效期开始日期"
},
{
"表名" : "coupon",
"列名" : "VALID_END_DATE",
"数据类型" : "date",
"列描述" : "有效期结束日期"
},
{
"表名" : "coupon",
"列名" : "TOTALCOUNT",
"数据类型" : "int(11)",
"列描述" : "发放数量"
},
{
"表名" : "coupon",
"列名" : "AVAILABLECOUNT",
"数据类型" : "int(11)",
"列描述" : "可用数量"
},
{
"表名" : "coupon",
"列名" : "LIMITPERUSER",
"数据类型" : "int(11)",
"列描述" : "每人限领数量"
},
{
"表名" : "coupon",
"列名" : "COUPONCODE",
"数据类型" : "varchar(45)",
"列描述" : "优惠券编号"
},
{
"表名" : "coupon",
"列名" : "BENEFIT_CASH",
"数据类型" : "decimal(10,2)",
"列描述" : "优惠金额"
},
{
"表名" : "coupon",
"列名" : "BENEFIT_DISCOUNT",
"数据类型" : "decimal(10,2)",
"列描述" : "优惠折扣"
},
{
"表名" : "coupon",
"列名" : "CONDITION_AMOUNT",
"数据类型" : "decimal(10,2)",
"列描述" : "满多少可使用"
},
{
"表名" : "coupon",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否发放"
},
{
"表名" : "coupon",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(45)",
"列描述" : "发放门店(B2C商城暂时未空)"
},
{
"表名" : "coupon",
"列名" : "VALID_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "1-指定有效期, 2-领取后N天有效"
},
{
"表名" : "coupon",
"列名" : "VALID_DAYS",
"数据类型" : "int(11)",
"列描述" : "领取后N天有效"
},
{
"表名" : "coupon",
"列名" : "BENEFIT_TYPE",
"数据类型" : "tinyint(1)",
"列描述" : "0-所有商品可用,1-指定商品可用"
},
{
"表名" : "coupon",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "描述"
},
{
"表名" : "coupon",
"列名" : "IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "优惠券图片"
},
{
"表名" : "coupon_order",
"列名" : "COUPONORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "coupon_order",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "coupon_order",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_order",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_order",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_order",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_order",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "用户ID"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "优惠券ID"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_ORDER_TIME",
"数据类型" : "timestamp",
"列描述" : "优惠券购买时间"
},
{
"表名" : "coupon_order",
"列名" : "TYPE",
"数据类型" : "varchar(45)",
"列描述" : "优惠券类型(满减, 折扣)"
},
{
"表名" : "coupon_order",
"列名" : "VALID_START_DATE",
"数据类型" : "timestamp",
"列描述" : "有效开始时间"
},
{
"表名" : "coupon_order",
"列名" : "VALID_END_DATE",
"数据类型" : "timestamp",
"列描述" : "有效结束时间"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_DESC",
"数据类型" : "varchar(500)",
"列描述" : "优惠券描述"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_UNIT",
"数据类型" : "int(11)",
"列描述" : "优惠券数量"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_POINT",
"数据类型" : "int(11)",
"列描述" : "优惠券所需积分"
},
{
"表名" : "coupon_order",
"列名" : "ACTUAL_POINT",
"数据类型" : "int(11)",
"列描述" : "优惠券实际支付积分"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图地址"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_NAME",
"数据类型" : "varchar(45)",
"列描述" : "优惠券名称"
},
{
"表名" : "coupon_product",
"列名" : "COUPONPRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "coupon_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "coupon_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "coupon_product",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "优惠券ID"
},
{
"表名" : "coupon_writeoff",
"列名" : "COUPONWRITEOFF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "coupon_writeoff",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "coupon_writeoff",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_writeoff",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_writeoff",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_writeoff",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_writeoff",
"列名" : "USERCOUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "用户优惠券关系ID"
},
{
"表名" : "coupon_writeoff",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "coupon_writeoff",
"列名" : "COUPON_WRITE_OFF_TIME",
"数据类型" : "timestamp",
"列描述" : "核销时间"
},
{
"表名" : "file",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "file",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "file",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "file",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "file",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "file",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "file",
"列名" : "FILE_NAME",
"数据类型" : "varchar(100)",
"列描述" : "文件名称"
},
{
"表名" : "file",
"列名" : "SIZE",
"数据类型" : "int(11)",
"列描述" : "文件大小"
},
{
"表名" : "file",
"列名" : "OSS_KEY",
"数据类型" : "varchar(200)",
"列描述" : "暂不使用"
},
{
"表名" : "file",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : "文件地址"
},
{
"表名" : "function",
"列名" : "FUNCTION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "function",
"列名" : "FUNCTION_NAME",
"数据类型" : "varchar(60)",
"列描述" : "功能名称"
},
{
"表名" : "function",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "function",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "function",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "function",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "function",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "function",
"列名" : "APPLICATION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "关联的一级功能ID"
},
{
"表名" : "function",
"列名" : "FUNCTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "功能代码"
},
{
"表名" : "function",
"列名" : "FUNCTION_DESC",
"数据类型" : "varchar(200)",
"列描述" : "功能描述"
},
{
"表名" : "global_setting",
"列名" : "GLOBAL_SETTING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_LOGO",
"数据类型" : "varchar(500)",
"列描述" : "应用Logo"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_NAME",
"数据类型" : "varchar(100)",
"列描述" : "应用名称"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_DESC",
"数据类型" : "varchar(400)",
"列描述" : "应用描述"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_DOMAIN_NAME",
"数据类型" : "varchar(100)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_VERSION",
"数据类型" : "varchar(45)",
"列描述" : "应用版本号"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_PUBLIC_REGISTER_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启公开注册(不需要邀请)"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_MERCHANT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "WECHAT_MERCHANT_ID",
"数据类型" : "varchar(100)",
"列描述" : "微信商户号"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_APP_ID_OFFICIAL_ACCOUNT",
"数据类型" : "varchar(100)",
"列描述" : "微信公众号APPID"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_APP_SECRET_OFFICIAL_ACCOUNT",
"数据类型" : "varchar(100)",
"列描述" : "微信公众号APPSECRET"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_APP_ID_MINI_PROGRAM",
"数据类型" : "varchar(100)",
"列描述" : "微信小程序APPID"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_APP_SECRET_MINI_PROGRAM",
"数据类型" : "varchar(100)",
"列描述" : "微信小程序APPSECRET"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_API_KEY",
"数据类型" : "varchar(100)",
"列描述" : "微信API秘钥"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_NOTIFY_URL",
"数据类型" : "varchar(200)",
"列描述" : "微信支付回调地址"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_REFUND_NOTIFY_URL",
"数据类型" : "varchar(200)",
"列描述" : "微信退款回调地址"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_APP_ID",
"数据类型" : "varchar(100)",
"列描述" : "支付宝APPID"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_NOTIFY_URL",
"数据类型" : "varchar(200)",
"列描述" : "支付宝支付回调地址"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_PRIVATE_KEY",
"数据类型" : "varchar(2000)",
"列描述" : "支付宝支付应用端私钥"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_PUBLIC_KEY",
"数据类型" : "varchar(2000)",
"列描述" : "支付宝支付支付宝公钥"
},
{
"表名" : "global_setting",
"列名" : "OSS_ACCESS_ID",
"数据类型" : "varchar(45)",
"列描述" : "阿里云OSS存储ACCESS ID"
},
{
"表名" : "global_setting",
"列名" : "OSS_ACCESS_KEY",
"数据类型" : "varchar(45)",
"列描述" : "阿里云OSS存储ACCESS KEY"
},
{
"表名" : "global_setting",
"列名" : "OSS_END_POINT",
"数据类型" : "varchar(100)",
"列描述" : "阿里云OSS存储END POINT"
},
{
"表名" : "global_setting",
"列名" : "OSS_BUCKET_NAME",
"数据类型" : "varchar(100)",
"列描述" : "阿里云OSS存储BUCKET NAME"
},
{
"表名" : "global_setting",
"列名" : "SMS_ACCESSKEY_ID",
"数据类型" : "varchar(45)",
"列描述" : "阿里云短信验证码Accesskey Id"
},
{
"表名" : "global_setting",
"列名" : "SMS_ACCESSKEY_SECRET",
"数据类型" : "varchar(45)",
"列描述" : "阿里云短信验证码Accesskey Secret"
},
{
"表名" : "global_setting",
"列名" : "SMS_SIGN_NAME",
"数据类型" : "varchar(45)",
"列描述" : "阿里云短信验证码签名"
},
{
"表名" : "global_setting",
"列名" : "SMS_TEMPLATE_CODE",
"数据类型" : "varchar(45)",
"列描述" : "阿里云短信验证码模板ID"
},
{
"表名" : "global_setting",
"列名" : "SMS_TEMPLATE_CODE_APPLICATION_APPROVED",
"数据类型" : "varchar(45)",
"列描述" : "门店入驻申请审核通过短信模板"
},
{
"表名" : "global_setting",
"列名" : "SMS_TEMPLATE_CODE_APPLICATION_REJECTED",
"数据类型" : "varchar(45)",
"列描述" : "门店入驻申请审核未通过短信模板"
},
{
"表名" : "global_setting",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "GROUP_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group",
"列名" : "GROUP_NAME",
"数据类型" : "varchar(20)",
"列描述" : "分组名称"
},
{
"表名" : "group",
"列名" : "GROUP_DESCRIPTION",
"数据类型" : "varchar(100)",
"列描述" : "分组描述"
},
{
"表名" : "group",
"列名" : "IS_DISPLAYED_HOME",
"数据类型" : "tinyint(1)",
"列描述" : "是否首页显示"
},
{
"表名" : "group",
"列名" : "SORT_NUMBER",
"数据类型" : "int(11)",
"列描述" : "排序"
},
{
"表名" : "group",
"列名" : "BACKGROUND_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的背景图"
},
{
"表名" : "group",
"列名" : "ICON_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的icon图标"
},
{
"表名" : "group",
"列名" : "IS_REGISTER",
"数据类型" : "tinyint(1)",
"列描述" : "是否会员注册专用"
},
{
"表名" : "group",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "GROUP_BUY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "GROUP_BUY_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动ID"
},
{
"表名" : "group_buy",
"列名" : "OWNER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购商品库存"
},
{
"表名" : "group_buy",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "团购发起时间"
},
{
"表名" : "group_buy",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "团购结束时间"
},
{
"表名" : "group_buy",
"列名" : "STATUS",
"数据类型" : "varchar(10)",
"列描述" : "拼团状态"
},
{
"表名" : "group_buy_def",
"列名" : "GROUP_BUY_DEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_def",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "NAME",
"数据类型" : "varchar(100)",
"列描述" : "活动 名称"
},
{
"表名" : "group_buy_def",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "活动开始时间"
},
{
"表名" : "group_buy_def",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "活动结束时间"
},
{
"表名" : "group_buy_def",
"列名" : "STATUS",
"数据类型" : "varchar(36)",
"列描述" : "团购商品状态(0-团购商品已下线, 1-团购商品已上线)"
},
{
"表名" : "group_buy_def",
"列名" : "MIN_USER_COUNT",
"数据类型" : "int(11)",
"列描述" : "最少成团人数"
},
{
"表名" : "group_buy_def",
"列名" : "MAX_TRAN_DAYS",
"数据类型" : "int(11)",
"列描述" : "成团有效期(天)"
},
{
"表名" : "group_buy_def",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店"
},
{
"表名" : "group_buy_product",
"列名" : "GROUP_BUY_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "GROUP_BUY_DEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动表"
},
{
"表名" : "group_buy_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "group_buy_product",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "团购价格"
},
{
"表名" : "group_buy_product",
"列名" : "STOCK",
"数据类型" : "int(11)",
"列描述" : "团购商品库存"
},
{
"表名" : "group_buy_product",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店"
},
{
"表名" : "group_buy_user",
"列名" : "GROUP_BUY_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_user",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "GROUP_BUY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动ID"
},
{
"表名" : "group_buy_user",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "参与拼团人员"
},
{
"表名" : "group_buy_user",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "拼团对应的订单ID"
},
{
"表名" : "group_buy_user",
"列名" : "JOIN_TIME",
"数据类型" : "timestamp",
"列描述" : "参与拼团的时间"
},
{
"表名" : "group_buy_user",
"列名" : "IS_OWNER",
"数据类型" : "tinyint(1)",
"列描述" : "是否团购发起人"
},
{
"表名" : "logistics",
"列名" : "LOGISTICS_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "NAME",
"数据类型" : "varchar(20)",
"列描述" : "物流公司名称"
},
{
"表名" : "logistics",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "MATERIA_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "TYPE",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "联系电话"
},
{
"表名" : "merchant",
"列名" : "MERCHANTNAME",
"数据类型" : "varchar(100)",
"列描述" : "门店名称"
},
{
"表名" : "merchant",
"列名" : "MERCHANTADDRESS",
"数据类型" : "varchar(200)",
"列描述" : "门店地址"
},
{
"表名" : "merchant",
"列名" : "CONTACTNAME",
"数据类型" : "varchar(20)",
"列描述" : "联系人"
},
{
"表名" : "merchant",
"列名" : "MERCHANTDESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "门店描述"
},
{
"表名" : "merchant",
"列名" : "ISCLOSED",
"数据类型" : "tinyint(1)",
"列描述" : "是否关闭"
},
{
"表名" : "merchant",
"列名" : "REFERRER",
"数据类型" : "varchar(45)",
"列描述" : "推荐人"
},
{
"表名" : "merchant",
"列名" : "REGISTER_DATE",
"数据类型" : "timestamp",
"列描述" : "入驻时间"
},
{
"表名" : "merchant",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "merchant",
"列名" : "EXCHANGE_RATE",
"数据类型" : "int(11)",
"列描述" : "积分赠送比例(不含%)"
},
{
"表名" : "merchant",
"列名" : "PROVINCE",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(省)"
},
{
"表名" : "merchant",
"列名" : "CITY",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(市)"
},
{
"表名" : "merchant",
"列名" : "DISTRICT",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(区)"
},
{
"表名" : "merchant",
"列名" : "LATITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "门店地址(纬度)"
},
{
"表名" : "merchant",
"列名" : "LONGITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "门店地址(经度)"
},
{
"表名" : "merchant",
"列名" : "MERCHANT_ID",
"数据类型" : "varchar(45)",
"列描述" : "商户号"
},
{
"表名" : "merchant_account",
"列名" : "MERCHANTACCOUNT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_account",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_account",
"列名" : "ACCOUNT_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "账户类型(微信,支付宝,银行)"
},
{
"表名" : "merchant_account",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "merchant_account",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "merchant_account",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "merchant_account",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "merchant_account",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "merchant_account",
"列名" : "BANKCODE",
"数据类型" : "varchar(20)",
"列描述" : "银行支行代码"
},
{
"表名" : "merchant_account",
"列名" : "ALIPAY_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "支付宝收款地址"
},
{
"表名" : "merchant_account",
"列名" : "WECHAT_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "微信收款地址"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANT_APPLICATION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_application",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "联系电话"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTNAME",
"数据类型" : "varchar(100)",
"列描述" : "门店名称"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTADDRESS",
"数据类型" : "varchar(200)",
"列描述" : "门店地址"
},
{
"表名" : "merchant_application",
"列名" : "CONTACTNAME",
"数据类型" : "varchar(20)",
"列描述" : "联系人"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTDESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "门店描述"
},
{
"表名" : "merchant_application",
"列名" : "REFERRER",
"数据类型" : "varchar(45)",
"列描述" : "推荐人"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_TIME",
"数据类型" : "timestamp",
"列描述" : "申请入驻时间"
},
{
"表名" : "merchant_application",
"列名" : "VERIFY_TIME",
"数据类型" : "timestamp",
"列描述" : "审核时间"
},
{
"表名" : "merchant_application",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "merchant_application",
"列名" : "PROVINCE",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(省)"
},
{
"表名" : "merchant_application",
"列名" : "CITY",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(市)"
},
{
"表名" : "merchant_application",
"列名" : "DISTRICT",
"数据类型" : "varchar(45)",
"列描述" : "门店地址(区)"
},
{
"表名" : "merchant_application",
"列名" : "LATITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "门店地址(纬度)"
},
{
"表名" : "merchant_application",
"列名" : "LONGITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "门店地址(经度)"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_ID",
"数据类型" : "varchar(45)",
"列描述" : "申请编号"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_STATUS",
"数据类型" : "varchar(5)",
"列描述" : "申请状态"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANTASSIGN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_assign",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_assign",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "用户ID"
},
{
"表名" : "merchant_assign",
"列名" : "TRAN_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "会员消费金额"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_POINT",
"数据类型" : "int(11)",
"列描述" : "划拨积分"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_TIME",
"数据类型" : "timestamp",
"列描述" : "划拨时间"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_NO",
"数据类型" : "varchar(45)",
"列描述" : "划拨交易号"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_POINT_BEFORE",
"数据类型" : "int(11)",
"列描述" : "门店划拨前积分"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_POINT_AFTER",
"数据类型" : "int(11)",
"列描述" : "门店划拨后积分"
},
{
"表名" : "merchant_assign",
"列名" : "USER_POINT_BEFORE",
"数据类型" : "int(11)",
"列描述" : "会员划拨前积分"
},
{
"表名" : "merchant_assign",
"列名" : "USER_POINT_AFTER",
"数据类型" : "int(11)",
"列描述" : "会员划拨后积分"
},
{
"表名" : "merchant_auth",
"列名" : "MERCHANTAUTH_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_auth",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_auth",
"列名" : "PASSWORD",
"数据类型" : "varchar(100)",
"列描述" : "登录密码"
},
{
"表名" : "merchant_auth",
"列名" : "TRAN_PASSWORD",
"数据类型" : "varchar(200)",
"列描述" : "交易密码"
},
{
"表名" : "merchant_auth",
"列名" : "LASTLOGINTIME",
"数据类型" : "timestamp",
"列描述" : "最近登录时间"
},
{
"表名" : "merchant_auth",
"列名" : "FAILCOUNT",
"数据类型" : "int(11)",
"列描述" : "登录失败次数"
},
{
"表名" : "merchant_auth",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_auth",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_auth",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_auth",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_auth",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "MERCHANTBALANCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_balance",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_balance",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_balance",
"列名" : "AVAILABLE_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "可提现余额"
},
{
"表名" : "merchant_balance",
"列名" : "TOTAL_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "总余额, 可能有部分余额因为订单未结束而不能提现"
},
{
"表名" : "merchant_balance",
"列名" : "AVAILABLE_POINT",
"数据类型" : "int(11)",
"列描述" : "可用积分"
},
{
"表名" : "merchant_balance",
"列名" : "TOTAL_POINT",
"数据类型" : "int(11)",
"列描述" : "总积分, 某些积分可能因为订单状态暂不可用"
},
{
"表名" : "merchant_charge",
"列名" : "MERCHANTCHARGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_charge",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "充值金额"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_POINT",
"数据类型" : "int(11)",
"列描述" : "充值获取积分"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "充值状态"
},
{
"表名" : "merchant_charge",
"列名" : "FAIL_REASON",
"数据类型" : "varchar(100)",
"列描述" : "充值失败原因"
},
{
"表名" : "merchant_charge",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "支付方式(微信,支付宝)"
},
{
"表名" : "merchant_charge",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "merchant_charge",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "merchant_charge",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "merchant_charge",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "merchant_charge",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_TIME",
"数据类型" : "timestamp",
"列描述" : "充值时间"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_NO",
"数据类型" : "varchar(16)",
"列描述" : "充值交易编号"
},
{
"表名" : "merchant_charge",
"列名" : "OUT_TRADE_NO",
"数据类型" : "varchar(45)",
"列描述" : "微信或支付宝交易号"
},
{
"表名" : "merchant_charge",
"列名" : "POINT_BEFORE",
"数据类型" : "int(11)",
"列描述" : "充值前积分"
},
{
"表名" : "merchant_charge",
"列名" : "POINT_AFTER",
"数据类型" : "int(11)",
"列描述" : "充值后积分"
},
{
"表名" : "merchant_coupon",
"列名" : "MERCHANTCOUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_coupon",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_coupon",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "优惠券ID"
},
{
"表名" : "merchant_statement",
"列名" : "MERCHANTSTATEMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_statement",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "交易类型"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_POINT",
"数据类型" : "int(11)",
"列描述" : "交易积分"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(500)",
"列描述" : "交易描述"
},
{
"表名" : "merchant_statement",
"列名" : "BALANCEBEFORE",
"数据类型" : "decimal(12,2)",
"列描述" : "交易前资金余额"
},
{
"表名" : "merchant_statement",
"列名" : "BALANCEAFTER",
"数据类型" : "decimal(12,2)",
"列描述" : "交易后资金余额"
},
{
"表名" : "merchant_statement",
"列名" : "POINTBEFORE",
"数据类型" : "int(11)",
"列描述" : "交易前积分余额"
},
{
"表名" : "merchant_statement",
"列名" : "POINTAFTER",
"数据类型" : "int(11)",
"列描述" : "交易后积分余额"
},
{
"表名" : "merchant_token",
"列名" : "MERCHANTTOKEN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_token",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_token",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_token",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_token",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_token",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_token",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_token",
"列名" : "TOKENID",
"数据类型" : "varchar(36)",
"列描述" : "登录token"
},
{
"表名" : "merchant_token",
"列名" : "LOGINTIME",
"数据类型" : "timestamp",
"列描述" : "登录时间"
},
{
"表名" : "merchant_user",
"列名" : "MERCHANTUSER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_user",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_user",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_user",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_user",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_user",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_user",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_user",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "merchant_withdraw",
"列名" : "MERCHANTWITHDRAW_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_withdraw",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_withdraw",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_withdraw",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_withdraw",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_withdraw",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_withdraw",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "merchant_withdraw",
"列名" : "WITHDRAW_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "提现金额"
},
{
"表名" : "merchant_withdraw",
"列名" : "WITHDRAW_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "提现状态"
},
{
"表名" : "merchant_withdraw",
"列名" : "FAIL_REASON",
"数据类型" : "varchar(100)",
"列描述" : "提现失败原因"
},
{
"表名" : "merchant_withdraw",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "提现支付方式"
},
{
"表名" : "merchant_withdraw",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "merchant_withdraw",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "merchant_withdraw",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "merchant_withdraw",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "merchant_withdraw",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "merchant_withdraw",
"列名" : "WITHDRAW_TIME",
"数据类型" : "timestamp",
"列描述" : "提现时间"
},
{
"表名" : "merchant_withdraw",
"列名" : "VERIFY_TIME",
"数据类型" : "timestamp",
"列描述" : "审核时间"
},
{
"表名" : "merchant_withdraw",
"列名" : "TRANSFER_TIME",
"数据类型" : "timestamp",
"列描述" : "打款时间"
},
{
"表名" : "merchant_withdraw",
"列名" : "WITHDRAW_NO",
"数据类型" : "varchar(16)",
"列描述" : "提现交易编号"
},
{
"表名" : "merchant_withdraw",
"列名" : "REJECT_REASON",
"数据类型" : "varchar(100)",
"列描述" : "审核拒绝理由"
},
{
"表名" : "merchant_withdraw",
"列名" : "COMPLETE_TIME",
"数据类型" : "timestamp",
"列描述" : "提现成功时间"
},
{
"表名" : "merchant_withdraw",
"列名" : "PAYMENT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "提现金额"
},
{
"表名" : "merchant_withdraw",
"列名" : "TAX_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "手续费"
},
{
"表名" : "merchant_withdraw",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "message",
"列名" : "MESSAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "message",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "FROM_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发送会员ID"
},
{
"表名" : "message",
"列名" : "TO_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "接收会员ID"
},
{
"表名" : "message",
"列名" : "CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "内容"
},
{
"表名" : "message",
"列名" : "SEND_TIME",
"数据类型" : "timestamp",
"列描述" : "发送时间"
},
{
"表名" : "note",
"列名" : "NOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "note",
"列名" : "CONTENT",
"数据类型" : "varchar(1000)",
"列描述" : "消息内容"
},
{
"表名" : "note",
"列名" : "STATUS",
"数据类型" : "varchar(15)",
"列描述" : "消息状态(已读,未读)"
},
{
"表名" : "note",
"列名" : "SEND_TIME",
"数据类型" : "timestamp",
"列描述" : "消息发送时间"
},
{
"表名" : "note",
"列名" : "ACTION",
"数据类型" : "varchar(45)",
"列描述" : "点击消息触发事件"
},
{
"表名" : "note",
"列名" : "APPLICATION",
"数据类型" : "varchar(60)",
"列描述" : "消息类型"
},
{
"表名" : "note_channel",
"列名" : "NOTECHANNEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note_channel",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "ISSMSENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送短信消息"
},
{
"表名" : "note_channel",
"列名" : "NOTETYPE",
"数据类型" : "varchar(45)",
"列描述" : "消息类型"
},
{
"表名" : "note_channel",
"列名" : "ISEMAILENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送邮件消息"
},
{
"表名" : "note_channel",
"列名" : "ISWECHATENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送微信消息"
},
{
"表名" : "note_def",
"列名" : "NOTEDEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note_def",
"列名" : "NOTE_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "消息类型"
},
{
"表名" : "note_def",
"列名" : "NOTE_VALUE",
"数据类型" : "varchar(300)",
"列描述" : "消息内容"
},
{
"表名" : "note_def",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "NOTE_ACTION",
"数据类型" : "varchar(45)",
"列描述" : "消息点击触发事件"
},
{
"表名" : "note_def",
"列名" : "NOTE_APPLICATION",
"数据类型" : "varchar(60)",
"列描述" : "消息类型"
},
{
"表名" : "num",
"列名" : "i",
"数据类型" : "int(11)",
"列描述" : ""
},
{
"表名" : "opt_contact",
"列名" : "OPTCONTACT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "opt_contact",
"列名" : "CONTACTTYPE",
"数据类型" : "varchar(10)",
"列描述" : "通知类型(邮箱, SMS)"
},
{
"表名" : "opt_contact",
"列名" : "CONTACTNO",
"数据类型" : "varchar(50)",
"列描述" : "通知联系号码(手机号码, 电子邮件地址)"
},
{
"表名" : "opt_contact",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "opt_contact",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "opt_contact",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "opt_contact",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "opt_contact",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "order",
"列名" : "ORDER_NO",
"数据类型" : "varchar(20)",
"列描述" : "订单号"
},
{
"表名" : "order",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "ORDER_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "0-普通订单, 1-秒杀订单, 2-团购订单"
},
{
"表名" : "order",
"列名" : "ORDER_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "订单状态"
},
{
"表名" : "order",
"列名" : "PRODUCT_UNIT",
"数据类型" : "int(11)",
"列描述" : "数量"
},
{
"表名" : "order",
"列名" : "PRODUCT_POINT",
"数据类型" : "int(11)",
"列描述" : "总积分"
},
{
"表名" : "order",
"列名" : "PRODUCT_COST_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "成本总价"
},
{
"表名" : "order",
"列名" : "PRODUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "总金额"
},
{
"表名" : "order",
"列名" : "DEDUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "优惠金额"
},
{
"表名" : "order",
"列名" : "FREIGHT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "订单运费"
},
{
"表名" : "order",
"列名" : "ACTUAL_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "实际支付金额"
},
{
"表名" : "order",
"列名" : "ACTUAL_POINT",
"数据类型" : "int(11)",
"列描述" : "实际支付积分"
},
{
"表名" : "order",
"列名" : "ORDER_TIME",
"数据类型" : "timestamp",
"列描述" : "下单时间"
},
{
"表名" : "order",
"列名" : "DELIVERY_TIME",
"数据类型" : "timestamp",
"列描述" : "发货时间"
},
{
"表名" : "order",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "order",
"列名" : "DELIVERY_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "1-快递配送, 2-门店自提"
},
{
"表名" : "order",
"列名" : "DELIVERY_ADDRESS_UUID",
"数据类型" : "varchar(36)",
"列描述" : "收货地址ID"
},
{
"表名" : "order",
"列名" : "DELIVERY_PROVINCE",
"数据类型" : "varchar(45)",
"列描述" : "收货地址(省)"
},
{
"表名" : "order",
"列名" : "DELIVERY_CITY",
"数据类型" : "varchar(45)",
"列描述" : "收货地址(市)"
},
{
"表名" : "order",
"列名" : "DELIVERY_AREA",
"数据类型" : "varchar(45)",
"列描述" : "收货地址(区)"
},
{
"表名" : "order",
"列名" : "DELIVERY_STREET",
"数据类型" : "varchar(200)",
"列描述" : "收货地址(详细地址)"
},
{
"表名" : "order",
"列名" : "DELIVERY_NAME",
"数据类型" : "varchar(100)",
"列描述" : "收货人姓名"
},
{
"表名" : "order",
"列名" : "DELIVERY_CONTACT_NO",
"数据类型" : "varchar(20)",
"列描述" : "收货人电话"
},
{
"表名" : "order",
"列名" : "DELIVERY_ZIPCODE",
"数据类型" : "varchar(20)",
"列描述" : "收货地址邮编"
},
{
"表名" : "order",
"列名" : "MEMO",
"数据类型" : "varchar(200)",
"列描述" : "订单备注(买家)"
},
{
"表名" : "order",
"列名" : "FORM_ID",
"数据类型" : "varchar(100)",
"列描述" : "小程序端提交时的Form ID"
},
{
"表名" : "order",
"列名" : "COURIER_NAME",
"数据类型" : "varchar(45)",
"列描述" : "物流公司"
},
{
"表名" : "order",
"列名" : "COURIER_NO",
"数据类型" : "varchar(45)",
"列描述" : "物流编号"
},
{
"表名" : "order",
"列名" : "ORDER_COMMENT",
"数据类型" : "varchar(500)",
"列描述" : "订单备注(卖家)"
},
{
"表名" : "order",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "订单支付方式(1-微信,2-支付宝,3-银行卡,4-余额)"
},
{
"表名" : "order",
"列名" : "ORDER_CHANNEL",
"数据类型" : "varchar(45)",
"列描述" : "下单渠道(1-微信小程序,2-H5,3-APP)"
},
{
"表名" : "order",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "支付时间"
},
{
"表名" : "order",
"列名" : "CANCEL_TIME",
"数据类型" : "timestamp",
"列描述" : "订单取消时间"
},
{
"表名" : "order",
"列名" : "CANCEL_REASON",
"数据类型" : "varchar(500)",
"列描述" : "订单取消原因"
},
{
"表名" : "order",
"列名" : "IS_AFTER_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "是否申请售后"
},
{
"表名" : "order",
"列名" : "AFTER_SALE_NO",
"数据类型" : "varchar(45)",
"列描述" : "售后单号"
},
{
"表名" : "order",
"列名" : "USER_COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单使用的优惠券"
},
{
"表名" : "order",
"列名" : "CONFIRM_TIME",
"数据类型" : "timestamp",
"列描述" : "确认收货时间"
},
{
"表名" : "order",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "order",
"列名" : "P_ORDER_NO",
"数据类型" : "varchar(45)",
"列描述" : "合并支付时产生的主订单号"
},
{
"表名" : "order",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信支付后生成的交易编号"
},
{
"表名" : "order",
"列名" : "IS_ACCOUNTED",
"数据类型" : "tinyint(1)",
"列描述" : "订单是否入账到门店"
},
{
"表名" : "order_after_sale",
"列名" : "ORDER_AFTER_SALE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "SALE_NO",
"数据类型" : "varchar(45)",
"列描述" : "售后单号"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_TYPE",
"数据类型" : "varchar(5)",
"列描述" : "售后类型(1-仅退款, 2-退款退货)"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "申请退款金额"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_DESCRIPTION",
"数据类型" : "varchar(500)",
"列描述" : "售后描述"
},
{
"表名" : "order_after_sale",
"列名" : "TIME_APPLICATION",
"数据类型" : "timestamp",
"列描述" : "申请售后时间"
},
{
"表名" : "order_after_sale",
"列名" : "TIME_OPERATION",
"数据类型" : "timestamp",
"列描述" : "处理售后时间"
},
{
"表名" : "order_after_sale",
"列名" : "STATUS",
"数据类型" : "varchar(5)",
"列描述" : "售后单状态(0-处理中,1-审核通过,2-审核拒绝)"
},
{
"表名" : "order_after_sale",
"列名" : "REJECT_REASON",
"数据类型" : "varchar(500)",
"列描述" : "拒绝退款申请原因"
},
{
"表名" : "order_after_sale",
"列名" : "COURIER_NO",
"数据类型" : "varchar(45)",
"列描述" : "退货物流单号"
},
{
"表名" : "order_after_sale",
"列名" : "COURIER_NAME",
"数据类型" : "varchar(45)",
"列描述" : "退货物流公司"
},
{
"表名" : "order_after_sale",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信退款后生成的交易编号"
},
{
"表名" : "order_after_sale",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : "微信退款返回的消息"
},
{
"表名" : "order_after_sale_image",
"列名" : "ORDER_AFTER_SALE_IMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "ORDER_AFTER_SALE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : "图片地址"
},
{
"表名" : "order_image",
"列名" : "ORDERIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_image",
"列名" : "IMAGEURL",
"数据类型" : "varchar(500)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "ORDER_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "order_product",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单ID"
},
{
"表名" : "order_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "ACTUAL_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "实际支付金额"
},
{
"表名" : "order_product",
"列名" : "ACTUAL_POINT",
"数据类型" : "int(11)",
"列描述" : "实际支付积分"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "order_product",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格ID"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_NAME",
"数据类型" : "varchar(200)",
"列描述" : "商品名称"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_CODE",
"数据类型" : "varchar(45)",
"列描述" : "商品货号"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "商品主图"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_SKU_DESC",
"数据类型" : "varchar(500)",
"列描述" : "商品规格描述"
},
{
"表名" : "order_product",
"列名" : "PRODUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_POINT",
"数据类型" : "int(11)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT",
"数据类型" : "int(11)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT_POINT",
"数据类型" : "int(11)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "ORG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "org",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "NAME",
"数据类型" : "varchar(60)",
"列描述" : "部门名称"
},
{
"表名" : "org",
"列名" : "MANAGER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "经理ID"
},
{
"表名" : "org",
"列名" : "DESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "描述"
},
{
"表名" : "org_rel",
"列名" : "ORGREL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "org_rel",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "ORG_PARENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "上级部门ID"
},
{
"表名" : "org_rel",
"列名" : "ORG_CHILD_UUID",
"数据类型" : "varchar(36)",
"列描述" : "下级部门ID"
},
{
"表名" : "pay_order",
"列名" : "PAYORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "pay_order",
"列名" : "ORDER_NO",
"数据类型" : "varchar(20)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "ORDER_STATUS",
"数据类型" : "varchar(1)",
"列描述" : "订单状态"
},
{
"表名" : "pay_order",
"列名" : "PRODUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "消费金额"
},
{
"表名" : "pay_order",
"列名" : "ACTUAL_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "实际支付金额"
},
{
"表名" : "pay_order",
"列名" : "OUT_TRADE_NO",
"数据类型" : "varchar(45)",
"列描述" : "微信或支付宝交易编号"
},
{
"表名" : "pay_order",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "支付时间"
},
{
"表名" : "pay_order",
"列名" : "ORDER_TIME",
"数据类型" : "timestamp",
"列描述" : "下单时间"
},
{
"表名" : "pay_order",
"列名" : "DELIVERY_TIME",
"数据类型" : "timestamp",
"列描述" : "发货时间"
},
{
"表名" : "pay_order",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "pay_order",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "pay_order",
"列名" : "REWARD_POINT",
"数据类型" : "int(11)",
"列描述" : "奖励积分"
},
{
"表名" : "pay_order",
"列名" : "IS_REWARD_POINT_RECEIVED",
"数据类型" : "tinyint(1)",
"列描述" : "积分是否领取"
},
{
"表名" : "pay_order",
"列名" : "WECHATPAY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "微信交易编号"
},
{
"表名" : "pay_order",
"列名" : "ALIPAY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "支付宝交易编号"
},
{
"表名" : "pay_order",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "消费金额"
},
{
"表名" : "pay_order",
"列名" : "ASINFO_PLATFORM",
"数据类型" : "decimal(12,2)",
"列描述" : "该笔订单平台分账金额"
},
{
"表名" : "pay_order",
"列名" : "ASINFO_MERCHANT",
"数据类型" : "decimal(12,2)",
"列描述" : "该笔订单门店分账金额"
},
{
"表名" : "permission",
"列名" : "PERMISSION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "permission",
"列名" : "ROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "角色ID"
},
{
"表名" : "permission",
"列名" : "FUNCTION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "功能ID"
},
{
"表名" : "permission",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "PLATFORMACCOUNT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "platform_account",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "ACCOUNT_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "账户类型(微信,支付宝,银行卡)"
},
{
"表名" : "platform_account",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "platform_account",
"列名" : "BRANCHNAME",
"数据类型" : "varchar(45)",
"列描述" : "支行名称"
},
{
"表名" : "platform_account",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "platform_account",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名称"
},
{
"表名" : "platform_account",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "platform_account",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "platform_account",
"列名" : "BANKCODE",
"数据类型" : "varchar(20)",
"列描述" : "支行编号"
},
{
"表名" : "platform_account",
"列名" : "ALIPAY_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "支付宝收款码地址"
},
{
"表名" : "platform_account",
"列名" : "WECHAT_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "微信收款码地址"
},
{
"表名" : "platform_balance",
"列名" : "PLATFORMBALANCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "platform_balance",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "AVAILABLE_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "可提现余额"
},
{
"表名" : "platform_balance",
"列名" : "TOTAL_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "总余额, 可能有部分余额因为订单未结束而不能提现"
},
{
"表名" : "platform_balance",
"列名" : "AVAILABLE_INTEGRAL",
"数据类型" : "int(11)",
"列描述" : "可用积分"
},
{
"表名" : "platform_balance",
"列名" : "TOTAL_INTEGRAL",
"数据类型" : "int(11)",
"列描述" : "总积分, 某些积分可能因为订单状态暂不可用"
},
{
"表名" : "platform_statement",
"列名" : "PLATFORMSTATEMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "platform_statement",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "platform_statement",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_statement",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_statement",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_statement",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_statement",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "交易类型"
},
{
"表名" : "platform_statement",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "platform_statement",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "platform_statement",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "platform_statement",
"列名" : "BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "该笔交易发生后余额"
},
{
"表名" : "poster",
"列名" : "POSTER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "poster",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "poster",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : "海报地址"
},
{
"表名" : "product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "PRODUCT_DESC",
"数据类型" : "longtext",
"列描述" : "商品描述"
},
{
"表名" : "product",
"列名" : "PRODUCT_NAME",
"数据类型" : "varchar(45)",
"列描述" : "商品名称"
},
{
"表名" : "product",
"列名" : "PRODUCT_CODE",
"数据类型" : "varchar(45)",
"列描述" : "商品编码"
},
{
"表名" : "product",
"列名" : "PRODUCT_BRIEF",
"数据类型" : "varchar(100)",
"列描述" : "商品简短描述"
},
{
"表名" : "product",
"列名" : "PRODUCT_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "商品重量"
},
{
"表名" : "product",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "商品单价"
},
{
"表名" : "product",
"列名" : "UNIT_PRICE_STANDARD",
"数据类型" : "decimal(12,2)",
"列描述" : "标准价格"
},
{
"表名" : "product",
"列名" : "TOTALUNIT",
"数据类型" : "int(11)",
"列描述" : "商品总库存数量"
},
{
"表名" : "product",
"列名" : "SOLDUNIT",
"数据类型" : "int(11)",
"列描述" : "商品已售数量"
},
{
"表名" : "product",
"列名" : "IS_SKU_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否多规格商品"
},
{
"表名" : "product",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品品类"
},
{
"表名" : "product",
"列名" : "PRODUCTBRAND_UUID",
"数据类型" : "varchar(36)",
"列描述" : "品牌"
},
{
"表名" : "product",
"列名" : "PRODUCT_MAIN_IMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品主图"
},
{
"表名" : "product",
"列名" : "PRODUCTFREIGHT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "运费模板"
},
{
"表名" : "product",
"列名" : "PROMOTE_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "促销单价"
},
{
"表名" : "product",
"列名" : "MEMBERSHIP_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "会员单价"
},
{
"表名" : "product",
"列名" : "MARKET_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "市场价"
},
{
"表名" : "product",
"列名" : "PROMOTE_START_DATE",
"数据类型" : "timestamp",
"列描述" : "促销开始时间"
},
{
"表名" : "product",
"列名" : "PROMOTE_END_DATE",
"数据类型" : "timestamp",
"列描述" : "促销结束时间"
},
{
"表名" : "product",
"列名" : "WARN_UNIT",
"数据类型" : "int(11)",
"列描述" : "库存预警数量"
},
{
"表名" : "product",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : "是否新品"
},
{
"表名" : "product",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热销"
},
{
"表名" : "product",
"列名" : "IS_PROMOTE",
"数据类型" : "tinyint(1)",
"列描述" : "是否参与促销"
},
{
"表名" : "product",
"列名" : "UNIT_POINT",
"数据类型" : "int(11)",
"列描述" : "购买需要实际积分数"
},
{
"表名" : "product",
"列名" : "UNIT_POINT_STANDARD",
"数据类型" : "int(11)",
"列描述" : "购买需要划线积分数"
},
{
"表名" : "product",
"列名" : "IS_RECOMMEND",
"数据类型" : "tinyint(1)",
"列描述" : "是否推荐商品"
},
{
"表名" : "product",
"列名" : "PRODUCT_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "商品类型, 实物或者优惠券"
},
{
"表名" : "product",
"列名" : "IS_ON_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "上架,下架"
},
{
"表名" : "product",
"列名" : "IS_SHIPPING",
"数据类型" : "tinyint(1)",
"列描述" : "是否需要邮寄"
},
{
"表名" : "product",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "门店备注"
},
{
"表名" : "product",
"列名" : "PRODUCT_COST_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "商品成本价"
},
{
"表名" : "product",
"列名" : "SUPPLIER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品所属供应商"
},
{
"表名" : "product",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "PRODUCTATTRVALUE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_attr_value",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "IS_CATE_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_attr_value",
"列名" : "PRODUCT_ATTR_NAME",
"数据类型" : "varchar(45)",
"列描述" : "属性名称"
},
{
"表名" : "product_attr_value",
"列名" : "PRODUCT_ATTR_VALUE",
"数据类型" : "varchar(100)",
"列描述" : "属性值"
},
{
"表名" : "product_brand",
"列名" : "PRODUCTBRAND_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_brand",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_brand",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_brand",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_brand",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_brand",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_brand",
"列名" : "NAME",
"数据类型" : "varchar(40)",
"列描述" : "品牌名称"
},
{
"表名" : "product_brand",
"列名" : "DESCRIPTION",
"数据类型" : "varchar(100)",
"列描述" : "品牌描述"
},
{
"表名" : "product_brand",
"列名" : "LOGOURL",
"数据类型" : "varchar(500)",
"列描述" : "LOGO地址"
},
{
"表名" : "product_brand",
"列名" : "SORTNUMBER",
"数据类型" : "int(11)",
"列描述" : "排序"
},
{
"表名" : "product_cate",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_cate",
"列名" : "CATE_NAME",
"数据类型" : "varchar(45)",
"列描述" : "品类名称"
},
{
"表名" : "product_cate",
"列名" : "CATE_PATH",
"数据类型" : "varchar(500)",
"列描述" : "品类路径"
},
{
"表名" : "product_cate",
"列名" : "PARENTCATE_UUID",
"数据类型" : "varchar(46)",
"列描述" : "上级品类ID"
},
{
"表名" : "product_cate",
"列名" : "SORTNUMBER",
"数据类型" : "int(11)",
"列描述" : "排序"
},
{
"表名" : "product_cate",
"列名" : "CATE_PIC_URL",
"数据类型" : "varchar(200)",
"列描述" : "主图地址"
},
{
"表名" : "product_cate",
"列名" : "IS_LEAF",
"数据类型" : "tinyint(1)",
"列描述" : "是否叶子节点"
},
{
"表名" : "product_cate",
"列名" : "IS_DISPLAYED_HOME",
"数据类型" : "tinyint(1)",
"列描述" : "是否首页显示"
},
{
"表名" : "product_cate_attr",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_cate_attr",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(46)",
"列描述" : "品类ID"
},
{
"表名" : "product_cate_attr",
"列名" : "ATTR_NAME",
"数据类型" : "varchar(50)",
"列描述" : "属性名"
},
{
"表名" : "product_cate_attr",
"列名" : "ATTR_VALUE",
"数据类型" : "varchar(500)",
"列描述" : "属性值"
},
{
"表名" : "product_cate_attr",
"列名" : "IS_SPU_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "IS_MANDATORY",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "IS_MULTIPLE",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "IS_INPUT",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "IS_SKU_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_cate_attr",
"列名" : "IS_SEARCH_ATTR",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "PRODUCT_COLLECT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_collect",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_collect",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_collect",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "product_comment",
"列名" : "PRODUCTCOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_comment",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_comment",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_comment",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_comment",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_comment",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_comment",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_comment",
"列名" : "COMMENT_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "评论类容"
},
{
"表名" : "product_comment",
"列名" : "COMMENT_RANK",
"数据类型" : "int(11)",
"列描述" : "评论打分"
},
{
"表名" : "product_comment",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发表评论会员ID"
},
{
"表名" : "product_comment",
"列名" : "REPLAY_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "回复内容"
},
{
"表名" : "product_comment",
"列名" : "EVALUATE_TIME",
"数据类型" : "timestamp",
"列描述" : "发表时间"
},
{
"表名" : "product_comment",
"列名" : "REPLAY_TIME",
"数据类型" : "timestamp",
"列描述" : "回复时间"
},
{
"表名" : "product_comment",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单ID"
},
{
"表名" : "product_comment",
"列名" : "IS_SHOW",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "PRODUCTCOMMENTIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_comment_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_comment_image",
"列名" : "PRODUCTCOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "评论ID"
},
{
"表名" : "product_comment_image",
"列名" : "IMAGEURL",
"数据类型" : "varchar(500)",
"列描述" : "图片地址"
},
{
"表名" : "product_comment_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_desc_image",
"列名" : "PRODUCTDESCIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_desc_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_desc_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_desc_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_desc_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_desc_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_desc_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_desc_image",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "文件地址ID"
},
{
"表名" : "product_freight",
"列名" : "PRODUCTFREIGHT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_freight",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "NAME",
"数据类型" : "varchar(40)",
"列描述" : "模板名称"
},
{
"表名" : "product_freight",
"列名" : "CHARGETYPE",
"数据类型" : "int(11)",
"列描述" : "计价方式(1-按件数, 2-按重量)"
},
{
"表名" : "product_freight",
"列名" : "COURIER_NAME",
"数据类型" : "varchar(45)",
"列描述" : "物流公司"
},
{
"表名" : "product_freight",
"列名" : "IS_SHIPPING_FREE",
"数据类型" : "tinyint(1)",
"列描述" : "是否包邮"
},
{
"表名" : "product_freight",
"列名" : "SHIPPING_FREE_CONDITION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "包邮条件(满多少金额, 设置为0表示无限制)"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_FIRST_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "默认首重"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_NEXT_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "续重"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_FIRST_UNIT",
"数据类型" : "int(11)",
"列描述" : "默认首件件数"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_NEXT_UNIT",
"数据类型" : "int(11)",
"列描述" : "续件件数"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_FIRST_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "默认首重/件金额"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_NEXT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "默认续重/件金额"
},
{
"表名" : "product_freight",
"列名" : "IS_ACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "product_freight",
"列名" : "IS_DEFAULT",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product_freight",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "PRODUCTFREIGHTREGION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_freight_region",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "PRODUCTGREIGHT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "运费模板ID"
},
{
"表名" : "product_freight_region",
"列名" : "FIRST_UNIT",
"数据类型" : "int(11)",
"列描述" : "首件"
},
{
"表名" : "product_freight_region",
"列名" : "NEXT_UNIT",
"数据类型" : "int(11)",
"列描述" : "续件"
},
{
"表名" : "product_freight_region",
"列名" : "FIRST_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "首重"
},
{
"表名" : "product_freight_region",
"列名" : "NEXT_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "续重"
},
{
"表名" : "product_freight_region",
"列名" : "FIRST_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "前多少件价格"
},
{
"表名" : "product_freight_region",
"列名" : "NEXT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "接下来每多少件价格"
},
{
"表名" : "product_freight_region",
"列名" : "AREA_ID",
"数据类型" : "varchar(100)",
"列描述" : "区域"
},
{
"表名" : "product_group",
"列名" : "PRODUCTGROUP_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_group",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_group",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_group",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_group",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_group",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_group",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品组对应商品"
},
{
"表名" : "product_group",
"列名" : "GROUP_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "PRODUCTIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_image",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PRODUCTPROMOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PROMOTE_TYPE",
"数据类型" : "varchar(10)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PROMOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "SUPPLIER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_sku",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_sku",
"列名" : "SKU_UNIT_POINT",
"数据类型" : "int(11)",
"列描述" : "规格单价(积分)"
},
{
"表名" : "product_sku",
"列名" : "SKU_UNIT_POINT_STANDARD",
"数据类型" : "int(11)",
"列描述" : "规格划线单价(积分)"
},
{
"表名" : "product_sku",
"列名" : "SKU_CODE",
"数据类型" : "varchar(45)",
"列描述" : "规格货号"
},
{
"表名" : "product_sku",
"列名" : "SKU_TOTAL_UNIT",
"数据类型" : "int(11)",
"列描述" : "规格库存"
},
{
"表名" : "product_sku",
"列名" : "SKU_SOLD_UNIT",
"数据类型" : "int(11)",
"列描述" : "规格已售数量"
},
{
"表名" : "product_sku",
"列名" : "SKU_WARN_UNIT",
"数据类型" : "int(11)",
"列描述" : "库存预警数量"
},
{
"表名" : "product_sku",
"列名" : "PRODUCT_SKU_ATTR_VALUE_UUIDS",
"数据类型" : "longtext",
"列描述" : "SKU对应的规格名和规格值"
},
{
"表名" : "product_sku",
"列名" : "SKU_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "规格单价"
},
{
"表名" : "product_sku",
"列名" : "SKU_UNIT_PRICE_STANDARD",
"数据类型" : "decimal(12,2)",
"列描述" : "规格标准单价"
},
{
"表名" : "product_sku_attr",
"列名" : "PRODUCTSKUATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_sku_attr",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_sku_attr",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku_attr",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku_attr",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku_attr",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku_attr",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "product_sku_attr",
"列名" : "IS_CATE_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : "是否继承自品类属性"
},
{
"表名" : "product_sku_attr",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品品类属性ID"
},
{
"表名" : "product_sku_attr",
"列名" : "PRODUCT_ATTR_NAME",
"数据类型" : "varchar(45)",
"列描述" : "商品品类名称"
},
{
"表名" : "product_sku_attr",
"列名" : "PRODUCT_ATTR_VALUE",
"数据类型" : "varchar(100)",
"列描述" : "暂不使用"
},
{
"表名" : "product_sku_attr_value",
"列名" : "PRODUCTSKUATTRVALUE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_sku_attr_value",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_sku_attr_value",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku_attr_value",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku_attr_value",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku_attr_value",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku_attr_value",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "product_sku_attr_value",
"列名" : "PRODUCTSKUATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格名ID"
},
{
"表名" : "product_sku_attr_value",
"列名" : "PRODUCT_SKU_ATTR_VALUE",
"数据类型" : "varchar(45)",
"列描述" : "商品规格值"
},
{
"表名" : "product_sku_attr_value",
"列名" : "IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "规格主图"
},
{
"表名" : "product_video",
"列名" : "PRODUCTVIDEO_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_video",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_video",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "商品视频"
},
{
"表名" : "product_video",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_video",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_video",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_video",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_video",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "视频文件ID"
},
{
"表名" : "profit_performance",
"列名" : "PROFIT_PERFORMANCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_performance",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_performance",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_performance",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_performance",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_performance",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_performance",
"列名" : "PROFIT_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "获取团队收益的会员等级"
},
{
"表名" : "profit_performance",
"列名" : "AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "团队销售金额"
},
{
"表名" : "profit_performance",
"列名" : "RATING",
"数据类型" : "decimal(12,2)",
"列描述" : "提成比例"
},
{
"表名" : "profit_recruit",
"列名" : "PROFIT_RECRUIT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_recruit",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_recruit",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_recruit",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_recruit",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_recruit",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_recruit",
"列名" : "RECRUIT_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "推广的会员等级"
},
{
"表名" : "profit_recruit",
"列名" : "PROFIT_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "获取推广收益的会员等级"
},
{
"表名" : "profit_recruit",
"列名" : "PROFIT",
"数据类型" : "decimal(12,2)",
"列描述" : "收益金额"
},
{
"表名" : "profit_sale",
"列名" : "PROFIT_SALE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_sale",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_sale",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_sale",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_sale",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_sale",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_sale",
"列名" : "PROFIT_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "获取推广收益的会员等级"
},
{
"表名" : "profit_sale",
"列名" : "PROFIT_RATE",
"数据类型" : "decimal(12,2)",
"列描述" : "分润比例"
},
{
"表名" : "profit_trainer",
"列名" : "PROFIT_TRAINER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_trainer",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_trainer",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_trainer",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_trainer",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_trainer",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_trainer",
"列名" : "PROFIT_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "培训导师辅导的会员等级"
},
{
"表名" : "profit_trainer",
"列名" : "AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "团队销售金额"
},
{
"表名" : "profit_trainer",
"列名" : "RATING",
"数据类型" : "decimal(12,2)",
"列描述" : "提成比例"
},
{
"表名" : "qa",
"列名" : "QA_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "qa",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "qa",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "qa",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "qa",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "qa",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "qa",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "qa",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "回答"
},
{
"表名" : "qa",
"列名" : "TITLE",
"数据类型" : "varchar(200)",
"列描述" : "问题"
},
{
"表名" : "qa",
"列名" : "COVERIMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图地址"
},
{
"表名" : "qa",
"列名" : "MEDIA_ID",
"数据类型" : "varchar(200)",
"列描述" : "暂不使用"
},
{
"表名" : "qa",
"列名" : "IS_FROM_OFFICIALACCOUNT",
"数据类型" : "tinyint(1)",
"列描述" : "暂不使用"
},
{
"表名" : "qa",
"列名" : "PREVIEW_URL",
"数据类型" : "varchar(500)",
"列描述" : "暂不使用"
},
{
"表名" : "qa",
"列名" : "PUBLISH_TIME",
"数据类型" : "timestamp",
"列描述" : "发布时间"
},
{
"表名" : "qa",
"列名" : "DIGEST",
"数据类型" : "varchar(200)",
"列描述" : "暂不使用"
},
{
"表名" : "qa",
"列名" : "NUMBER_OF_READING",
"数据类型" : "int(11)",
"列描述" : "浏览次数"
},
{
"表名" : "qa",
"列名" : "ISPUBLISHED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发布"
},
{
"表名" : "qa",
"列名" : "ISHOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热门"
},
{
"表名" : "role",
"列名" : "ROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "role",
"列名" : "ROLE_NAME",
"数据类型" : "varchar(20)",
"列描述" : "角色名称"
},
{
"表名" : "role",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "role",
"列名" : "ROLE_DESC",
"数据类型" : "varchar(200)",
"列描述" : "角色描述"
},
{
"表名" : "scene",
"列名" : "SCENE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
}
]