表结构

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
;