[
{
"表名" : "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",
"列名" : "RESOURCE_CATE_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",
"列描述" : "登录失败次数"
},
{
"表名" : "admin",
"列名" : "ISLOCKED",
"数据类型" : "tinyint(1)",
"列描述" : "是否锁定"
},
{
"表名" : "admin",
"列名" : "SUCCESSCOUNT",
"数据类型" : "int",
"列描述" : "总登录次数"
},
{
"表名" : "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",
"列描述" : "地区深度"
},
{
"表名" : "area",
"列名" : "NAME",
"数据类型" : "varchar(32)",
"列描述" : "地区名称"
},
{
"表名" : "area",
"列名" : "POSTAL_CODE",
"数据类型" : "varchar(45)",
"列描述" : "邮政编码"
},
{
"表名" : "area",
"列名" : "SORT",
"数据类型" : "int",
"列描述" : "地区排序"
},
{
"表名" : "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",
"数据类型" : "longtext",
"列描述" : "摘要"
},
{
"表名" : "article",
"列名" : "NUMBER_OF_READING",
"数据类型" : "int",
"列描述" : "浏览次数"
},
{
"表名" : "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",
"列描述" : "发放数量"
},
{
"表名" : "coupon",
"列名" : "AVAILABLECOUNT",
"数据类型" : "int",
"列描述" : "可用数量"
},
{
"表名" : "coupon",
"列名" : "LIMITPERUSER",
"数据类型" : "int",
"列描述" : "每人限领数量"
},
{
"表名" : "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",
"列描述" : "领取后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",
"列描述" : "优惠券数量"
},
{
"表名" : "coupon_order",
"列名" : "COUPON_POINT",
"数据类型" : "int",
"列描述" : "优惠券所需积分"
},
{
"表名" : "coupon_order",
"列名" : "ACTUAL_POINT",
"数据类型" : "int",
"列描述" : "优惠券实际支付积分"
},
{
"表名" : "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_resource",
"列名" : "COUPON_RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "coupon_resource",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "coupon_resource",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_resource",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_resource",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "coupon_resource",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "coupon_resource",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "coupon_resource",
"列名" : "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",
"列描述" : "文件大小"
},
{
"表名" : "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_CHARGE_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_APP_ID_OPEN",
"数据类型" : "varchar(100)",
"列描述" : "微信开放平台APPID"
},
{
"表名" : "global_setting",
"列名" : "WECHAT_APP_SECRET_OPEN",
"数据类型" : "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(45)",
"列描述" : "微信退款异步通知地址"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_APP_ID",
"数据类型" : "varchar(100)",
"列描述" : "支付宝APPID"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_NOTIFY_URL",
"数据类型" : "varchar(200)",
"列描述" : "支付宝支付回调地址"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_REFUND_NOTIFY_URL",
"数据类型" : "varchar(200)",
"列描述" : "支付宝退款回调地址"
},
{
"表名" : "global_setting",
"列名" : "ALIPAY_RETURN_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",
"列名" : "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",
"列描述" : "排序"
},
{
"表名" : "group",
"列名" : "BACKGROUND_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的背景图"
},
{
"表名" : "group",
"列名" : "ICON_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的icon图标"
},
{
"表名" : "group",
"列名" : "IS_REGISTER",
"数据类型" : "tinyint(1)",
"列描述" : "是否会员注册专用"
},
{
"表名" : "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",
"列描述" : "积分赠送比例(不含%)"
},
{
"表名" : "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_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",
"列描述" : "登录失败次数"
},
{
"表名" : "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",
"列描述" : "可用积分"
},
{
"表名" : "merchant_balance",
"列名" : "TOTAL_POINT",
"数据类型" : "int",
"列描述" : "总积分, 某些积分可能因为订单状态暂不可用"
},
{
"表名" : "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",
"列描述" : "交易积分"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(500)",
"列描述" : "交易描述"
},
{
"表名" : "merchant_statement",
"列名" : "BALANCEBEFORE",
"数据类型" : "decimal(12,2)",
"列描述" : "交易前资金余额"
},
{
"表名" : "merchant_statement",
"列名" : "BALANCEAFTER",
"数据类型" : "decimal(12,2)",
"列描述" : "交易后资金余额"
},
{
"表名" : "merchant_statement",
"列名" : "POINTBEFORE",
"数据类型" : "int",
"列描述" : "交易前积分余额"
},
{
"表名" : "merchant_statement",
"列名" : "POINTAFTER",
"数据类型" : "int",
"列描述" : "交易后积分余额"
},
{
"表名" : "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)",
"列描述" : "手续费金额"
},
{
"表名" : "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",
"列描述" : ""
},
{
"表名" : "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(45)",
"列描述" : "订单号"
},
{
"表名" : "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",
"列描述" : "数量"
},
{
"表名" : "order",
"列名" : "PRODUCT_POINT",
"数据类型" : "int",
"列描述" : "总积分"
},
{
"表名" : "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",
"列描述" : "实际支付积分"
},
{
"表名" : "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_ACCOUNTED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "IS_AFTER_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "是否申请售后"
},
{
"表名" : "order",
"列名" : "AFTER_SALE_NO",
"数据类型" : "varchar(45)",
"列描述" : "售后单号"
},
{
"表名" : "order",
"列名" : "AFTER_SALE_DEADLINE_TIME",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order",
"列名" : "USER_COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单使用的优惠券"
},
{
"表名" : "order",
"列名" : "CONFIRM_TIME",
"数据类型" : "timestamp",
"列描述" : "确认收货时间"
},
{
"表名" : "order",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "门店ID"
},
{
"表名" : "order",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(36)",
"列描述" : "微信支付后生成的交易编号"
},
{
"表名" : "order",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信退款后生成的交易编号"
},
{
"表名" : "order",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : "微信退款返回消息"
},
{
"表名" : "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",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信退款后生成的交易编号"
},
{
"表名" : "order_after_sale",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : "微信退款返回消息"
},
{
"表名" : "order_after_sale",
"列名" : "TIME_COURIER",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "TIME_CONFIRM",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "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",
"列描述" : "实际支付积分"
},
{
"表名" : "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",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT_POINT",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "PRODUCT_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "order_product",
"列名" : "POINT_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "积分商品ID"
},
{
"表名" : "order_product",
"列名" : "POINT_PRODUCT_SKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "积分商品规格ID"
},
{
"表名" : "order_product",
"列名" : "SEC_KILL_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "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",
"列描述" : "可用积分"
},
{
"表名" : "platform_balance",
"列名" : "TOTAL_INTEGRAL",
"数据类型" : "int",
"列描述" : "总积分, 某些积分可能因为订单状态暂不可用"
},
{
"表名" : "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)",
"列描述" : "该笔交易发生后余额"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product",
"列名" : "PRODUCT_DESC",
"数据类型" : "longtext",
"列描述" : "商品描述"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_NAME",
"数据类型" : "varchar(45)",
"列描述" : "商品名称"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_CODE",
"数据类型" : "varchar(45)",
"列描述" : "商品编码"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_BRIEF",
"数据类型" : "varchar(100)",
"列描述" : "商品简短描述"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_WEIGHT",
"数据类型" : "decimal(12,2)",
"列描述" : "商品重量"
},
{
"表名" : "point_product",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "商品单价"
},
{
"表名" : "point_product",
"列名" : "UNIT_PRICE_STANDARD",
"数据类型" : "decimal(12,2)",
"列描述" : "标准价格"
},
{
"表名" : "point_product",
"列名" : "TOTALUNIT",
"数据类型" : "int",
"列描述" : "商品总库存数量"
},
{
"表名" : "point_product",
"列名" : "SOLDUNIT",
"数据类型" : "int",
"列描述" : "商品已售数量"
},
{
"表名" : "point_product",
"列名" : "IS_SKU_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否多规格商品"
},
{
"表名" : "point_product",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品品类"
},
{
"表名" : "point_product",
"列名" : "PRODUCTBRAND_UUID",
"数据类型" : "varchar(36)",
"列描述" : "品牌"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_MAIN_IMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品主图"
},
{
"表名" : "point_product",
"列名" : "PRODUCTFREIGHT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "运费模板"
},
{
"表名" : "point_product",
"列名" : "PROMOTE_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "促销单价"
},
{
"表名" : "point_product",
"列名" : "MEMBERSHIP_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "会员单价"
},
{
"表名" : "point_product",
"列名" : "MARKET_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "市场价"
},
{
"表名" : "point_product",
"列名" : "PROMOTE_START_DATE",
"数据类型" : "timestamp",
"列描述" : "促销开始时间"
},
{
"表名" : "point_product",
"列名" : "PROMOTE_END_DATE",
"数据类型" : "timestamp",
"列描述" : "促销结束时间"
},
{
"表名" : "point_product",
"列名" : "WARN_UNIT",
"数据类型" : "int",
"列描述" : "库存预警数量"
},
{
"表名" : "point_product",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : "是否新品"
},
{
"表名" : "point_product",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热销"
},
{
"表名" : "point_product",
"列名" : "IS_PROMOTE",
"数据类型" : "tinyint(1)",
"列描述" : "是否参与促销"
},
{
"表名" : "point_product",
"列名" : "UNIT_POINT",
"数据类型" : "int",
"列描述" : "购买需要实际积分数"
},
{
"表名" : "point_product",
"列名" : "UNIT_POINT_STANDARD",
"数据类型" : "int",
"列描述" : "购买需要划线积分数"
},
{
"表名" : "point_product",
"列名" : "IS_RECOMMEND",
"数据类型" : "tinyint(1)",
"列描述" : "是否推荐商品"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "商品类型, 实物或者优惠券"
},
{
"表名" : "point_product",
"列名" : "IS_ON_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "上架,下架"
},
{
"表名" : "point_product",
"列名" : "IS_SHIPPING",
"数据类型" : "tinyint(1)",
"列描述" : "是否需要邮寄"
},
{
"表名" : "point_product",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "商家备注"
},
{
"表名" : "point_product",
"列名" : "PRODUCT_COST_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "商品成本价"
},
{
"表名" : "point_product_attr_value",
"列名" : "PRODUCTATTRVALUE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_attr_value",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "IS_CATE_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "point_product_attr_value",
"列名" : "PRODUCT_ATTR_NAME",
"数据类型" : "varchar(45)",
"列描述" : "属性名称"
},
{
"表名" : "point_product_attr_value",
"列名" : "PRODUCT_ATTR_VALUE",
"数据类型" : "varchar(100)",
"列描述" : "属性值"
},
{
"表名" : "point_product_cate",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_cate",
"列名" : "CATE_NAME",
"数据类型" : "varchar(45)",
"列描述" : "品类名称"
},
{
"表名" : "point_product_cate",
"列名" : "CATE_PATH",
"数据类型" : "varchar(500)",
"列描述" : "品类路径"
},
{
"表名" : "point_product_cate",
"列名" : "PARENTCATE_UUID",
"数据类型" : "varchar(46)",
"列描述" : "上级品类ID"
},
{
"表名" : "point_product_cate",
"列名" : "SORTNUMBER",
"数据类型" : "int",
"列描述" : "排序"
},
{
"表名" : "point_product_cate",
"列名" : "CATE_PIC_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图地址"
},
{
"表名" : "point_product_cate",
"列名" : "IS_LEAF",
"数据类型" : "tinyint(1)",
"列描述" : "是否叶子节点"
},
{
"表名" : "point_product_cate",
"列名" : "IS_DISPLAYED_HOME",
"数据类型" : "tinyint(1)",
"列描述" : "是否首页显示"
},
{
"表名" : "point_product_cate_attr",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(46)",
"列描述" : "品类ID"
},
{
"表名" : "point_product_cate_attr",
"列名" : "ATTR_NAME",
"数据类型" : "varchar(50)",
"列描述" : "属性名"
},
{
"表名" : "point_product_cate_attr",
"列名" : "ATTR_VALUE",
"数据类型" : "varchar(500)",
"列描述" : "属性值"
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_SPU_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_MANDATORY",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_MULTIPLE",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_INPUT",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_SKU_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_cate_attr",
"列名" : "IS_SEARCH_ATTR",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "PRODUCT_COLLECT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_collect",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_collect",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_collect",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "point_product_comment",
"列名" : "PRODUCTCOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_comment",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_comment",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_comment",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_comment",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_comment",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_comment",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_comment",
"列名" : "COMMENT_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "评论类容"
},
{
"表名" : "point_product_comment",
"列名" : "COMMENT_RANK",
"数据类型" : "int",
"列描述" : "评论打分"
},
{
"表名" : "point_product_comment",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发表评论会员ID"
},
{
"表名" : "point_product_comment",
"列名" : "REPLAY_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "回复内容"
},
{
"表名" : "point_product_comment",
"列名" : "EVALUATE_TIME",
"数据类型" : "timestamp",
"列描述" : "发表时间"
},
{
"表名" : "point_product_comment",
"列名" : "REPLAY_TIME",
"数据类型" : "timestamp",
"列描述" : "回复时间"
},
{
"表名" : "point_product_comment",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单ID"
},
{
"表名" : "point_product_comment",
"列名" : "IS_SHOW",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "PRODUCTCOMMENTIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_comment_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_comment_image",
"列名" : "PRODUCTCOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "评论ID"
},
{
"表名" : "point_product_comment_image",
"列名" : "IMAGEURL",
"数据类型" : "varchar(500)",
"列描述" : "图片地址"
},
{
"表名" : "point_product_comment_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_desc_image",
"列名" : "PRODUCTDESCIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_desc_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_desc_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_desc_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_desc_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_desc_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_desc_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_desc_image",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "文件地址ID"
},
{
"表名" : "point_product_image",
"列名" : "PRODUCTIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "point_product_image",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_sku",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_UNIT_POINT",
"数据类型" : "int",
"列描述" : "规格单价(积分)"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_UNIT_POINT_STANDARD",
"数据类型" : "int",
"列描述" : "规格划线单价(积分)"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_CODE",
"数据类型" : "varchar(45)",
"列描述" : "规格货号"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_TOTAL_UNIT",
"数据类型" : "int",
"列描述" : "规格库存"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_SOLD_UNIT",
"数据类型" : "int",
"列描述" : "规格已售数量"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_WARN_UNIT",
"数据类型" : "int",
"列描述" : "库存预警数量"
},
{
"表名" : "point_product_sku",
"列名" : "PRODUCT_SKU_ATTR_VALUE_UUIDS",
"数据类型" : "longtext",
"列描述" : "SKU对应的规格名和规格值"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "规格单价"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_UNIT_PRICE_STANDARD",
"数据类型" : "decimal(12,2)",
"列描述" : "规格标准单价"
},
{
"表名" : "point_product_sku",
"列名" : "SKU_IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "积分商品SKU图片"
},
{
"表名" : "point_product_sku_attr",
"列名" : "PRODUCTSKUATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_sku_attr",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_sku_attr",
"列名" : "IS_CATE_ATTR",
"数据类型" : "tinyint(1)",
"列描述" : "是否继承自品类属性"
},
{
"表名" : "point_product_sku_attr",
"列名" : "PRODUCTCATEATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品品类属性ID"
},
{
"表名" : "point_product_sku_attr",
"列名" : "PRODUCT_ATTR_NAME",
"数据类型" : "varchar(45)",
"列描述" : "商品品类名称"
},
{
"表名" : "point_product_sku_attr",
"列名" : "PRODUCT_ATTR_VALUE",
"数据类型" : "varchar(100)",
"列描述" : "暂不使用"
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "PRODUCTSKUATTRVALUE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "PRODUCTSKUATTR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格名ID"
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "PRODUCT_SKU_ATTR_VALUE",
"数据类型" : "varchar(45)",
"列描述" : "商品规格值"
},
{
"表名" : "point_product_sku_attr_value",
"列名" : "IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "规格主图"
},
{
"表名" : "point_product_video",
"列名" : "PRODUCTVIDEO_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "point_product_video",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_product_video",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "商品视频"
},
{
"表名" : "point_product_video",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_video",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_product_video",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_product_video",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "point_product_video",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "视频文件ID"
},
{
"表名" : "point_setting",
"列名" : "POINT_SETTING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "积分设置表"
},
{
"表名" : "point_setting",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "point_setting",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_setting",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_setting",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "point_setting",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "point_setting",
"列名" : "IS_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "point_setting",
"列名" : "AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "订单金额每多少元"
},
{
"表名" : "point_setting",
"列名" : "POINT",
"数据类型" : "int",
"列描述" : "赠送积分数"
},
{
"表名" : "print_setting",
"列名" : "PRINT_SETTING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "print_setting",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "print_setting",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "print_setting",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "print_setting",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "print_setting",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "print_setting",
"列名" : "FEIE_USER",
"数据类型" : "varchar(36)",
"列描述" : "飞鹅云账号"
},
{
"表名" : "print_setting",
"列名" : "FEIE_SN",
"数据类型" : "varchar(100)",
"列描述" : "飞鹅云打印机编号"
},
{
"表名" : "print_setting",
"列名" : "FEIE_KEY",
"数据类型" : "varchar(45)",
"列描述" : "飞鹅云打印机的KEY"
},
{
"表名" : "print_setting",
"列名" : "FEIE_UKEY",
"数据类型" : "varchar(45)",
"列描述" : "飞鹅云后台注册账号后生成的UKEY"
},
{
"表名" : "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",
"列描述" : "商品总库存数量"
},
{
"表名" : "product",
"列名" : "SOLDUNIT",
"数据类型" : "int",
"列描述" : "商品已售数量"
},
{
"表名" : "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",
"列描述" : "库存预警数量"
},
{
"表名" : "product",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : "是否新品"
},
{
"表名" : "product",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热销"
},
{
"表名" : "product",
"列名" : "IS_PROMOTE",
"数据类型" : "tinyint(1)",
"列描述" : "是否参与促销"
},
{
"表名" : "product",
"列名" : "UNIT_POINT",
"数据类型" : "int",
"列描述" : "购买需要实际积分数"
},
{
"表名" : "product",
"列名" : "UNIT_POINT_STANDARD",
"数据类型" : "int",
"列描述" : "购买需要划线积分数"
},
{
"表名" : "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",
"列名" : "VALID_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "有效类型(仅适用电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_DAYS",
"数据类型" : "int",
"列描述" : "多少天有效(仅适用电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_START_DATE",
"数据类型" : "date",
"列描述" : "有效开始时间(仅适用电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_END_DATE",
"数据类型" : "date",
"列描述" : "有效结束时间(仅适用电子卡券商品)"
},
{
"表名" : "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",
"列描述" : "排序"
},
{
"表名" : "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",
"列描述" : "排序"
},
{
"表名" : "product_cate",
"列名" : "CATE_PIC_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图地址"
},
{
"表名" : "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",
"列描述" : "评论打分"
},
{
"表名" : "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",
"列描述" : "计价方式(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",
"列描述" : "默认首件件数"
},
{
"表名" : "product_freight",
"列名" : "DEFAULT_NEXT_UNIT",
"数据类型" : "int",
"列描述" : "续件件数"
},
{
"表名" : "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_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",
"列描述" : "首件"
},
{
"表名" : "product_freight_region",
"列名" : "NEXT_UNIT",
"数据类型" : "int",
"列描述" : "续件"
},
{
"表名" : "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_inventory_inbound",
"列名" : "PRODUCT_INVENTORY_INBOUND_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_inventory_inbound",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_inventory_inbound",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_inbound",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_inbound",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_inbound",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_inbound",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_inventory_inbound",
"列名" : "PRODUCT_SKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格ID"
},
{
"表名" : "product_inventory_inbound",
"列名" : "SKU_NAME",
"数据类型" : "varchar(100)",
"列描述" : "商品规格名称"
},
{
"表名" : "product_inventory_inbound",
"列名" : "TRAN_UNIT",
"数据类型" : "int",
"列描述" : "入库数量"
},
{
"表名" : "product_inventory_inbound",
"列名" : "TRAN_TIME",
"数据类型" : "timestamp",
"列描述" : "入库时间"
},
{
"表名" : "product_inventory_inbound",
"列名" : "TRAN_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "入库类型"
},
{
"表名" : "product_inventory_inbound",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "product_inventory_outbound",
"列名" : "PRODUCT_INVENTORY_OUTBOUND_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_inventory_outbound",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_inventory_outbound",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_outbound",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_outbound",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_outbound",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_outbound",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_inventory_outbound",
"列名" : "PRODUCT_SKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格ID"
},
{
"表名" : "product_inventory_outbound",
"列名" : "SKU_NAME",
"数据类型" : "varchar(100)",
"列描述" : "商品规格名称"
},
{
"表名" : "product_inventory_outbound",
"列名" : "TRAN_UNIT",
"数据类型" : "int",
"列描述" : "出库数量"
},
{
"表名" : "product_inventory_outbound",
"列名" : "TRAN_TIME",
"数据类型" : "timestamp",
"列描述" : "出库时间"
},
{
"表名" : "product_inventory_outbound",
"列名" : "TRAN_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "出库类型"
},
{
"表名" : "product_inventory_outbound",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "product_inventory_taking",
"列名" : "PRODUCT_INVENTORY_TAKING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_inventory_taking",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_inventory_taking",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_taking",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_taking",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_inventory_taking",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_inventory_taking",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "product_inventory_taking",
"列名" : "PRODUCT_SKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格ID"
},
{
"表名" : "product_inventory_taking",
"列名" : "SKU_NAME",
"数据类型" : "varchar(100)",
"列描述" : "商品规格名称"
},
{
"表名" : "product_inventory_taking",
"列名" : "TRAN_UNIT",
"数据类型" : "int",
"列描述" : "盘点数量"
},
{
"表名" : "product_inventory_taking",
"列名" : "PROFIT_UNIT",
"数据类型" : "int",
"列描述" : "盘亏(赢)"
},
{
"表名" : "product_inventory_taking",
"列名" : "TRAN_TIME",
"数据类型" : "timestamp",
"列描述" : "盘点时间"
},
{
"表名" : "product_inventory_taking",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "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",
"列描述" : "规格单价(积分)"
},
{
"表名" : "product_sku",
"列名" : "SKU_UNIT_POINT_STANDARD",
"数据类型" : "int",
"列描述" : "规格划线单价(积分)"
},
{
"表名" : "product_sku",
"列名" : "SKU_CODE",
"数据类型" : "varchar(45)",
"列描述" : "规格货号"
},
{
"表名" : "product_sku",
"列名" : "SKU_TOTAL_UNIT",
"数据类型" : "int",
"列描述" : "规格库存"
},
{
"表名" : "product_sku",
"列名" : "SKU_SOLD_UNIT",
"数据类型" : "int",
"列描述" : "规格已售数量"
},
{
"表名" : "product_sku",
"列名" : "SKU_WARN_UNIT",
"数据类型" : "int",
"列描述" : "库存预警数量"
},
{
"表名" : "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",
"列名" : "SKU_IMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "商品SKU图片"
},
{
"表名" : "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_distribution",
"列名" : "PROFIT_DISTRIBUTION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_distribution",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_distribution",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_distribution",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_distribution",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_distribution",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_distribution",
"列名" : "NAME",
"数据类型" : "varchar(45)",
"列描述" : "分销名称"
},
{
"表名" : "profit_distribution",
"列名" : "IS_DISTRIBUTION_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启分销"
},
{
"表名" : "profit_distribution",
"列名" : "IS_DISTRIBUTOR_PURCHASE_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启分销内购，分销商自己购买商品，享受一级佣金，上级享受二级佣金，上上级享受三级佣金'"
},
{
"表名" : "profit_distribution",
"列名" : "DISTRIBUTION_LEVEL",
"数据类型" : "int",
"列描述" : "分销级数(支持1,2,3级分销)"
},
{
"表名" : "profit_distribution",
"列名" : "LEVEL1_RATE",
"数据类型" : "decimal(12,2)",
"列描述" : "1级分佣比例(不含%, 如3%则存值为3)"
},
{
"表名" : "profit_distribution",
"列名" : "LEVEL2_RATE",
"数据类型" : "decimal(12,2)",
"列描述" : "2级分佣比例(不含%, 如3%则存值为3)"
},
{
"表名" : "profit_distribution",
"列名" : "LEVEL3_RATE",
"数据类型" : "decimal(12,2)",
"列描述" : "3级分佣比例(不含%, 如3%则存值为3)"
},
{
"表名" : "profit_distribution",
"列名" : "APPLICATION_CONTENT",
"数据类型" : "longtext",
"列描述" : "分销申请页面内容"
},
{
"表名" : "profit_distribution",
"列名" : "IS_SHARE_REQUIRED",
"数据类型" : "tinyint(1)",
"列描述" : "是否需要分享"
},
{
"表名" : "profit_distribution",
"列名" : "IS_FORM_REQUIRED",
"数据类型" : "tinyint(1)",
"列描述" : "是否需要填写表单"
},
{
"表名" : "profit_distribution",
"列名" : "IS_APPROVE_REQUIRED",
"数据类型" : "tinyint(1)",
"列描述" : "是否需要审核"
},
{
"表名" : "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_welfare",
"列名" : "PROFIT_WELFARE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_welfare",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "WELFARE_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "福利类型(0-积分赠送, 1-优惠券赠送, 2-低价商品)"
},
{
"表名" : "profit_welfare",
"列名" : "POINT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启积分赠送"
},
{
"表名" : "profit_welfare",
"列名" : "POINT_GIVEN",
"数据类型" : "int",
"列描述" : "新会员获取积分"
},
{
"表名" : "profit_welfare",
"列名" : "COUPON_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启积分赠送"
},
{
"表名" : "profit_welfare",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "新用户赠送的优惠券"
},
{
"表名" : "profit_welfare",
"列名" : "COUPON_COUNT",
"数据类型" : "int",
"列描述" : "新用户赠送的优惠券数量"
},
{
"表名" : "profit_welfare",
"列名" : "RESOURCE_ENABLED",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "profit_welfare",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "新用户可低价购买资源"
},
{
"表名" : "profit_welfare",
"列名" : "RESOURCE_SALE_PRICE",
"数据类型" : "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",
"列描述" : "浏览次数"
},
{
"表名" : "qa",
"列名" : "ISPUBLISHED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发布"
},
{
"表名" : "qa",
"列名" : "ISHOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热门"
},
{
"表名" : "resource",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource",
"列名" : "RESOURCE_CATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源类目ID"
},
{
"表名" : "resource",
"列名" : "RESOURCE_ID",
"数据类型" : "varchar(45)",
"列描述" : "资源ID"
},
{
"表名" : "resource",
"列名" : "RESOURCE_NAME",
"数据类型" : "varchar(100)",
"列描述" : "资源名称"
},
{
"表名" : "resource",
"列名" : "RESOURCE_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "资源类型(1-文案,2-音频,3-视频,4-电子书)"
},
{
"表名" : "resource",
"列名" : "DIGEST",
"数据类型" : "longtext",
"列描述" : "摘要"
},
{
"表名" : "resource",
"列名" : "COVERIMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图"
},
{
"表名" : "resource",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "内容"
},
{
"表名" : "resource",
"列名" : "NUMBER_OF_READING",
"数据类型" : "int",
"列描述" : "浏览次数"
},
{
"表名" : "resource",
"列名" : "IS_PUBLISHED",
"数据类型" : "tinyint(1)",
"列描述" : "是否上架"
},
{
"表名" : "resource",
"列名" : "IS_PURCHASE_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否可购买"
},
{
"表名" : "resource",
"列名" : "LIST_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "划线价格"
},
{
"表名" : "resource",
"列名" : "SALE_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "实际销售价格"
},
{
"表名" : "resource",
"列名" : "SUB_RESOURCE_UNIT",
"数据类型" : "int",
"列描述" : "子资源数量"
},
{
"表名" : "resource",
"列名" : "RESOURCE_AUTHOR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "作者"
},
{
"表名" : "resource",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : "是否上新"
},
{
"表名" : "resource",
"列名" : "IS_RECOMMEND",
"数据类型" : "tinyint(1)",
"列描述" : "是否推荐"
},
{
"表名" : "resource",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热门"
},
{
"表名" : "resource_author",
"列名" : "RESOURCE_AUTHOR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_author",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_author",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_author",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_author",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_author",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_author",
"列名" : "AUTHOR_NAME",
"数据类型" : "varchar(100)",
"列描述" : "姓名"
},
{
"表名" : "resource_author",
"列名" : "AUTHOR_INTRODUCTTION",
"数据类型" : "longtext",
"列描述" : "作者简介"
},
{
"表名" : "resource_author",
"列名" : "PHOTO_URL",
"数据类型" : "varchar(500)",
"列描述" : "作者头像"
},
{
"表名" : "resource_cate",
"列名" : "RESOURCECATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_cate",
"列名" : "CATE_NAME",
"数据类型" : "varchar(45)",
"列描述" : "类目名称"
},
{
"表名" : "resource_cate",
"列名" : "CATE_PATH",
"数据类型" : "varchar(500)",
"列描述" : "类目路径"
},
{
"表名" : "resource_cate",
"列名" : "PARENTCATE_UUID",
"数据类型" : "varchar(46)",
"列描述" : "上级类目ID"
},
{
"表名" : "resource_cate",
"列名" : "SORTNUMBER",
"数据类型" : "int",
"列描述" : "排序"
},
{
"表名" : "resource_cate",
"列名" : "CATE_PIC_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图地址"
},
{
"表名" : "resource_cate",
"列名" : "IS_LEAF",
"数据类型" : "tinyint(1)",
"列描述" : "是否叶子节点"
},
{
"表名" : "resource_cate",
"列名" : "IS_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "resource_comment",
"列名" : "RESOURCE_COMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_comment",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_comment",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_comment",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_comment",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_comment",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_comment",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_comment",
"列名" : "COMMENT_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "评论类容"
},
{
"表名" : "resource_comment",
"列名" : "COMMENT_RANK",
"数据类型" : "int",
"列描述" : "评论打分"
},
{
"表名" : "resource_comment",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发表评论会员ID"
},
{
"表名" : "resource_comment",
"列名" : "REPLAY_CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "回复内容"
},
{
"表名" : "resource_comment",
"列名" : "EVALUATE_TIME",
"数据类型" : "timestamp",
"列描述" : "发表时间"
},
{
"表名" : "resource_comment",
"列名" : "REPLAY_TIME",
"数据类型" : "timestamp",
"列描述" : "回复时间"
},
{
"表名" : "resource_comment",
"列名" : "IS_SHOW",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "RESOURCE_FAVORITE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_favorite",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_favorite",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_favorite",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "resource_group",
"列名" : "RESOURCE_GROUP_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_group",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "GROUP_NAME",
"数据类型" : "varchar(20)",
"列描述" : "分组名称"
},
{
"表名" : "resource_group",
"列名" : "GROUP_DESCRIPTION",
"数据类型" : "varchar(100)",
"列描述" : "分组描述"
},
{
"表名" : "resource_group",
"列名" : "IS_DISPLAYED_HOME",
"数据类型" : "tinyint(1)",
"列描述" : "是否首页显示"
},
{
"表名" : "resource_group",
"列名" : "IS_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "IS_RECOMMEND",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "resource_group",
"列名" : "SORT_NUMBER",
"数据类型" : "int",
"列描述" : "排序"
},
{
"表名" : "resource_group",
"列名" : "BACKGROUND_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的背景图"
},
{
"表名" : "resource_group",
"列名" : "ICON_URL",
"数据类型" : "varchar(500)",
"列描述" : "显示在页面时的icon图标"
},
{
"表名" : "resource_group",
"列名" : "RESOURCE_UNIT",
"数据类型" : "int",
"列描述" : "资源组所含资源数量"
},
{
"表名" : "resource_group_resource",
"列名" : "RESOURCE_GROUP_RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_group_resource",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_group_resource",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_group_resource",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_group_resource",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_group_resource",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_group_resource",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_group_resource",
"列名" : "RESOURCE_GROUP_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源组ID"
},
{
"表名" : "resource_sub",
"列名" : "RESOURCE_SUB_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_sub",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_sub",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_sub",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_sub",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_sub",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_sub",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_sub",
"列名" : "SUB_RESOURCE_ID",
"数据类型" : "varchar(45)",
"列描述" : "子资源ID"
},
{
"表名" : "resource_sub",
"列名" : "SUB_NAME",
"数据类型" : "varchar(100)",
"列描述" : "子资源名称"
},
{
"表名" : "resource_sub",
"列名" : "SUB_SORT_NUMBER",
"数据类型" : "int",
"列描述" : "排序序列号"
},
{
"表名" : "resource_sub",
"列名" : "SUB_CONTENT",
"数据类型" : "longtext",
"列描述" : "内容"
},
{
"表名" : "resource_sub",
"列名" : "IS_AUDITION_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否可试读(试听, 试看)"
},
{
"表名" : "resource_sub",
"列名" : "DURATION",
"数据类型" : "int",
"列描述" : "视频或者音频时长"
},
{
"表名" : "resource_sub",
"列名" : "EXT_NAME",
"数据类型" : "varchar(10)",
"列描述" : "文件扩展名"
},
{
"表名" : "resource_tag",
"列名" : "RESOURCE_TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_tag",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_tag",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_tag",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_tag",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_tag",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_tag",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID\n"
},
{
"表名" : "resource_tag",
"列名" : "TAG_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "标签类型"
},
{
"表名" : "resource_tag",
"列名" : "TAG_NAME",
"数据类型" : "varchar(45)",
"列描述" : "标签名称"
},
{
"表名" : "resource_tag",
"列名" : "TAG_VALUE",
"数据类型" : "varchar(200)",
"列描述" : "标签值"
},
{
"表名" : "resource_tran",
"列名" : "RESOURCE_TRAN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_tran",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "resource_tran",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_tran",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "resource_tran",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "resource_tran",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(45)",
"列描述" : "交易编号"
},
{
"表名" : "resource_tran",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(200)",
"列描述" : "交易描述"
},
{
"表名" : "resource_tran",
"列名" : "IS_PAYED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已经支付"
},
{
"表名" : "resource_tran",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "resource_tran",
"列名" : "ACTUAL_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "实际支付金额"
},
{
"表名" : "resource_tran",
"列名" : "DEDUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "优惠金额"
},
{
"表名" : "resource_tran",
"列名" : "USER_COUPON_UUID",
"数据类型" : "varchar(45)",
"列描述" : "选择的优惠券"
},
{
"表名" : "resource_user_level",
"列名" : "RESOURCE_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "resource_user_level",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "resource_user_level",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_user_level",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_user_level",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "resource_user_level",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "resource_user_level",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "resource_user_level",
"列名" : "USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员等级"
},
{
"表名" : "resource_user_level",
"列名" : "IS_ACCESS_ENABLED",
"数据类型" : "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)",
"列描述" : "角色描述"
},
{
"表名" : "sec_kill_product",
"列名" : "SEC_KILL_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sec_kill_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sec_kill_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "商品ID"
},
{
"表名" : "sec_kill_product",
"列名" : "STOCK",
"数据类型" : "int",
"列描述" : "秒杀商品库存"
},
{
"表名" : "sec_kill_product",
"列名" : "SOLD_UNIT",
"数据类型" : "int",
"列描述" : "销量"
},
{
"表名" : "sec_kill_product",
"列名" : "UNIT_PRICE",
"数据类型" : "varchar(45)",
"列描述" : "秒杀价格"
},
{
"表名" : "sec_kill_product",
"列名" : "STATUS",
"数据类型" : "varchar(36)",
"列描述" : "秒杀商品状态(0-秒杀商品已下线, 1-秒杀商品已上线)"
},
{
"表名" : "sec_kill_product",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "秒杀开始时间"
},
{
"表名" : "sec_kill_product",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "秒杀结束时间"
},
{
"表名" : "sequence",
"列名" : "SEQUENCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sequence",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sequence",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sequence",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sequence",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sequence",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sequence",
"列名" : "SEQNAME",
"数据类型" : "varchar(30)",
"列描述" : "业务名称"
},
{
"表名" : "sequence",
"列名" : "NEXTNUM",
"数据类型" : "int",
"列描述" : "下一个编号"
},
{
"表名" : "sequence",
"列名" : "TRANDATE",
"数据类型" : "date",
"列描述" : "交易编号时间"
},
{
"表名" : "setting",
"列名" : "SETTING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "setting",
"列名" : "SETTING_NAME",
"数据类型" : "varchar(45)",
"列描述" : "配置项名称"
},
{
"表名" : "setting",
"列名" : "SETTING_VALUE",
"数据类型" : "varchar(400)",
"列描述" : "配置项值"
},
{
"表名" : "setting",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "setting",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "setting",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "setting",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "setting",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "setting",
"列名" : "SETTING_DESC",
"数据类型" : "varchar(200)",
"列描述" : "配置项描述"
},
{
"表名" : "shopping_cart",
"列名" : "SHOPPINGCART_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "shopping_cart",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "shopping_cart",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "shopping_cart",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "shopping_cart",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "shopping_cart",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "shopping_cart",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "shopping_cart",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "shopping_cart",
"列名" : "UNIT",
"数据类型" : "int",
"列描述" : "商品数量"
},
{
"表名" : "shopping_cart",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品规格ID"
},
{
"表名" : "sign_setting",
"列名" : "SIGN_SETTING_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sign_setting",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sign_setting",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sign_setting",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sign_setting",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sign_setting",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sign_setting",
"列名" : "IS_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "sign_setting",
"列名" : "DAY1_POINT",
"数据类型" : "int",
"列描述" : "连续签到1天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY2_POINT",
"数据类型" : "int",
"列描述" : "连续签到2天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY3_POINT",
"数据类型" : "int",
"列描述" : "连续签到3天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY4_POINT",
"数据类型" : "int",
"列描述" : "连续签到4天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY5_POINT",
"数据类型" : "int",
"列描述" : "连续签到5天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY6_POINT",
"数据类型" : "int",
"列描述" : "连续签到6天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "DAY7_POINT",
"数据类型" : "int",
"列描述" : "连续签到7天获得积分"
},
{
"表名" : "sign_setting",
"列名" : "BACKGROUND_URL",
"数据类型" : "varchar(500)",
"列描述" : "签到成功背景图"
},
{
"表名" : "sign_setting",
"列名" : "RULE_URL",
"数据类型" : "varchar(500)",
"列描述" : "积分规则背景图"
},
{
"表名" : "summary_day",
"列名" : "datelist",
"数据类型" : "date",
"列描述" : ""
},
{
"表名" : "summary_month",
"列名" : "year",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_month",
"列名" : "monthlist",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_quarter",
"列名" : "year",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_quarter",
"列名" : "quarterlist",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_week",
"列名" : "year",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_week",
"列名" : "weeklist",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "summary_year",
"列名" : "yearlist",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "SWIPER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "swiper",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "swiper",
"列名" : "URL",
"数据类型" : "varchar(300)",
"列描述" : "轮播图图片地址"
},
{
"表名" : "swiper",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "轮播图点击后的内容"
},
{
"表名" : "swiper",
"列名" : "LINK_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "轮播图点击后跳转的类型(文章, 商品)"
},
{
"表名" : "swiper",
"列名" : "RESOURCE_CATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "轮播图关联的资源类目"
},
{
"表名" : "swiper",
"列名" : "LOCATION",
"数据类型" : "varchar(45)",
"列描述" : "轮播图位置:首页和资源分类页"
},
{
"表名" : "sys_log",
"列名" : "SYSLOG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sys_log",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sys_log",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sys_log",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sys_log",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sys_log",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sys_log",
"列名" : "LOG_DATE",
"数据类型" : "timestamp",
"列描述" : "日志日期"
},
{
"表名" : "sys_log",
"列名" : "LOG_USER_ID",
"数据类型" : "varchar(45)",
"列描述" : "涉及的会员ID"
},
{
"表名" : "sys_log",
"列名" : "LOG_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "人工或系统日志"
},
{
"表名" : "sys_log",
"列名" : "LOG_CATEGORY",
"数据类型" : "varchar(45)",
"列描述" : "日志类型"
},
{
"表名" : "sys_log",
"列名" : "LOG_DETAIL",
"数据类型" : "varchar(200)",
"列描述" : "日志详情"
},
{
"表名" : "tag",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "tag",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "tag",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "tag",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "tag",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "tag",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "tag",
"列名" : "TAG_TYPE",
"数据类型" : "varchar(20)",
"列描述" : "标签类型"
},
{
"表名" : "tag",
"列名" : "TAG_NAME",
"数据类型" : "varchar(45)",
"列描述" : "标签名称"
},
{
"表名" : "user",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user",
"列名" : "ID",
"数据类型" : "varchar(24)",
"列描述" : "会员编号"
},
{
"表名" : "user",
"列名" : "PHOTOURL",
"数据类型" : "varchar(500)",
"列描述" : "会员头像"
},
{
"表名" : "user",
"列名" : "NAME",
"数据类型" : "varchar(20)",
"列描述" : "姓名"
},
{
"表名" : "user",
"列名" : "IDCARDNO",
"数据类型" : "varchar(45)",
"列描述" : "身份证号码"
},
{
"表名" : "user",
"列名" : "SEX",
"数据类型" : "varchar(32)",
"列描述" : "性别"
},
{
"表名" : "user",
"列名" : "PERSONALEMAIL",
"数据类型" : "varchar(40)",
"列描述" : "电子邮箱"
},
{
"表名" : "user",
"列名" : "PERSONALPHONE",
"数据类型" : "varchar(17)",
"列描述" : "电话号码"
},
{
"表名" : "user",
"列名" : "PERSONALPHONE_COUNTRYCODE",
"数据类型" : "varchar(4)",
"列描述" : "电话号码国家代码"
},
{
"表名" : "user",
"列名" : "OPENID",
"数据类型" : "varchar(45)",
"列描述" : "小程序open id"
},
{
"表名" : "user",
"列名" : "REGISTER_DATE",
"数据类型" : "timestamp",
"列描述" : "注册日期"
},
{
"表名" : "user",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否激活"
},
{
"表名" : "user",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "user",
"列名" : "OPENID_OFC",
"数据类型" : "varchar(45)",
"列描述" : "公众号OPENID"
},
{
"表名" : "user",
"列名" : "UNIONID",
"数据类型" : "varchar(45)",
"列描述" : "微信开放平台unionID"
},
{
"表名" : "user",
"列名" : "IS_NOTIFICATION_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启消息通知"
},
{
"表名" : "user",
"列名" : "SUPERVISOR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "上级会员(具有推广权并能获取收益)"
},
{
"表名" : "user",
"列名" : "INVITATION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "邀请会员(直接邀请人)"
},
{
"表名" : "user",
"列名" : "USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员等级ID"
},
{
"表名" : "user",
"列名" : "USER_LEVEL_EXPIRE_DATE",
"数据类型" : "date",
"列描述" : "会员到期日期"
},
{
"表名" : "user",
"列名" : "IS_PROFIT_WELFARE_RECEIVED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已领取新人福利"
},
{
"表名" : "user",
"列名" : "PREVIOUS_USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "等级变化前会员等级"
},
{
"表名" : "user",
"列名" : "PREVIOUS_USER_LEVEL_EXPIRE_DATE",
"数据类型" : "date",
"列描述" : "等级变化前会员到期日期"
},
{
"表名" : "user_auth",
"列名" : "USERAUTH_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_auth",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_auth",
"列名" : "PASSWORD",
"数据类型" : "varchar(100)",
"列描述" : "密码(MD5)"
},
{
"表名" : "user_auth",
"列名" : "LASTLOGINTIME",
"数据类型" : "timestamp",
"列描述" : "最近登录时间"
},
{
"表名" : "user_auth",
"列名" : "FAILCOUNT",
"数据类型" : "int",
"列描述" : "登录失败次数"
},
{
"表名" : "user_auth",
"列名" : "ISLOCKED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_auth",
"列名" : "SUCCESSCOUNT",
"数据类型" : "int",
"列描述" : "总登录次数"
},
{
"表名" : "user_auth",
"列名" : "ISACTIVATED",
"数据类型" : "tinyint(1)",
"列描述" : "是否激活"
},
{
"表名" : "user_award",
"列名" : "USERAWARD_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_award",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_award",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_award",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_award",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_award",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_award",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_award",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "奖励类型"
},
{
"表名" : "user_award",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "奖励时间"
},
{
"表名" : "user_award",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "奖励金额"
},
{
"表名" : "user_award",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "user_award",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(200)",
"列描述" : "交易描述"
},
{
"表名" : "user_award",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "user_balance",
"列名" : "USERBALANCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_balance",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_balance",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_balance",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_balance",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_balance",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_balance",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_balance",
"列名" : "AVAILABLE_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "可用余额"
},
{
"表名" : "user_balance",
"列名" : "LEDGER_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "未到账金额"
},
{
"表名" : "user_balance",
"列名" : "AVAILABLE_POINT",
"数据类型" : "int",
"列描述" : "可用积分"
},
{
"表名" : "user_balance",
"列名" : "LEDGER_POINT",
"数据类型" : "int",
"列描述" : "未到账积分"
},
{
"表名" : "user_charge",
"列名" : "USER_CHARGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_charge",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_charge",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_charge",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_charge",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_charge",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_charge",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_charge",
"列名" : "CHARGE_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "充值金额"
},
{
"表名" : "user_charge",
"列名" : "CHARGE_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "充值状态"
},
{
"表名" : "user_charge",
"列名" : "FAIL_REASON",
"数据类型" : "varchar(100)",
"列描述" : "充值失败原因"
},
{
"表名" : "user_charge",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "支付方式(微信,支付宝)"
},
{
"表名" : "user_charge",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "user_charge",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "user_charge",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "user_charge",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "user_charge",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "user_charge",
"列名" : "CHARGE_TIME",
"数据类型" : "timestamp",
"列描述" : "充值时间"
},
{
"表名" : "user_charge",
"列名" : "CHARGE_NO",
"数据类型" : "varchar(45)",
"列描述" : "充值交易编号"
},
{
"表名" : "user_charge",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信或支付宝交易号"
},
{
"表名" : "user_charge",
"列名" : "BALANCE_BEFORE",
"数据类型" : "decimal(12,2)",
"列描述" : "充值前余额"
},
{
"表名" : "user_charge",
"列名" : "BALANCE_AFTER",
"数据类型" : "decimal(12,2)",
"列描述" : "充值后余额"
},
{
"表名" : "user_coupon",
"列名" : "USERCOUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_coupon",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_coupon",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_coupon",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_coupon",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_coupon",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_coupon",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_coupon",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "优惠券ID"
},
{
"表名" : "user_coupon",
"列名" : "IS_USED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已使用"
},
{
"表名" : "user_coupon",
"列名" : "USE_TIME",
"数据类型" : "timestamp",
"列描述" : "使用时间"
},
{
"表名" : "user_coupon",
"列名" : "USE_CHANNEL",
"数据类型" : "varchar(45)",
"列描述" : "使用方式"
},
{
"表名" : "user_coupon",
"列名" : "RECEIVE_CHANNEL",
"数据类型" : "varchar(45)",
"列描述" : "领取方式"
},
{
"表名" : "user_coupon",
"列名" : "RECEIVE_TIME",
"数据类型" : "timestamp",
"列描述" : "领取时间"
},
{
"表名" : "user_coupon",
"列名" : "VALID_START_DATE",
"数据类型" : "date",
"列描述" : "有效期开始日期"
},
{
"表名" : "user_coupon",
"列名" : "VALID_END_DATE",
"数据类型" : "date",
"列描述" : "有效期结束日期"
},
{
"表名" : "user_delivery",
"列名" : "USERDELIVERY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_delivery",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_delivery",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_delivery",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_delivery",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_delivery",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_delivery",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "提货状态"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_ADDRESS",
"数据类型" : "varchar(100)",
"列描述" : "提货地址"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "邮寄或者自提"
},
{
"表名" : "user_delivery",
"列名" : "APPLICATION_TIME",
"数据类型" : "timestamp",
"列描述" : "提货申请时间"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_TIME",
"数据类型" : "timestamp",
"列描述" : "实际提货时间"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_QUANTITY",
"数据类型" : "int",
"列描述" : "提货数量"
},
{
"表名" : "user_delivery",
"列名" : "COURIER_NAME",
"数据类型" : "varchar(45)",
"列描述" : "物流公司"
},
{
"表名" : "user_delivery",
"列名" : "COURIER_NO",
"数据类型" : "varchar(45)",
"列描述" : "物流编号"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_POSTCODE",
"数据类型" : "varchar(6)",
"列描述" : "邮编"
},
{
"表名" : "user_delivery",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "user_delivery",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "提货商家"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_NAME",
"数据类型" : "varchar(45)",
"列描述" : "收货人姓名"
},
{
"表名" : "user_delivery",
"列名" : "DELIVERY_CONTACTNO",
"数据类型" : "varchar(45)",
"列描述" : "收货人联系电话"
},
{
"表名" : "user_delivery_address",
"列名" : "USERDELIVERYADDRESS_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_delivery_address",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_delivery_address",
"列名" : "NAME",
"数据类型" : "varchar(20)",
"列描述" : "收货人姓名"
},
{
"表名" : "user_delivery_address",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_delivery_address",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_delivery_address",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_delivery_address",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_delivery_address",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_delivery_address",
"列名" : "TELEPHONE",
"数据类型" : "varchar(12)",
"列描述" : "收货人电话"
},
{
"表名" : "user_delivery_address",
"列名" : "TELEPHONE2",
"数据类型" : "varchar(12)",
"列描述" : "收货人电话2"
},
{
"表名" : "user_delivery_address",
"列名" : "COUNTRY",
"数据类型" : "varchar(25)",
"列描述" : "国家"
},
{
"表名" : "user_delivery_address",
"列名" : "PROVINCE",
"数据类型" : "varchar(15)",
"列描述" : "省"
},
{
"表名" : "user_delivery_address",
"列名" : "CITY",
"数据类型" : "varchar(15)",
"列描述" : "市"
},
{
"表名" : "user_delivery_address",
"列名" : "AREA",
"数据类型" : "varchar(15)",
"列描述" : "区"
},
{
"表名" : "user_delivery_address",
"列名" : "STREET",
"数据类型" : "varchar(100)",
"列描述" : "详细地址"
},
{
"表名" : "user_delivery_address",
"列名" : "ZIPCODE",
"数据类型" : "varchar(6)",
"列描述" : "邮编"
},
{
"表名" : "user_delivery_address",
"列名" : "IS_DEFAULT",
"数据类型" : "tinyint(1)",
"列描述" : "是否默认地址"
},
{
"表名" : "user_level",
"列名" : "USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_level",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "NAME",
"数据类型" : "varchar(45)",
"列描述" : "等级名称"
},
{
"表名" : "user_level",
"列名" : "PRODUCT_DISCOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "商品折扣"
},
{
"表名" : "user_level",
"列名" : "IS_RECRUIT_PROFIT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否可招募会员"
},
{
"表名" : "user_level",
"列名" : "IS_SALE_PROFIT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否可销售商品"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_USER_COUNT_DIRECT",
"数据类型" : "int",
"列描述" : "到达该等级所需直邀会员数"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_USER_COUNT_TEAM",
"数据类型" : "int",
"列描述" : "到达该等级所需团队会员数"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_PRODUCT_AMOUNT_DIRECT",
"数据类型" : "decimal(12,2)",
"列描述" : "到达该等级需直接销售金额"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_PRODUCT_AMOUNT_TEAM",
"数据类型" : "decimal(12,2)",
"列描述" : "到达该等级需团队销售金额"
},
{
"表名" : "user_level",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "会员备注"
},
{
"表名" : "user_level",
"列名" : "IS_REQUIRED_BY_USER",
"数据类型" : "tinyint(1)",
"列描述" : "升级至该会员等级条件按会员数量"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_BY_USER_SYMBOL",
"数据类型" : "varchar(10)",
"列描述" : "直邀, 团队会员数量(OR, AND)"
},
{
"表名" : "user_level",
"列名" : "IS_REQUIRED_BY_AMOUNT",
"数据类型" : "tinyint(1)",
"列描述" : "升级至该会员等级条件按销售金额"
},
{
"表名" : "user_level",
"列名" : "REQUIRED_BY_AMOUNT_SYMBOL",
"数据类型" : "varchar(10)",
"列描述" : "直邀, 团队会员数量(OR, AND)"
},
{
"表名" : "user_level",
"列名" : "IS_DEFAULT",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "DEPTH",
"数据类型" : "int",
"列描述" : "等级深度"
},
{
"表名" : "user_level",
"列名" : "WEEK_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "MONTH_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "QUARTER_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "YEAR_HALF_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "user_level",
"列名" : "YEAR_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "USERPOINTSTATEMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_point_statement",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_point_statement",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_point_statement",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "交易类型"
},
{
"表名" : "user_point_statement",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "user_point_statement",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "user_point_statement",
"列名" : "TRANSACTION_POINT",
"数据类型" : "int",
"列描述" : "交易积分"
},
{
"表名" : "user_point_statement",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(500)",
"列描述" : "交易描述"
},
{
"表名" : "user_point_statement",
"列名" : "POINTBEFORE",
"数据类型" : "int",
"列描述" : "交易前积分余额"
},
{
"表名" : "user_point_statement",
"列名" : "POINTAFTER",
"数据类型" : "int",
"列描述" : "交易后积分余额"
},
{
"表名" : "user_resource",
"列名" : "USER_RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_resource",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_resource",
"列名" : "RESOURCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "资源ID"
},
{
"表名" : "user_resource",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_resource",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_resource",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_resource",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_resource",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "USERSIGN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_sign",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_sign",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_sign",
"列名" : "SIGN_TIME",
"数据类型" : "timestamp",
"列描述" : "签到时间"
},
{
"表名" : "user_sign",
"列名" : "SIGN_POINT",
"数据类型" : "int",
"列描述" : "获得积分"
},
{
"表名" : "user_statement",
"列名" : "USERSTATEMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_statement",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_statement",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_statement",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_statement",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_statement",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_statement",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "交易类型"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_POINT",
"数据类型" : "int",
"列描述" : "交易积分"
},
{
"表名" : "user_statement",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(500)",
"列描述" : "交易描述"
},
{
"表名" : "user_statement",
"列名" : "BALANCEBEFORE",
"数据类型" : "decimal(12,2)",
"列描述" : "交易前资金余额"
},
{
"表名" : "user_statement",
"列名" : "BALANCEAFTER",
"数据类型" : "decimal(12,2)",
"列描述" : "交易后资金余额"
},
{
"表名" : "user_statement",
"列名" : "POINTBEFORE",
"数据类型" : "int",
"列描述" : "交易前积分余额"
},
{
"表名" : "user_statement",
"列名" : "POINTAFTER",
"数据类型" : "int",
"列描述" : "交易后积分余额"
},
{
"表名" : "user_token",
"列名" : "USERTOKEN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_token",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_token",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_token",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_token",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_token",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_token",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_token",
"列名" : "TOKENID",
"数据类型" : "varchar(36)",
"列描述" : "token"
},
{
"表名" : "user_token",
"列名" : "LOGINTIME",
"数据类型" : "timestamp",
"列描述" : "登录时间"
},
{
"表名" : "user_token",
"列名" : "EXPIRETIME",
"数据类型" : "timestamp",
"列描述" : "过期时间"
},
{
"表名" : "user_tree",
"列名" : "USER_TREE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_tree",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_tree",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_tree",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_tree",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_tree",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_tree",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_tree",
"列名" : "ANCESTOR_UUID",
"数据类型" : "varchar(36)",
"列描述" : "上级会员ID"
},
{
"表名" : "user_tree",
"列名" : "LEVEL",
"数据类型" : "int",
"列描述" : "上级深度(每个会员是自己的上级会员, 会员深度为0)"
},
{
"表名" : "user_upgrade",
"列名" : "USER_UPGRADE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_upgrade",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_upgrade",
"列名" : "USER_LEVEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "购买的会员等级"
},
{
"表名" : "user_upgrade",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "user_upgrade",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "user_upgrade",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(45)",
"列描述" : "交易编号"
},
{
"表名" : "user_upgrade",
"列名" : "TRANSACTION_DESC",
"数据类型" : "varchar(200)",
"列描述" : "交易描述"
},
{
"表名" : "user_upgrade",
"列名" : "PERIOD_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "期限类型(DAY/WEEK/MONTH/YEAR)"
},
{
"表名" : "user_upgrade",
"列名" : "PERIOD_NUMBER",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "IS_PAYED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已经支付"
},
{
"表名" : "user_upgrade",
"列名" : "EXPIRE_DATE",
"数据类型" : "date",
"列描述" : "到期日期"
},
{
"表名" : "user_upgrade",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_upgrade",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "USER_VOUCHER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_voucher",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_voucher",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单ID"
},
{
"表名" : "user_voucher",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商品ID"
},
{
"表名" : "user_voucher",
"列名" : "NAME",
"数据类型" : "varchar(45)",
"列描述" : "卡券名称"
},
{
"表名" : "user_voucher",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "卡券适用须知"
},
{
"表名" : "user_voucher",
"列名" : "VOUCHER_CODE",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "user_voucher",
"列名" : "QR_CODE_URL",
"数据类型" : "varchar(500)",
"列描述" : "二维码地址"
},
{
"表名" : "user_voucher",
"列名" : "BAR_CODE_URL",
"数据类型" : "varchar(500)",
"列描述" : "条形码地址"
},
{
"表名" : "user_voucher",
"列名" : "VALID_START_DATE",
"数据类型" : "date",
"列描述" : "有效开始时间"
},
{
"表名" : "user_voucher",
"列名" : "VALID_END_DATE",
"数据类型" : "date",
"列描述" : "有效结束时间"
},
{
"表名" : "user_voucher",
"列名" : "RECEIVE_TIME",
"数据类型" : "timestamp",
"列描述" : "卡券获取时间"
},
{
"表名" : "user_voucher",
"列名" : "IS_USED",
"数据类型" : "tinyint(1)",
"列描述" : "是否使用"
},
{
"表名" : "user_voucher",
"列名" : "USE_TIME",
"数据类型" : "timestamp",
"列描述" : "使用时间"
},
{
"表名" : "user_wechat",
"列名" : "USERWECHAT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_wechat",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "user_wechat",
"列名" : "OPENID",
"数据类型" : "varchar(50)",
"列描述" : "微信OPEN ID"
},
{
"表名" : "user_wechat",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_wechat",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_wechat",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_wechat",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_wechat",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "USERWITHDRAW_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "user_withdraw",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "user_withdraw",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "user_withdraw",
"列名" : "WITHDRAW_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "提现金额"
},
{
"表名" : "user_withdraw",
"列名" : "WITHDRAW_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "提现状态"
},
{
"表名" : "user_withdraw",
"列名" : "FAIL_REASON",
"数据类型" : "varchar(100)",
"列描述" : "提现失败原因"
},
{
"表名" : "user_withdraw",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "提现支付方式"
},
{
"表名" : "user_withdraw",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "user_withdraw",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "user_withdraw",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "user_withdraw",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "user_withdraw",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "user_withdraw",
"列名" : "WITHDRAW_TIME",
"数据类型" : "timestamp",
"列描述" : "提现时间"
},
{
"表名" : "user_withdraw",
"列名" : "VERIFY_TIME",
"数据类型" : "timestamp",
"列描述" : "审核时间"
},
{
"表名" : "user_withdraw",
"列名" : "TRANSFER_TIME",
"数据类型" : "timestamp",
"列描述" : "打款时间"
},
{
"表名" : "user_withdraw",
"列名" : "WITHDRAW_NO",
"数据类型" : "varchar(45)",
"列描述" : "提现交易编号"
},
{
"表名" : "user_withdraw",
"列名" : "REJECT_REASON",
"数据类型" : "varchar(100)",
"列描述" : "审核拒绝理由"
},
{
"表名" : "user_withdraw",
"列名" : "COMPLETE_TIME",
"数据类型" : "timestamp",
"列描述" : "提现成功时间"
},
{
"表名" : "user_withdraw",
"列名" : "PAYMENT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "提现金额"
},
{
"表名" : "user_withdraw",
"列名" : "TAX_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "手续费"
},
{
"表名" : "user_withdraw",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "verification_code",
"列名" : "VERIFICATIONCODE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "verification_code",
"列名" : "TYPE",
"数据类型" : "varchar(1)",
"列描述" : "验证码发放渠道类型(邮件,短信)"
},
{
"表名" : "verification_code",
"列名" : "MOBILE_COUNTRYCODE",
"数据类型" : "varchar(4)",
"列描述" : "手机号国际代码"
},
{
"表名" : "verification_code",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "verification_code",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "verification_code",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "verification_code",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "verification_code",
"列名" : "MOBILE_NUMBER",
"数据类型" : "varchar(11)",
"列描述" : "手机号码"
},
{
"表名" : "verification_code",
"列名" : "CODE",
"数据类型" : "varchar(8)",
"列描述" : "验证码"
},
{
"表名" : "verification_code",
"列名" : "EMAIL",
"数据类型" : "varchar(40)",
"列描述" : "邮件地址"
},
{
"表名" : "verification_code",
"列名" : "EXPIRE_TIME",
"数据类型" : "timestamp",
"列描述" : "过期时间"
},
{
"表名" : "verification_code",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
}
]