跳到主要内容

数据库架构

FeedbackPulse SaaS 所有数据库表概览。

数据表参考​

平台表（非租户范围）​

数据表说明关键字段
platform_settings全局键值配置（敏感信息已加密）key, value
plans含定价和功能开关的订阅套餐name, monthly_price, annual_price, max_*, feature_*
landing_pages落地页构建器数据（含缓存 HTML）sections（JSON）、cached_html、is_published
payment_eventsStripe/PayPal webhook 事件日志gateway, event_id, event_type, payload（JSON）
audit_logs操作审计追踪user_id, action, description, old_values, new_values
cron_logs定时任务执行日志job_name, status, output, duration_seconds

租户表​

数据表说明关键字段
tenants多租户账户name, slug, subdomain, plan_id, status, settings（JSON）
tenant_domains自定义域名映射tenant_id, domain, status, verified_at
users所有用户账户（所有角色）name, email, role, tenant_id, two_factor_secret
products反馈产品tenant_id, name, slug, type, category, is_active
feedback_campaigns反馈表单配置tenant_id, product_id, name, slug, survey_schema（JSON）、status
feedback_submissions单条反馈记录tenant_id, campaign_id, product_id, star_rating, nps_score, text_feedback, sentiment_*, status
feedback_tags标签定义tenant_id, name
feedback_submission_tag多对多中间表submission_id, tag_id
team_members租户团队记录tenant_id, user_id, role
team_invitations待处理邀请tenant_id, email, role, token, expires_at
api_keys租户 API 密钥（已哈希）tenant_id, name, key, scopes, is_active
roadmap_items公开路线图条目tenant_id, product_id, title, status, vote_count
roadmap_votes匿名投票roadmap_item_id, email
feature_requests社区功能建议tenant_id, roadmap_item_id, email, description, status
changelog_entries产品更新说明tenant_id, product_id, title, body, version, published_at
notifications应用内通知tenant_id, user_id, type, title, message, data（JSON）
webhook_logs出站 webhook 投递日志tenant_id, url, event, payload（JSON）、response_code
data_deletion_requestsGDPR 删除请求跟踪tenant_id, requester_email, status, completed_at
referral_codes推荐码tenant_id, code, reward_type, uses, max_uses
referral_conversions转化追踪referral_code_id, converted_tenant_id, reward_amount
scheduled_report_logs报告投递日志tenant_id, report_type, status, sent_at

Laravel 系统表​

数据表说明
migrations迁移追踪
password_reset_tokens密码重置 token（支持租户感知）
sessions用户会话
cache应用缓存
jobs队列任务
failed_jobs失败的队列任务

关键关系​

plans <---- tenants <---- users
                |
                |---- products <---- feedback_campaigns <---- feedback_submissions
                |                                                      |
                |                                                      +---- feedback_tags (M2M)
                |
                |---- roadmap_items <---- roadmap_votes
                |                  <---- feature_requests
                |
                |---- changelog_entries
                |---- team_members ---- users
                |---- team_invitations
                |---- api_keys
                |---- notifications
                +---- webhook_logs

数据隔离​

每张租户范围的数据表都具备：

  • tenant_id 外键，设置了 ON DELETE CASCADE
  • (tenant_id, created_at) 的复合索引
  • TenantScope 全局作用域，用于自动过滤

当租户被删除时，其所有数据会自动级联删除。

后续步骤​