表结构
<h1>ba_activity_visitor 访客表</h1>
<p>CREATE TABLE <code>ba_activity_visitor</code> (
<code>id</code> BIGINT(20) NOT NULL COMMENT '主键',
<code>tenant_id</code> BIGINT(20) NOT NULL COMMENT '租户ID',
<code>share_id</code> BIGINT(20) NOT NULL COMMENT '分享人id',
<code>wechat_open_id</code> VARCHAR(64) NOT NULL DEFAULT '' COMMENT '微信openId' COLLATE 'utf8_general_ci',
<code>wechat_image_url</code> VARCHAR(256) NOT NULL DEFAULT '' COMMENT '微信头像' COLLATE 'utf8_general_ci',
<code>gender</code> CHAR(1) NULL DEFAULT '' COMMENT '性别F-女,M-男,U-未知' COLLATE 'utf8_general_ci',
<code>wechat_nickname</code> VARCHAR(128) NOT NULL DEFAULT '' COMMENT '微信昵称' COLLATE 'utf8_general_ci',
<code>visit_phone</code> VARCHAR(16) NULL DEFAULT '' COMMENT '手机号码' COLLATE 'utf8_general_ci',
<code>last_visit_content_id</code> VARCHAR(30) NOT NULL DEFAULT '' COMMENT '最近查看内容id' COLLATE 'utf8_general_ci',
<code>last_visit_content_title</code> VARCHAR(128) NULL DEFAULT '' COMMENT '最近查看内容标题' COLLATE 'utf8_general_ci',
<code>last_visit_content_type</code> VARCHAR(16) NULL DEFAULT '' COMMENT '最近查看内容类型:文章:article、海报:poster、活动:activity、视频:video、电子名片:eleccard、团队名片:teamcard' COLLATE 'utf8_general_ci',
<code>last_visit_content_time</code> DATETIME NULL DEFAULT NULL COMMENT '最近访问时间',
<code>visitor_operation</code> TINYINT(4) NOT NULL COMMENT '访客操作行为,1-查看,2-转发',
<code>visit_count</code> BIGINT(8) NULL DEFAULT NULL COMMENT '互动次数',
<code>related_customer_id</code> BIGINT(20) NULL DEFAULT NULL COMMENT '关联客户id',
<code>creator</code> VARCHAR(50) NULL DEFAULT 'sys' COMMENT '创建人' COLLATE 'utf8_general_ci',
<code>gmt_created</code> DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
<code>modifier</code> VARCHAR(50) NULL DEFAULT 'sys' COMMENT '修改人' COLLATE 'utf8_general_ci',
<code>gmt_modified</code> DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上一次修改时间',
<code>is_deleted</code> CHAR(1) NOT NULL DEFAULT 'N' COMMENT '是否删除:Y=是,N=否' COLLATE 'utf8_general_ci',
<code>app_visitor_id</code> VARCHAR(100) NULL DEFAULT NULL COMMENT 'app访客id' COLLATE 'utf8_general_ci',
<code>icon</code> CHAR(1) NULL DEFAULT 'N' COMMENT '信任icon' COLLATE 'utf8_general_ci',
PRIMARY KEY (<code>id</code>) USING BTREE,
INDEX <code>Idx_tenantId_shareId</code> (<code>tenant_id</code>, <code>share_id</code>, <code>wechat_open_id</code>) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;</p>
<h1>ba_activity_visitor_detail 访问明细表</h1>
<p>CREATE TABLE <code>ba_activity_visitor_detail</code> (
<code>id</code> BIGINT(20) NOT NULL COMMENT '主键',
<code>tenant_id</code> BIGINT(20) NOT NULL COMMENT '租户ID',
<code>visitor_id</code> BIGINT(20) NOT NULL COMMENT '访客id',
<code>content_id</code> VARCHAR(30) NOT NULL DEFAULT '' COMMENT '内容id' COLLATE 'utf8_general_ci',
<code>content_title</code> VARCHAR(128) NULL DEFAULT '' COMMENT '内容标题' COLLATE 'utf8_general_ci',
<code>content_type</code> VARCHAR(16) NOT NULL DEFAULT '' COMMENT '最近查看内容类型:文章:article、海报:poster、活动:activity、视频:video' COLLATE 'utf8_general_ci',
<code>content_img</code> VARCHAR(500) NOT NULL DEFAULT '' COMMENT '内容图片' COLLATE 'utf8_general_ci',
<code>visitor_operation</code> TINYINT(4) NOT NULL COMMENT '访客操作行为,1-查看,2-转发',
<code>operation_time</code> DATETIME NULL DEFAULT NULL COMMENT '操作时间',
<code>label</code> VARCHAR(512) NOT NULL DEFAULT '' COMMENT '标签' COLLATE 'utf8_general_ci',
<code>stay_duration</code> BIGINT(20) NULL DEFAULT NULL COMMENT '停留时长(秒)',
<code>creator</code> VARCHAR(50) NULL DEFAULT 'sys' COMMENT '创建人' COLLATE 'utf8_general_ci',
<code>gmt_created</code> DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
<code>modifier</code> VARCHAR(50) NULL DEFAULT 'sys' COMMENT '修改人' COLLATE 'utf8_general_ci',
<code>gmt_modified</code> DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上一次修改时间',
<code>is_deleted</code> CHAR(1) NULL DEFAULT 'N' COMMENT '是否删除:Y=是,N=否' COLLATE 'utf8_general_ci',
<code>view_end_time</code> DATETIME NULL DEFAULT NULL COMMENT '访客浏览结束时间',
<code>view_start_time</code> DATETIME NULL DEFAULT NULL COMMENT '访客浏览开始时间',
PRIMARY KEY (<code>id</code>) USING BTREE,
INDEX <code>idx__tenantId_visitorId</code> (<code>tenant_id</code>, <code>visitor_id</code>) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;</p>