🗄️ 数据库设计

erDiagram antifraud_user ||--o{ antifraud_user_certification : "实名认证" antifraud_user ||--o{ antifraud_report : "提交举报" antifraud_user ||--o{ antifraud_case : "发起报案" antifraud_user ||--o{ antifraud_warning : "接收预警" antifraud_user ||--o{ antifraud_notice : "接收通知" antifraud_report ||--o{ antifraud_report_evidence : "证据" antifraud_report ||--o| antifraud_report_phone : "电话" antifraud_report ||--o| antifraud_report_sms : "短信" antifraud_report ||--o| antifraud_report_social : "社交" antifraud_case ||--o{ antifraud_case_bank_stop : "银行卡止付" antifraud_case ||--o{ antifraud_case_third_stop : "第三方止付" antifraud_case ||--o{ antifraud_case_digital_rmb_stop : "数字人民币" antifraud_case ||--o| antifraud_case_device_info : "设备信息" antifraud_case ||--o| antifraud_case_ocr : "OCR记录" antifraud_case ||--o{ antifraud_guofan_info : "国反嫌疑人" antifraud_org ||--o{ antifraud_department : "部门" antifraud_department ||--o{ antifraud_user : "归属用户" antifraud_role ||--o{ antifraud_user_role : "用户角色" antifraud_user ||--o{ antifraud_user_role : "角色关联" antifraud_role ||--o{ antifraud_permission : "权限" antifraud_case }o..o{ antifraud_knowledge : "关联知识"

erDiagram antifraud_user { bigint id PK varchar(32) phone varchar(64) nickname varchar(20) status datetime create_time } antifraud_user_certification { bigint id PK bigint user_id FK varchar(20) cert_type varchar(64) real_name varchar(18) id_number varchar(256) face_result datetime create_time } antifraud_report { bigint id PK varchar(32) serial_no UK bigint user_id FK varchar(20) type text content varchar(20) status tinyint is_anonymous varchar(20) reporter_phone varchar(64) guofan_case_no tinyint has_loss datetime create_time } antifraud_report_evidence { bigint id PK; bigint report_id FK; varchar(20) evidence_type; varchar(256) file_url; datetime create_time } antifraud_report_phone { bigint id PK; bigint report_id FK; varchar(20) phone; varchar(256) screenshot_url } antifraud_report_sms { bigint id PK; bigint report_id FK; text sms_content; varchar(20) sender_phone; text image_urls } antifraud_report_social { bigint id PK; bigint report_id FK; varchar(128) social_account; varchar(32) platform; varchar(256) avatar_url; varchar(64) avatar_check_result; text screenshot_urls } antifraud_user ||--o{ antifraud_user_certification : "实名认证" antifraud_user ||--o{ antifraud_report : "提交举报" antifraud_report ||--o{ antifraud_report_evidence : "证据" antifraud_report ||--o| antifraud_report_phone : "电话举报" antifraud_report ||--o| antifraud_report_sms : "短信举报" antifraud_report ||--o| antifraud_report_social : "社交举报"

erDiagram antifraud_case { bigint id PK varchar(32) serial_no UK bigint user_id FK varchar(20) case_type tinyint has_loss varchar(20) status datetime create_time } antifraud_case_bank_stop { bigint id PK; bigint case_id FK; varchar(20) stop_account_type; varchar(32) stop_account; varchar(64) stop_account_name; varchar(64) bank_name; datetime transfer_time; varchar(10) currency; decimal(18,2) transfer_amount; tinyint is_suspect; varchar(50) fraud_type; varchar(200) stop_reason; json guofan_response; varchar(20) status; datetime create_time } antifraud_case_third_stop { bigint id PK; bigint case_id FK; varchar(20) stop_account_type; varchar(64) third_party_institution; varchar(64) stop_account; datetime transfer_time; tinyint is_suspect; varchar(50) fraud_type; varchar(200) stop_reason; varchar(20) status; datetime create_time } antifraud_case_digital_rmb_stop { bigint id PK; bigint case_id FK; varchar(64) wallet_id; varchar(20) stop_type; varchar(64) stop_account_name; varchar(10) currency_type; varchar(64) victim_name; varchar(32) victim_bank_card; datetime transfer_time; varchar(20) wallet_type; varchar(64) bank_name; varchar(200) stop_reason; varchar(20) status; datetime create_time } antifraud_case_device_info { bigint id PK; bigint case_id FK; varchar(32) device_brand; varchar(64) device_model; varchar(20) os_version; varchar(32) ip_address; varchar(20) network_type; varchar(128) location; datetime create_time } antifraud_case_ocr { bigint id PK; bigint case_id FK; varchar(20) ocr_type; varchar(256) image_url; varchar(64) recognized_name; varchar(64) recognized_number; varchar(64) recognized_bank; json raw_result; datetime create_time } antifraud_guofan_info { bigint id PK; bigint case_id FK; varchar(32) suspect_account_type; varchar(64) suspect_account_name; varchar(64) suspect_account; datetime transfer_time; decimal(18,2) transfer_amount; varchar(64) guofan_case_no; varchar(20) source; datetime create_time } antifraud_case ||--o{ antifraud_case_bank_stop : "银行卡止付" antifraud_case ||--o{ antifraud_case_third_stop : "第三方止付" antifraud_case ||--o{ antifraud_case_digital_rmb_stop : "数字人民币止付" antifraud_case ||--o| antifraud_case_device_info : "设备信息" antifraud_case ||--o| antifraud_case_ocr : "OCR记录" antifraud_case ||--o{ antifraud_guofan_info : "国反嫌疑人"

erDiagram antifraud_org { bigint id PK; varchar(64) org_name; bigint parent_id; varchar(20) org_level; datetime create_time } antifraud_department { bigint id PK; bigint org_id FK; bigint parent_id; varchar(64) dept_name; varchar(20) dept_level; datetime create_time } antifraud_role { bigint id PK; varchar(64) role_name; varchar(20) role_type; bigint org_id FK; datetime create_time } antifraud_user_role { bigint id PK; bigint user_id FK; bigint role_id FK; datetime create_time } antifraud_permission { bigint id PK; bigint role_id FK; varchar(128) permission_key; varchar(64) permission_name; varchar(64) menu_path; datetime create_time } antifraud_org ||--o{ antifraud_department : "部门" antifraud_department ||--o{ antifraud_user : "归属用户" antifraud_role ||--o{ antifraud_user_role : "用户角色" antifraud_user ||--o{ antifraud_user_role : "角色关联" antifraud_role ||--o{ antifraud_permission : "权限"