市场调研小程序 - 数据库ER图

erDiagram user ||--o{ task_assignment : "分配任务" user ||--o{ task : "创建任务" user ||--o{ review_record : "审核" user ||--o{ geofence : "创建围栏" user ||--o{ form_template : "创建模板" task ||--o{ task_assignment : "包含" task }o--|| geofence : "关联" task }o--|| form_template : "使用" task_assignment ||--o| checkin_record : "打卡" task_assignment ||--o{ photo : "拍照" task_assignment ||--o| form_submission : "提交" form_submission ||--o{ review_record : "审核" form_submission }o--|| form_template : "基于" user { varchar id PK varchar openid UK varchar phone varchar name enum role tinyint status } geofence { varchar id PK varchar name enum type decimal center_lat decimal center_lng int radius json polygon } form_template { varchar id PK varchar name json fields tinyint status varchar created_by FK } task { varchar id PK varchar title varchar geofence_id FK varchar form_template_id FK enum status datetime deadline tinyint require_photo int max_assignees } task_assignment { varchar id PK varchar task_id FK varchar user_id FK enum status enum assign_type datetime assigned_at } checkin_record { varchar id PK varchar assignment_id FK decimal latitude decimal longitude decimal accuracy tinyint is_in_geofence } photo { varchar id PK varchar assignment_id FK varchar url varchar label json ocr_result } form_submission { varchar id PK varchar assignment_id FK varchar form_template_id FK json form_data tinyint is_draft } review_record { varchar id PK varchar submission_id FK varchar reviewer_id FK enum status varchar comment }