代理人活动量管理


表结构

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 ;

页面列表

ITEM_HTML