[
{
"表名" : "ad",
"列名" : "AD_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "ad",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "ad",
"列名" : "URL",
"数据类型" : "varchar(300)",
"列描述" : "广告图片地址"
},
{
"表名" : "ad",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "广告图点击后的内容"
},
{
"表名" : "ad",
"列名" : "LINK_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "广告图点击后跳转的类型(文章, 服务项目)"
},
{
"表名" : "ad",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "广告图关联的服务类目"
},
{
"表名" : "ad",
"列名" : "LOCATION",
"数据类型" : "varchar(45)",
"列描述" : "广告图位置:首页和服务分类页"
},
{
"表名" : "ad",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "admin",
"列名" : "ADMIN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "admin",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : "是否删除"
},
{
"表名" : "admin",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : "记录创建时间"
},
{
"表名" : "admin",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "记录创建人员"
},
{
"表名" : "admin",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : "最近一次更新时间"
},
{
"表名" : "admin",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : "最近一次更新人员"
},
{
"表名" : "admin",
"列名" : "EMAIL",
"数据类型" : "varchar(40)",
"列描述" : "电子邮箱地址"
},
{
"表名" : "admin",
"列名" : "ID",
"数据类型" : "varchar(30)",
"列描述" : "用户ID"
},
{
"表名" : "admin",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "admin",
"列名" : "PASSWORD",
"数据类型" : "varchar(100)",
"列描述" : "密码(MD5)"
},
{
"表名" : "admin",
"列名" : "LASTLOGINTIME",
"数据类型" : "timestamp",
"列描述" : "最近一次登录时间"
},
{
"表名" : "admin",
"列名" : "FAILCOUNT",
"数据类型" : "int",
"列描述" : "登录失败次数"
},
{
"表名" : "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",
"列描述" : "地区排序"
},
{
"表名" : "area",
"列名" : "FIRST_CHARACTER",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "area",
"列名" : "ABBR_CHARACTER",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "area",
"列名" : "FULL_CHARACTER",
"数据类型" : "varchar(100)",
"列描述" : ""
},
{
"表名" : "area",
"列名" : "IS_SERVICE_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "ARTICLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "article",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "article",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "内容"
},
{
"表名" : "article",
"列名" : "TITLE",
"数据类型" : "varchar(200)",
"列描述" : ""
},
{
"表名" : "article",
"列名" : "COVERIMAGE_URL",
"数据类型" : "varchar(500)",
"列描述" : "主图"
},
{
"表名" : "article",
"列名" : "MEDIA_ID",
"数据类型" : "varchar(200)",
"列描述" : "微信公众号文章media_id"
},
{
"表名" : "article",
"列名" : "IS_FROM_OFFICIALACCOUNT",
"数据类型" : "tinyint(1)",
"列描述" : "是否引用公众号文章"
},
{
"表名" : "article",
"列名" : "LINK_TYPE",
"数据类型" : "varchar(50)",
"列描述" : "链接类型"
},
{
"表名" : "article",
"列名" : "PUBLISH_TIME",
"数据类型" : "timestamp",
"列描述" : "发布时间"
},
{
"表名" : "article",
"列名" : "DIGEST",
"数据类型" : "varchar(200)",
"列描述" : "摘要"
},
{
"表名" : "article",
"列名" : "NUMBER_OF_READING",
"数据类型" : "int",
"列描述" : "浏览次数"
},
{
"表名" : "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)",
"列描述" : ""
},
{
"表名" : "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_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_MERCHANT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_ACTIVE_MODE_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "抢单模式是否开启"
},
{
"表名" : "global_setting",
"列名" : "APPLICATION_SALES_PHONE",
"数据类型" : "varchar(20)",
"列描述" : "服务电话"
},
{
"表名" : "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(200)",
"列描述" : "微信退款回调地址"
},
{
"表名" : "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",
"列名" : "SMS_TEMPLATE_CODE_APPLICATION_APPROVED",
"数据类型" : "varchar(45)",
"列描述" : "商家入驻申请审核通过短信模板"
},
{
"表名" : "global_setting",
"列名" : "SMS_TEMPLATE_CODE_APPLICATION_REJECTED",
"数据类型" : "varchar(45)",
"列描述" : "商家入驻申请审核未通过短信模板"
},
{
"表名" : "global_setting",
"列名" : "LIVE_WECHAT_PROVIDER",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "LIVE_WECHAT_PUBLIC_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "LIVE_WECHAT_PRIVATE_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "global_setting",
"列名" : "LIVE_WECHAT_FINDER_USER_NAME",
"数据类型" : "varchar(1000)",
"列描述" : ""
},
{
"表名" : "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)",
"列描述" : "是否会员注册专用"
},
{
"表名" : "group",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "GROUP_BUY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "GROUP_BUY_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动ID"
},
{
"表名" : "group_buy",
"列名" : "OWNER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "group_buy",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "团购发起时间"
},
{
"表名" : "group_buy",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "团购结束时间"
},
{
"表名" : "group_buy",
"列名" : "STATUS",
"数据类型" : "varchar(10)",
"列描述" : "拼团状态"
},
{
"表名" : "group_buy_def",
"列名" : "GROUP_BUY_DEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_def",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def",
"列名" : "NAME",
"数据类型" : "varchar(100)",
"列描述" : "活动 名称"
},
{
"表名" : "group_buy_def",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "活动开始时间"
},
{
"表名" : "group_buy_def",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "活动结束时间"
},
{
"表名" : "group_buy_def",
"列名" : "STATUS",
"数据类型" : "varchar(36)",
"列描述" : "团购服务状态(0-团购服务已下线, 1-团购服务已上线)"
},
{
"表名" : "group_buy_def",
"列名" : "MIN_USER_COUNT",
"数据类型" : "int",
"列描述" : "最少成团人数"
},
{
"表名" : "group_buy_def",
"列名" : "MAX_TRAN_DAYS",
"数据类型" : "int",
"列描述" : "成团有效期(天)"
},
{
"表名" : "group_buy_def_merchant",
"列名" : "GROUP_BUY_DEF_MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_def_merchant",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_def_merchant",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def_merchant",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def_merchant",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_def_merchant",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_def_merchant",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家"
},
{
"表名" : "group_buy_def_merchant",
"列名" : "GROUP_BUY_DEF_UUID",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "GROUP_BUY_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_product",
"列名" : "GROUP_BUY_DEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动表"
},
{
"表名" : "group_buy_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "服务项目ID"
},
{
"表名" : "group_buy_product",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "团购价格"
},
{
"表名" : "group_buy_product",
"列名" : "STOCK",
"数据类型" : "int",
"列描述" : "团购服务项目库存"
},
{
"表名" : "group_buy_product",
"列名" : "SOLD_UNIT",
"数据类型" : "int",
"列描述" : "销量"
},
{
"表名" : "group_buy_user",
"列名" : "GROUP_BUY_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "group_buy_user",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "group_buy_user",
"列名" : "GROUP_BUY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "团购活动ID"
},
{
"表名" : "group_buy_user",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "参与拼团人员"
},
{
"表名" : "group_buy_user",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "拼团对应的订单ID"
},
{
"表名" : "group_buy_user",
"列名" : "JOIN_TIME",
"数据类型" : "timestamp",
"列描述" : "参与拼团的时间"
},
{
"表名" : "group_buy_user",
"列名" : "IS_OWNER",
"数据类型" : "tinyint(1)",
"列描述" : "是否团购发起人"
},
{
"表名" : "logistics",
"列名" : "LOGISTICS_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "NAME",
"数据类型" : "varchar(20)",
"列描述" : "物流公司名称"
},
{
"表名" : "logistics",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "logistics",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "MATERIA_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "TYPE",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "materia",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "联系电话"
},
{
"表名" : "merchant",
"列名" : "MERCHANTNAME",
"数据类型" : "varchar(100)",
"列描述" : "商家名称"
},
{
"表名" : "merchant",
"列名" : "MERCHANTADDRESS",
"数据类型" : "varchar(200)",
"列描述" : "商家地址"
},
{
"表名" : "merchant",
"列名" : "CONTACTNAME",
"数据类型" : "varchar(20)",
"列描述" : "联系人"
},
{
"表名" : "merchant",
"列名" : "MERCHANTDESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "商家描述"
},
{
"表名" : "merchant",
"列名" : "ISCLOSED",
"数据类型" : "tinyint(1)",
"列描述" : "是否关闭"
},
{
"表名" : "merchant",
"列名" : "REFERRER",
"数据类型" : "varchar(45)",
"列描述" : "推荐人"
},
{
"表名" : "merchant",
"列名" : "REGISTER_DATE",
"数据类型" : "timestamp",
"列描述" : "入驻时间"
},
{
"表名" : "merchant",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "merchant",
"列名" : "EXCHANGE_RATE",
"数据类型" : "int",
"列描述" : "积分赠送比例(不含%)"
},
{
"表名" : "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",
"列名" : "PHOTOURL",
"数据类型" : "varchar(300)",
"列描述" : "商家头像"
},
{
"表名" : "merchant",
"列名" : "PRODUCT_CATE_STR",
"数据类型" : "varchar(450)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "MERCHANTACCOUNT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_account",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_account",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "merchant_account",
"列名" : "ACCOUNT_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "账户类型(微信,支付宝,银行)"
},
{
"表名" : "merchant_account",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "merchant_account",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "merchant_account",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "merchant_account",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "merchant_account",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "merchant_account",
"列名" : "BANKCODE",
"数据类型" : "varchar(20)",
"列描述" : "银行支行代码"
},
{
"表名" : "merchant_account",
"列名" : "ALIPAY_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "支付宝收款地址"
},
{
"表名" : "merchant_account",
"列名" : "WECHAT_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "微信收款地址"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANT_APPLICATION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_application",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_application",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "联系电话"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTNAME",
"数据类型" : "varchar(100)",
"列描述" : "商家名称"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTADDRESS",
"数据类型" : "varchar(200)",
"列描述" : "商家地址"
},
{
"表名" : "merchant_application",
"列名" : "CONTACTNAME",
"数据类型" : "varchar(20)",
"列描述" : "联系人"
},
{
"表名" : "merchant_application",
"列名" : "MERCHANTDESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "商家描述"
},
{
"表名" : "merchant_application",
"列名" : "REFERRER",
"数据类型" : "varchar(45)",
"列描述" : "推荐人"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_TIME",
"数据类型" : "timestamp",
"列描述" : "申请入驻时间"
},
{
"表名" : "merchant_application",
"列名" : "VERIFY_TIME",
"数据类型" : "timestamp",
"列描述" : "审核时间"
},
{
"表名" : "merchant_application",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "merchant_application",
"列名" : "PROVINCE",
"数据类型" : "varchar(45)",
"列描述" : "商家地址(省)"
},
{
"表名" : "merchant_application",
"列名" : "CITY",
"数据类型" : "varchar(45)",
"列描述" : "商家地址(市)"
},
{
"表名" : "merchant_application",
"列名" : "DISTRICT",
"数据类型" : "varchar(45)",
"列描述" : "商家地址(区)"
},
{
"表名" : "merchant_application",
"列名" : "LATITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "商家地址(纬度)"
},
{
"表名" : "merchant_application",
"列名" : "LONGITUDE",
"数据类型" : "decimal(20,10)",
"列描述" : "商家地址(经度)"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_ID",
"数据类型" : "varchar(45)",
"列描述" : "申请编号"
},
{
"表名" : "merchant_application",
"列名" : "APPLICATION_STATUS",
"数据类型" : "varchar(5)",
"列描述" : "申请状态"
},
{
"表名" : "merchant_application",
"列名" : "PHOTOURL",
"数据类型" : "varchar(300)",
"列描述" : "头像地址"
},
{
"表名" : "merchant_application",
"列名" : "PRODUCT_CATE_STR",
"数据类型" : "varchar(450)",
"列描述" : "可以做哪些服务(用逗号隔开)"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANTASSIGN_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_assign",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "merchant_assign",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "用户ID"
},
{
"表名" : "merchant_assign",
"列名" : "TRAN_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "会员消费金额"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_POINT",
"数据类型" : "int",
"列描述" : "划拨积分"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_TIME",
"数据类型" : "timestamp",
"列描述" : "划拨时间"
},
{
"表名" : "merchant_assign",
"列名" : "ASSIGN_NO",
"数据类型" : "varchar(45)",
"列描述" : "划拨交易号"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_POINT_BEFORE",
"数据类型" : "int",
"列描述" : "商家划拨前积分"
},
{
"表名" : "merchant_assign",
"列名" : "MERCHANT_POINT_AFTER",
"数据类型" : "int",
"列描述" : "商家划拨后积分"
},
{
"表名" : "merchant_assign",
"列名" : "USER_POINT_BEFORE",
"数据类型" : "int",
"列描述" : "会员划拨前积分"
},
{
"表名" : "merchant_assign",
"列名" : "USER_POINT_AFTER",
"数据类型" : "int",
"列描述" : "会员划拨后积分"
},
{
"表名" : "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_charge",
"列名" : "MERCHANTCHARGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_charge",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_charge",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "充值金额"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_POINT",
"数据类型" : "int",
"列描述" : "充值获取积分"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_STATUS",
"数据类型" : "varchar(10)",
"列描述" : "充值状态"
},
{
"表名" : "merchant_charge",
"列名" : "FAIL_REASON",
"数据类型" : "varchar(100)",
"列描述" : "充值失败原因"
},
{
"表名" : "merchant_charge",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "支付方式(微信,支付宝)"
},
{
"表名" : "merchant_charge",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "merchant_charge",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "merchant_charge",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名"
},
{
"表名" : "merchant_charge",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "merchant_charge",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_TIME",
"数据类型" : "timestamp",
"列描述" : "充值时间"
},
{
"表名" : "merchant_charge",
"列名" : "CHARGE_NO",
"数据类型" : "varchar(16)",
"列描述" : "充值交易编号"
},
{
"表名" : "merchant_charge",
"列名" : "OUT_TRADE_NO",
"数据类型" : "varchar(45)",
"列描述" : "微信或支付宝交易号"
},
{
"表名" : "merchant_charge",
"列名" : "POINT_BEFORE",
"数据类型" : "int",
"列描述" : "充值前积分"
},
{
"表名" : "merchant_charge",
"列名" : "POINT_AFTER",
"数据类型" : "int",
"列描述" : "充值后积分"
},
{
"表名" : "merchant_coupon",
"列名" : "MERCHANTCOUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_coupon",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_coupon",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "merchant_coupon",
"列名" : "COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "优惠券ID"
},
{
"表名" : "merchant_statement",
"列名" : "MERCHANTSTATEMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "merchant_statement",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_statement",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "交易类型"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_TIME",
"数据类型" : "timestamp",
"列描述" : "交易时间"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "交易金额"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_CODE",
"数据类型" : "varchar(20)",
"列描述" : "交易编号"
},
{
"表名" : "merchant_statement",
"列名" : "TRANSACTION_POINT",
"数据类型" : "int",
"列描述" : "交易积分"
},
{
"表名" : "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_tag",
"列名" : "MERCHANT_TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "merchant_tag",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务人员ID"
},
{
"表名" : "merchant_tag",
"列名" : "TAG_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "预留字段用于给标签分类, 暂不使用"
},
{
"表名" : "merchant_tag",
"列名" : "TAG_NAME",
"数据类型" : "varchar(45)",
"列描述" : "标签名称"
},
{
"表名" : "merchant_tag",
"列名" : "TAG_VALUE",
"数据类型" : "varchar(200)",
"列描述" : "预留字段, 暂不使用"
},
{
"表名" : "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(45)",
"列描述" : "提现交易编号"
},
{
"表名" : "merchant_withdraw",
"列名" : "REJECT_REASON",
"数据类型" : "varchar(100)",
"列描述" : "审核拒绝理由"
},
{
"表名" : "merchant_withdraw",
"列名" : "COMPLETE_TIME",
"数据类型" : "timestamp",
"列描述" : "提现成功时间"
},
{
"表名" : "merchant_withdraw",
"列名" : "PAYMENT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "提现金额"
},
{
"表名" : "merchant_withdraw",
"列名" : "TAX_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "手续费"
},
{
"表名" : "merchant_withdraw",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "message",
"列名" : "MESSAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "message",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "message",
"列名" : "FROM_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发送会员ID"
},
{
"表名" : "message",
"列名" : "TO_USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "接收会员ID"
},
{
"表名" : "message",
"列名" : "CONTENT",
"数据类型" : "varchar(500)",
"列描述" : "内容"
},
{
"表名" : "message",
"列名" : "SEND_TIME",
"数据类型" : "timestamp",
"列描述" : "发送时间"
},
{
"表名" : "note",
"列名" : "NOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "note",
"列名" : "CONTENT",
"数据类型" : "varchar(1000)",
"列描述" : "消息内容"
},
{
"表名" : "note",
"列名" : "STATUS",
"数据类型" : "varchar(15)",
"列描述" : "消息状态(已读,未读)"
},
{
"表名" : "note",
"列名" : "SEND_TIME",
"数据类型" : "timestamp",
"列描述" : "消息发送时间"
},
{
"表名" : "note",
"列名" : "ACTION",
"数据类型" : "varchar(45)",
"列描述" : "点击消息触发事件"
},
{
"表名" : "note",
"列名" : "APPLICATION",
"数据类型" : "varchar(60)",
"列描述" : "消息类型"
},
{
"表名" : "note_channel",
"列名" : "NOTECHANNEL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note_channel",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_channel",
"列名" : "ISSMSENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送短信消息"
},
{
"表名" : "note_channel",
"列名" : "NOTETYPE",
"数据类型" : "varchar(45)",
"列描述" : "消息类型"
},
{
"表名" : "note_channel",
"列名" : "ISEMAILENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送邮件消息"
},
{
"表名" : "note_channel",
"列名" : "ISWECHATENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发送微信消息"
},
{
"表名" : "note_def",
"列名" : "NOTEDEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "note_def",
"列名" : "NOTE_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "消息类型"
},
{
"表名" : "note_def",
"列名" : "NOTE_VALUE",
"数据类型" : "varchar(300)",
"列描述" : "消息内容"
},
{
"表名" : "note_def",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "note_def",
"列名" : "NOTE_ACTION",
"数据类型" : "varchar(45)",
"列描述" : "消息点击触发事件"
},
{
"表名" : "note_def",
"列名" : "NOTE_APPLICATION",
"数据类型" : "varchar(60)",
"列描述" : "消息类型"
},
{
"表名" : "num",
"列名" : "i",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "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_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_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "订单实际金额(服务项目+其他附加项)"
},
{
"表名" : "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",
"列名" : "ORDER_COMMENT",
"数据类型" : "varchar(500)",
"列描述" : "订单备注(卖家)"
},
{
"表名" : "order",
"列名" : "ORDER_CHANNEL",
"数据类型" : "varchar(45)",
"列描述" : "下单渠道(1-微信小程序,2-H5,3-APP)"
},
{
"表名" : "order",
"列名" : "CANCEL_TIME",
"数据类型" : "timestamp",
"列描述" : "订单取消时间"
},
{
"表名" : "order",
"列名" : "CANCEL_REASON",
"数据类型" : "varchar(500)",
"列描述" : "订单取消原因"
},
{
"表名" : "order",
"列名" : "IS_AFTER_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "是否申请售后"
},
{
"表名" : "order",
"列名" : "AFTER_SALE_NO",
"数据类型" : "varchar(45)",
"列描述" : "售后单号"
},
{
"表名" : "order",
"列名" : "USER_COUPON_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单使用的优惠券"
},
{
"表名" : "order",
"列名" : "CONFIRM_TIME",
"数据类型" : "timestamp",
"列描述" : "确认收货时间"
},
{
"表名" : "order",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务人员ID"
},
{
"表名" : "order",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信支付后生成的交易编号"
},
{
"表名" : "order",
"列名" : "IS_ACCOUNTED",
"数据类型" : "tinyint(1)",
"列描述" : "订单是否入账到商家"
},
{
"表名" : "order",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信退款后生成的交易编号"
},
{
"表名" : "order",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : "微信退款返回的消息"
},
{
"表名" : "order",
"列名" : "DISTRIBUTION_PACKING_NO",
"数据类型" : "varchar(45)",
"列描述" : "配货单号"
},
{
"表名" : "order",
"列名" : "DISTRIBUTION_PACKING_TIME",
"数据类型" : "timestamp",
"列描述" : "配货单生成时间"
},
{
"表名" : "order",
"列名" : "APPOINTMENT_START_TIME",
"数据类型" : "timestamp",
"列描述" : "预约上门开始时间"
},
{
"表名" : "order",
"列名" : "APPOINTMENT_END_TIME",
"数据类型" : "timestamp",
"列描述" : "预约上门结束时间"
},
{
"表名" : "order",
"列名" : "IS_PAID",
"数据类型" : "tinyint(1)",
"列描述" : "订单是否全部支付"
},
{
"表名" : "order",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "订单支付方式(1-微信,2-支付宝,3-银行卡,4-余额)"
},
{
"表名" : "order",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "支付时间"
},
{
"表名" : "order",
"列名" : "IS_PREPAID_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "订单是否使用了定金+尾款模式"
},
{
"表名" : "order",
"列名" : "IS_PREPAID",
"数据类型" : "tinyint(1)",
"列描述" : "定金是否已支付"
},
{
"表名" : "order",
"列名" : "PREPAID_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "预付金额"
},
{
"表名" : "order",
"列名" : "PREPAID_TIME",
"数据类型" : "timestamp",
"列描述" : "预付时间"
},
{
"表名" : "order",
"列名" : "SERVICE_START_TIME",
"数据类型" : "timestamp",
"列描述" : "服务开始时间"
},
{
"表名" : "order",
"列名" : "SERVICE_END_TIME",
"数据类型" : "timestamp",
"列描述" : "服务结束时间"
},
{
"表名" : "order",
"列名" : "USER_VOUCHER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单使用了次卡支付"
},
{
"表名" : "order",
"列名" : "IS_VOUCHER_ORDER",
"数据类型" : "tinyint(1)",
"列描述" : "通过购买的次卡预约下单"
},
{
"表名" : "order_after_sale",
"列名" : "ORDER_AFTER_SALE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "SALE_NO",
"数据类型" : "varchar(45)",
"列描述" : "售后单号"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_TYPE",
"数据类型" : "varchar(5)",
"列描述" : "售后类型(1-仅退款, 2-退款退货)"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "申请退款金额"
},
{
"表名" : "order_after_sale",
"列名" : "AFTER_SALE_DESCRIPTION",
"数据类型" : "varchar(500)",
"列描述" : "售后描述"
},
{
"表名" : "order_after_sale",
"列名" : "TIME_APPLICATION",
"数据类型" : "timestamp",
"列描述" : "申请售后时间"
},
{
"表名" : "order_after_sale",
"列名" : "TIME_OPERATION",
"数据类型" : "timestamp",
"列描述" : "处理售后时间"
},
{
"表名" : "order_after_sale",
"列名" : "STATUS",
"数据类型" : "varchar(5)",
"列描述" : "售后单状态(0-处理中,1-审核通过,2-审核拒绝)"
},
{
"表名" : "order_after_sale",
"列名" : "REJECT_REASON",
"数据类型" : "varchar(500)",
"列描述" : "拒绝退款申请原因"
},
{
"表名" : "order_after_sale",
"列名" : "COURIER_NO",
"数据类型" : "varchar(45)",
"列描述" : "退货物流单号"
},
{
"表名" : "order_after_sale",
"列名" : "COURIER_NAME",
"数据类型" : "varchar(45)",
"列描述" : "退货物流公司"
},
{
"表名" : "order_after_sale",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信退款后生成的交易编号"
},
{
"表名" : "order_after_sale",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : "微信退款返回的消息"
},
{
"表名" : "order_after_sale_image",
"列名" : "ORDER_AFTER_SALE_IMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "ORDER_AFTER_SALE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_after_sale_image",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : "图片地址"
},
{
"表名" : "order_fee_item",
"列名" : "ORDER_FEE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "order_fee_item",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_fee_item",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_fee_item",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_fee_item",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_fee_item",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_fee_item",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "订单ID"
},
{
"表名" : "order_fee_item",
"列名" : "ITEM_NAME",
"数据类型" : "varchar(200)",
"列描述" : "费用名称"
},
{
"表名" : "order_fee_item",
"列名" : "ITEM_UNIT",
"数据类型" : "int",
"列描述" : "数量"
},
{
"表名" : "order_fee_item",
"列名" : "ITEM_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "费用价格"
},
{
"表名" : "order_fee_item",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "单价"
},
{
"表名" : "order_fee_item",
"列名" : "UNIT_NAME",
"数据类型" : "varchar(5)",
"列描述" : "单位名称(如个，套等)"
},
{
"表名" : "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_payment",
"列名" : "ORDER_PAYMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "ORDER_NO",
"数据类型" : "varchar(36)",
"列描述" : "订单号码"
},
{
"表名" : "order_payment",
"列名" : "PAYMENT_NO",
"数据类型" : "varchar(45)",
"列描述" : "支付编号(该号码传给微信作为out_trade_no)"
},
{
"表名" : "order_payment",
"列名" : "PAYMENT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "支付金额"
},
{
"表名" : "order_payment",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(45)",
"列描述" : "支付方式"
},
{
"表名" : "order_payment",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "PAYMENT_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "定金, 尾款等"
},
{
"表名" : "order_payment",
"列名" : "IS_PAYED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已经支付"
},
{
"表名" : "order_payment",
"列名" : "TRANSACTION_ID",
"数据类型" : "varchar(45)",
"列描述" : "微信支付回调返回的编码"
},
{
"表名" : "order_payment",
"列名" : "REFUND_ID",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "REFUND_MSG",
"数据类型" : "varchar(450)",
"列描述" : ""
},
{
"表名" : "order_payment",
"列名" : "REFUND_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : ""
},
{
"表名" : "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",
"列名" : "GROUP_BUY_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "ORG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "org",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org",
"列名" : "NAME",
"数据类型" : "varchar(60)",
"列描述" : "部门名称"
},
{
"表名" : "org",
"列名" : "MANAGER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "经理ID"
},
{
"表名" : "org",
"列名" : "DESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "描述"
},
{
"表名" : "org_rel",
"列名" : "ORGREL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "org_rel",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "org_rel",
"列名" : "ORG_PARENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "上级部门ID"
},
{
"表名" : "org_rel",
"列名" : "ORG_CHILD_UUID",
"数据类型" : "varchar(36)",
"列描述" : "下级部门ID"
},
{
"表名" : "pay_order",
"列名" : "PAYORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "pay_order",
"列名" : "ORDER_NO",
"数据类型" : "varchar(20)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "pay_order",
"列名" : "ORDER_STATUS",
"数据类型" : "varchar(1)",
"列描述" : "订单状态"
},
{
"表名" : "pay_order",
"列名" : "PRODUCT_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "消费金额"
},
{
"表名" : "pay_order",
"列名" : "ACTUAL_AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "实际支付金额"
},
{
"表名" : "pay_order",
"列名" : "OUT_TRADE_NO",
"数据类型" : "varchar(45)",
"列描述" : "微信或支付宝交易编号"
},
{
"表名" : "pay_order",
"列名" : "PAYMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "支付时间"
},
{
"表名" : "pay_order",
"列名" : "ORDER_TIME",
"数据类型" : "timestamp",
"列描述" : "下单时间"
},
{
"表名" : "pay_order",
"列名" : "DELIVERY_TIME",
"数据类型" : "timestamp",
"列描述" : "发货时间"
},
{
"表名" : "pay_order",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "会员ID"
},
{
"表名" : "pay_order",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "商家ID"
},
{
"表名" : "pay_order",
"列名" : "REWARD_POINT",
"数据类型" : "int",
"列描述" : "奖励积分"
},
{
"表名" : "pay_order",
"列名" : "IS_REWARD_POINT_RECEIVED",
"数据类型" : "tinyint(1)",
"列描述" : "积分是否领取"
},
{
"表名" : "pay_order",
"列名" : "WECHATPAY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "微信交易编号"
},
{
"表名" : "pay_order",
"列名" : "ALIPAY_UUID",
"数据类型" : "varchar(36)",
"列描述" : "支付宝交易编号"
},
{
"表名" : "pay_order",
"列名" : "PAYMENT_METHOD",
"数据类型" : "varchar(10)",
"列描述" : "消费金额"
},
{
"表名" : "pay_order",
"列名" : "ASINFO_PLATFORM",
"数据类型" : "decimal(12,2)",
"列描述" : "该笔订单平台分账金额"
},
{
"表名" : "pay_order",
"列名" : "ASINFO_MERCHANT",
"数据类型" : "decimal(12,2)",
"列描述" : "该笔订单商家分账金额"
},
{
"表名" : "permission",
"列名" : "PERMISSION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "permission",
"列名" : "ROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "角色ID"
},
{
"表名" : "permission",
"列名" : "FUNCTION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "功能ID"
},
{
"表名" : "permission",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "permission",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "PLATFORMACCOUNT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "platform_account",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_account",
"列名" : "ACCOUNT_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "账户类型(微信,支付宝,银行卡)"
},
{
"表名" : "platform_account",
"列名" : "BANKNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行名称"
},
{
"表名" : "platform_account",
"列名" : "BRANCHNAME",
"数据类型" : "varchar(45)",
"列描述" : "支行名称"
},
{
"表名" : "platform_account",
"列名" : "BANKACCOUNTNO",
"数据类型" : "varchar(20)",
"列描述" : "银行账号"
},
{
"表名" : "platform_account",
"列名" : "BANKACCOUNTNAME",
"数据类型" : "varchar(45)",
"列描述" : "银行账户名称"
},
{
"表名" : "platform_account",
"列名" : "ALIPAY_ID",
"数据类型" : "varchar(80)",
"列描述" : "支付宝ID"
},
{
"表名" : "platform_account",
"列名" : "WECHAT_ID",
"数据类型" : "varchar(80)",
"列描述" : "微信ID"
},
{
"表名" : "platform_account",
"列名" : "BANKCODE",
"数据类型" : "varchar(20)",
"列描述" : "支行编号"
},
{
"表名" : "platform_account",
"列名" : "ALIPAY_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "支付宝收款码地址"
},
{
"表名" : "platform_account",
"列名" : "WECHAT_QRCODE",
"数据类型" : "varchar(500)",
"列描述" : "微信收款码地址"
},
{
"表名" : "platform_balance",
"列名" : "PLATFORMBALANCE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "platform_balance",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "platform_balance",
"列名" : "AVAILABLE_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "可提现余额"
},
{
"表名" : "platform_balance",
"列名" : "TOTAL_BALANCE",
"数据类型" : "decimal(12,2)",
"列描述" : "总余额, 可能有部分余额因为订单未结束而不能提现"
},
{
"表名" : "platform_balance",
"列名" : "AVAILABLE_INTEGRAL",
"数据类型" : "int",
"列描述" : "可用积分"
},
{
"表名" : "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)",
"列描述" : "该笔交易发生后余额"
},
{
"表名" : "poster",
"列名" : "POSTER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "poster",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "poster",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "poster",
"列名" : "URL",
"数据类型" : "varchar(500)",
"列描述" : "海报地址"
},
{
"表名" : "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",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "服务项目单价"
},
{
"表名" : "product",
"列名" : "UNIT_PRICE_STANDARD",
"数据类型" : "decimal(12,2)",
"列描述" : "标准价格"
},
{
"表名" : "product",
"列名" : "SOLDUNIT",
"数据类型" : "int",
"列描述" : "服务项目已售数量"
},
{
"表名" : "product",
"列名" : "IS_SKU_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否多规格服务项目"
},
{
"表名" : "product",
"列名" : "PRODUCTCATE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务类目"
},
{
"表名" : "product",
"列名" : "PRODUCT_MAIN_IMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目主图"
},
{
"表名" : "product",
"列名" : "PRODUCT_FEE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "收费标准"
},
{
"表名" : "product",
"列名" : "MEMBERSHIP_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "会员单价"
},
{
"表名" : "product",
"列名" : "MARKET_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "市场价"
},
{
"表名" : "product",
"列名" : "IS_NEW",
"数据类型" : "tinyint(1)",
"列描述" : "是否新品"
},
{
"表名" : "product",
"列名" : "IS_HOT",
"数据类型" : "tinyint(1)",
"列描述" : "是否热销"
},
{
"表名" : "product",
"列名" : "IS_RECOMMEND",
"数据类型" : "tinyint(1)",
"列描述" : "是否推荐服务项目"
},
{
"表名" : "product",
"列名" : "PRODUCT_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "服务项目类型"
},
{
"表名" : "product",
"列名" : "IS_ON_SALE",
"数据类型" : "tinyint(1)",
"列描述" : "上架,下架"
},
{
"表名" : "product",
"列名" : "MEMO",
"数据类型" : "varchar(500)",
"列描述" : "备注"
},
{
"表名" : "product",
"列名" : "PREPAID_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "预付金额"
},
{
"表名" : "product",
"列名" : "IS_PREPAID_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : ""
},
{
"表名" : "product",
"列名" : "VALID_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "有效期类型(仅用于电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_DAYS",
"数据类型" : "int",
"列描述" : "几天内有效(仅用于电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_START_DATE",
"数据类型" : "date",
"列描述" : "有效开始时间(仅用于电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_END_DATE",
"数据类型" : "date",
"列描述" : "有效结束时间(仅用于电子卡券商品)"
},
{
"表名" : "product",
"列名" : "VALID_TIMES",
"数据类型" : "int",
"列描述" : "可核销次数"
},
{
"表名" : "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_fee",
"列名" : "PRODUCT_FEE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_fee",
"列名" : "TYPE",
"数据类型" : "varchar(45)",
"列描述" : "收费标准类型(预留字段，暂不使用)"
},
{
"表名" : "product_fee",
"列名" : "NAME",
"数据类型" : "varchar(100)",
"列描述" : "收费标准名称"
},
{
"表名" : "product_fee",
"列名" : "IS_ACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "product_fee_item",
"列名" : "PRODUCT_FEE_ITEM_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_fee_item",
"列名" : "PRODUCT_FEE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "收费标准ID"
},
{
"表名" : "product_fee_item",
"列名" : "ITEM_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "费用类型(服务或者材料)"
},
{
"表名" : "product_fee_item",
"列名" : "ITEM_NAME",
"数据类型" : "varchar(45)",
"列描述" : "收费项名称"
},
{
"表名" : "product_fee_item",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "单价"
},
{
"表名" : "product_fee_item",
"列名" : "UNIT_NAME",
"数据类型" : "varchar(10)",
"列描述" : "收费项单位名称(如个，套，次，小时等)"
},
{
"表名" : "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",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "PRODUCTFREIGHTREGION_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_freight_region",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_freight_region",
"列名" : "PRODUCTGREIGHT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "运费模板ID"
},
{
"表名" : "product_freight_region",
"列名" : "FIRST_UNIT",
"数据类型" : "int",
"列描述" : "首件"
},
{
"表名" : "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)",
"列描述" : "服务项目ID"
},
{
"表名" : "product_image",
"列名" : "FILE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PRODUCTPROMOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PROMOTE_TYPE",
"数据类型" : "varchar(10)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PROMOTE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_promote",
"列名" : "SUPPLIER_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "product_sku",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_sku",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目ID"
},
{
"表名" : "product_sku",
"列名" : "SKU_CODE",
"数据类型" : "varchar(45)",
"列描述" : "规格货号"
},
{
"表名" : "product_sku",
"列名" : "SKU_SOLD_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_tag",
"列名" : "PRODUCT_TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "product_tag",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目ID"
},
{
"表名" : "product_tag",
"列名" : "TAG_TYPE",
"数据类型" : "varchar(45)",
"列描述" : "预留字段用于给标签分类, 暂不使用"
},
{
"表名" : "product_tag",
"列名" : "TAG_NAME",
"数据类型" : "varchar(45)",
"列描述" : "标签名称"
},
{
"表名" : "product_tag",
"列名" : "TAG_VALUE",
"数据类型" : "varchar(200)",
"列描述" : "预留字段, 暂不使用"
},
{
"表名" : "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_merchant",
"列名" : "PROFIT_MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "profit_merchant",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "profit_merchant",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_merchant",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_merchant",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "profit_merchant",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "profit_merchant",
"列名" : "PROFIT_TYPE",
"数据类型" : "varchar(5)",
"列描述" : "1-按实际支付比例, 2-按每件固定金额"
},
{
"表名" : "profit_merchant",
"列名" : "AMOUNT",
"数据类型" : "decimal(12,2)",
"列描述" : "固定金额"
},
{
"表名" : "profit_merchant",
"列名" : "RATING",
"数据类型" : "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(45)",
"列描述" : "新用户赠送的优惠券"
},
{
"表名" : "profit_welfare",
"列名" : "PRODUCT_ENABLED",
"数据类型" : "tinyint(1)",
"列描述" : "是否开启新人专享服务项目"
},
{
"表名" : "profit_welfare",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(45)",
"列描述" : "新用户可低价购买的服务项目"
},
{
"表名" : "profit_welfare",
"列名" : "PRODUCT_UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "新用户低价购买服务项目的单价"
},
{
"表名" : "profit_welfare",
"列名" : "PRODUCT_LIMITED_UNIT",
"数据类型" : "int",
"列描述" : ""
},
{
"表名" : "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)",
"列描述" : "是否热门"
},
{
"表名" : "role",
"列名" : "ROLE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "role",
"列名" : "ROLE_NAME",
"数据类型" : "varchar(20)",
"列描述" : "角色名称"
},
{
"表名" : "role",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "role",
"列名" : "ISACTIVE",
"数据类型" : "tinyint(1)",
"列描述" : "是否启用"
},
{
"表名" : "role",
"列名" : "ROLE_DESC",
"数据类型" : "varchar(200)",
"列描述" : "角色描述"
},
{
"表名" : "scene",
"列名" : "SCENE_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : ""
},
{
"表名" : "scene",
"列名" : "TITLE",
"数据类型" : "varchar(45)",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "SEC_KILL_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sec_kill",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill",
"列名" : "NAME",
"数据类型" : "varchar(100)",
"列描述" : "秒杀活动名称"
},
{
"表名" : "sec_kill",
"列名" : "START_TIME",
"数据类型" : "timestamp",
"列描述" : "秒杀发起时间"
},
{
"表名" : "sec_kill",
"列名" : "END_TIME",
"数据类型" : "timestamp",
"列描述" : "秒杀结束时间"
},
{
"表名" : "sec_kill",
"列名" : "IS_ENABLED",
"数据类型" : "varchar(10)",
"列描述" : "是否启用"
},
{
"表名" : "sec_kill_def",
"列名" : "SEC_KILL_DEF_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sec_kill_def",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sec_kill_def",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_def",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_def",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_def",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_def",
"列名" : "NAME",
"数据类型" : "varchar(100)",
"列描述" : "秒杀活动名称"
},
{
"表名" : "sec_kill_def",
"列名" : "START_TIME",
"数据类型" : "time",
"列描述" : "秒杀发起时间"
},
{
"表名" : "sec_kill_def",
"列名" : "END_TIME",
"数据类型" : "time",
"列描述" : "秒杀结束时间"
},
{
"表名" : "sec_kill_def",
"列名" : "IS_ENABLED",
"数据类型" : "varchar(10)",
"列描述" : "是否启用"
},
{
"表名" : "sec_kill_def",
"列名" : "FREQUENCY_TYPE",
"数据类型" : "varchar(10)",
"列描述" : "频率类型(DAYLY-每天,WEEKLY-每周,MONTHLY-每月)"
},
{
"表名" : "sec_kill_def",
"列名" : "FREQUENCY_VALUE",
"数据类型" : "varchar(150)",
"列描述" : "当FREQUENCY_TYPE是WEEKLY时周1-7的组合,如1,2,3表示周日,周一和周三\n当FREQUENCY_TYPE是MONTHLY时, 1-31的组合,如1,2,3表示每月1号，2号和3号\n"
},
{
"表名" : "sec_kill_def_product",
"列名" : "SEC_KILL_DEF_PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "sec_kill_def_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "sec_kill_def_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_def_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_def_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "sec_kill_def_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "sec_kill_def_product",
"列名" : "SEC_KILL_DEF_UUID",
"数据类型" : "varchar(45)",
"列描述" : "关联的秒杀模板"
},
{
"表名" : "sec_kill_def_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "服务项目ID"
},
{
"表名" : "sec_kill_def_product",
"列名" : "STOCK",
"数据类型" : "int",
"列描述" : "暂不使用-预留存储秒杀服务项目专用库存"
},
{
"表名" : "sec_kill_def_product",
"列名" : "UNIT_PRICE",
"数据类型" : "varchar(45)",
"列描述" : "秒杀价格"
},
{
"表名" : "sec_kill_def_product",
"列名" : "LIMITED_UNIT",
"数据类型" : "int",
"列描述" : "限购数量"
},
{
"表名" : "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",
"列名" : "SEC_KILL_UUID",
"数据类型" : "varchar(45)",
"列描述" : "关联的秒杀活动"
},
{
"表名" : "sec_kill_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(46)",
"列描述" : "服务项目ID"
},
{
"表名" : "sec_kill_product",
"列名" : "STOCK",
"数据类型" : "int",
"列描述" : "暂不使用-预留存储秒杀服务项目专用库存"
},
{
"表名" : "sec_kill_product",
"列名" : "UNIT_PRICE",
"数据类型" : "varchar(45)",
"列描述" : "秒杀价格"
},
{
"表名" : "sec_kill_product",
"列名" : "LIMITED_UNIT",
"数据类型" : "int",
"列描述" : "限购数量"
},
{
"表名" : "sec_kill_product",
"列名" : "SOLD_UNIT",
"数据类型" : "int",
"列描述" : "暂不使用-预留存储秒杀服务项目已售数量"
},
{
"表名" : "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",
"列描述" : "交易编号时间"
},
{
"表名" : "service_time_slot",
"列名" : "SERVICE_TIME_SLOT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "service_time_slot",
"列名" : "START_TIME",
"数据类型" : "varchar(5)",
"列描述" : "时间段的开始时间(09:00)"
},
{
"表名" : "service_time_slot",
"列名" : "END_TIME",
"数据类型" : "varchar(5)",
"列描述" : "时间段的结束时间(09:30)"
},
{
"表名" : "service_time_slot",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "service_time_slot",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "service_time_slot",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "service_time_slot",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "service_time_slot",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "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)",
"列描述" : "配置项描述"
},
{
"表名" : "share",
"列名" : "SHARE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "share",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "share",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share",
"列名" : "TAG_UUID",
"数据类型" : "varchar(36)",
"列描述" : "标签ID"
},
{
"表名" : "share",
"列名" : "CONTENT",
"数据类型" : "longtext",
"列描述" : "内容"
},
{
"表名" : "share",
"列名" : "PUBLISH_TIME",
"数据类型" : "timestamp",
"列描述" : "发布时间"
},
{
"表名" : "share",
"列名" : "ISPUBLISHED",
"数据类型" : "tinyint(1)",
"列描述" : "是否发布"
},
{
"表名" : "share",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "发布会员ID"
},
{
"表名" : "share",
"列名" : "LIKES",
"数据类型" : "int",
"列描述" : "集赞数量"
},
{
"表名" : "share_comment",
"列名" : "SHARECOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "share_comment",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "share_comment",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_comment",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_comment",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_comment",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_comment",
"列名" : "SHARE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "朋友圈ID"
},
{
"表名" : "share_comment",
"列名" : "COMMENT",
"数据类型" : "varchar(300)",
"列描述" : "评论内容"
},
{
"表名" : "share_comment",
"列名" : "COMMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "评论时间"
},
{
"表名" : "share_comment",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "评论会员"
},
{
"表名" : "share_comment_at",
"列名" : "SHARECOMMENTAT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "share_comment_at",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "share_comment_at",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_comment_at",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_comment_at",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_comment_at",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_comment_at",
"列名" : "SHARECOMMENT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "评论ID"
},
{
"表名" : "share_comment_at",
"列名" : "COMMENT",
"数据类型" : "varchar(300)",
"列描述" : "回复内容"
},
{
"表名" : "share_comment_at",
"列名" : "COMMENT_TIME",
"数据类型" : "timestamp",
"列描述" : "回复时间"
},
{
"表名" : "share_comment_at",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "回复会员ID"
},
{
"表名" : "share_image",
"列名" : "SHAREIMAGE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "share_image",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "share_image",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_image",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_image",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_image",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_image",
"列名" : "SHARE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "朋友圈ID"
},
{
"表名" : "share_image",
"列名" : "URL",
"数据类型" : "varchar(300)",
"列描述" : "图片地址"
},
{
"表名" : "share_like",
"列名" : "SHARELIKE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "share_like",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "share_like",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_like",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_like",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "share_like",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "share_like",
"列名" : "SHARE_UUID",
"数据类型" : "varchar(36)",
"列描述" : "朋友圈ID"
},
{
"表名" : "share_like",
"列名" : "LIKE_TIME",
"数据类型" : "timestamp",
"列描述" : "点赞时间"
},
{
"表名" : "share_like",
"列名" : "USER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "点赞会员"
},
{
"表名" : "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",
"列名" : "UNIT",
"数据类型" : "int",
"列描述" : "服务项目数量"
},
{
"表名" : "shopping_cart",
"列名" : "PRODUCTSKU_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目规格ID"
},
{
"表名" : "shopping_cart",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目ID"
},
{
"表名" : "shopping_cart",
"列名" : "UNIT_PRICE",
"数据类型" : "decimal(12,2)",
"列描述" : "用户最终购买价格"
},
{
"表名" : "shopping_cart",
"列名" : "PRICE_TAG",
"数据类型" : "varchar(45)",
"列描述" : "价格标签(最终的价格种类, 比如秒杀价, 新人专享价)"
},
{
"表名" : "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",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "SUPPLIER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "supplier",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "supplier",
"列名" : "MOBILENO",
"数据类型" : "varchar(20)",
"列描述" : "联系电话"
},
{
"表名" : "supplier",
"列名" : "SUPPLIERNAME",
"数据类型" : "varchar(100)",
"列描述" : "供应商名称"
},
{
"表名" : "supplier",
"列名" : "SUPPLIERADDRESS",
"数据类型" : "varchar(200)",
"列描述" : "供应商地址"
},
{
"表名" : "supplier",
"列名" : "CONTACTNAME",
"数据类型" : "varchar(20)",
"列描述" : "联系人"
},
{
"表名" : "supplier",
"列名" : "SUPPLIERDESCRIPTION",
"数据类型" : "varchar(200)",
"列描述" : "供应商描述"
},
{
"表名" : "supplier",
"列名" : "ISCLOSED",
"数据类型" : "tinyint(1)",
"列描述" : "是否关闭"
},
{
"表名" : "supplier",
"列名" : "REGISTER_DATE",
"数据类型" : "timestamp",
"列描述" : "入驻时间"
},
{
"表名" : "supplier",
"列名" : "MEMO",
"数据类型" : "varchar(100)",
"列描述" : "备注"
},
{
"表名" : "supplier_product",
"列名" : "SUPPLIERPRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "主键ID"
},
{
"表名" : "supplier_product",
"列名" : "IS_DELETED",
"数据类型" : "varchar(1)",
"列描述" : ""
},
{
"表名" : "supplier_product",
"列名" : "DATE_CREATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "supplier_product",
"列名" : "CREATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "supplier_product",
"列名" : "DATE_UPDATE",
"数据类型" : "timestamp",
"列描述" : ""
},
{
"表名" : "supplier_product",
"列名" : "UPDATE_BY",
"数据类型" : "varchar(50)",
"列描述" : ""
},
{
"表名" : "supplier_product",
"列名" : "SUPPLIER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "供应商ID"
},
{
"表名" : "supplier_product",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务项目ID"
},
{
"表名" : "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",
"列名" : "PRODUCTCATE_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(10)",
"列描述" : "性别"
},
{
"表名" : "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",
"列名" : "IS_PROFIT_WELFARE_RECEIVED",
"数据类型" : "tinyint(1)",
"列描述" : "是否已领取新人福利"
},
{
"表名" : "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_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_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_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",
"列名" : "MERCHANT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "服务人员ID"
},
{
"表名" : "user_voucher",
"列名" : "ORDER_UUID",
"数据类型" : "varchar(36)",
"列描述" : "购买电子卡券的订单"
},
{
"表名" : "user_voucher",
"列名" : "PRODUCT_UUID",
"数据类型" : "varchar(36)",
"列描述" : "电子卡券对应的服务"
},
{
"表名" : "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)",
"列描述" : ""
}
]