16 lines
1.1 KiB
SQL
16 lines
1.1 KiB
SQL
-- 音视频权限拒绝日志表
|
||
CREATE TABLE IF NOT EXISTS `zyt_av_permission_log` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`patient_id` varchar(64) NOT NULL DEFAULT '' COMMENT '患者ID（patient_xxx格式）',
|
||
`doctor_id` varchar(64) NOT NULL DEFAULT '' COMMENT '医生ID（doctor_xxx格式）',
|
||
`denied_scope` varchar(32) NOT NULL DEFAULT '' COMMENT '被拒绝的权限 scope（camera/record）',
|
||
`scene` varchar(32) NOT NULL DEFAULT '' COMMENT '触发场景（makeCall / incoming）',
|
||
`action` varchar(16) NOT NULL DEFAULT 'cancel' COMMENT '用户行为：cancel=取消 / open_setting=去设置',
|
||
`wx_version` varchar(32) NOT NULL DEFAULT '' COMMENT '微信基础库版本',
|
||
`create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间（Unix秒）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_patient` (`patient_id`),
|
||
KEY `idx_doctor` (`doctor_id`),
|
||
KEY `idx_create_time` (`create_time`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='音视频权限拒绝行为日志';
|