| Thực thể | Trường | Ghi chú |
|---|
| message_template | id; tenant_id; type enum(attendance_absent, attendance_late, attendance_present, invoice_created, receipt, fee_reminder, low_balance, schedule_change, session_cancelled, trial_confirm, welcome, credentials, report_published, announcement, custom); channel enum(zns, oa, push, email); zalo_template_id; body; subject; params jsonb; status enum(draft, pending, approved, rejected); updated_at | mới |
| message | id uuid; tenant_id; school_id; type; guardian_id; student_id null; source_type, source_id (attendance_record, tuition, payment, session, announcement, report); channel; rendered_body; status enum(queued, sent, delivered, read, failed, skipped); skip_reason; provider_msg_id; cost_vnd; attempts; created_at; sent_at; delivered_at; read_at | mới; index (guardian_id, created_at), (source_type, source_id) |
| announcement | id; tenant_id; school_id null; title; body; attachments file_id[]; audience jsonb {school_ids, class_ids, student_ids, guardian_flag}; channels[]; allow_reply; scheduled_at; sent_at; created_by; stats jsonb {recipients, sent, delivered, read, failed} | mới |
| progress_report_batch, progress_report | batch: class_id, period_start, period_end, status, created_by; report: batch_id, student_id, data jsonb (attendance, flyer, balance), teacher_comment, status enum(draft, commented, published), version, pdf_file_id, published_at | mới |
| parent_request | id; guardian_id; student_id; type enum(excuse, makeup, correction, other); payload jsonb; status enum(open, accepted, rejected); handled_by; note; created_at | mới |
| zalo_oa_connection | tenant_id; oa_id; oa_name; app_id; tokens (encrypted); connected_at; status; last_error | mới |
| portal_session | id; guardian_id; device; created_at; expires_at; revoked_at | mới |
| notification_policy (cấu hình trường) | theo từng loại: channels[], quiet_hours_apply bool; zns_monthly_cap | mở rộng NotificationConfig |
