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