Skip to content

Database Schema Documentation

This folder documents the database schema for the FarmCove Delta application — a film production management system with robust user management, permissions, and workflow features. It was split from the previous monolithic DATABASE_SCHEMA.md to keep each domain readable on its own.

Domain Index

  • Conventions — base columns, RLS patterns, soft-delete conventions, advisor-warnings reference
  • Enums — every PostgreSQL enum used across the schema
  • Core — entities, users, user_settings
  • Projects — projects, organisations, user_accesses, role_definitions, project_relationships, project_transaction_fallbacks
  • Permissions — permissions, permission_roles, permission_role_links, plus per-module permission tables
  • Sensitive Data — sensitive_rules, sensitive_fields
  • Navigation — menu_items, menu_item_categories
  • Internationalization — countries, currencies, languages
  • Categories — categories, category_groups, project_categories, role_definition_categories
  • Attachments — attachments, entity_attachments, project_relationship_attachments
  • Financial — departments, transactions, transaction_items, payment_methods, project_currency_rates, payments, payment_reconciliations, payment_method_assignments, import_mappings, import_fields, import_runs
  • Budgets — budgets, budget_headers, budget_items, budget_item_daily_allocations, budget_allocation_transaction_items
  • Production — production_phases, production_days, schedules
  • Forms — form_types, form_definitions, form_definition_screens, form_definition_fields, form_submissions, entity_associations
  • Communication — conversations, conversation_instances, conversation_summaries, messages, message_attachments
  • Notifications — notifications, notification_deliveries, notification_templates, notification_template_categories, notification_senders, notification_attachments, notification_action_tokens
  • Approval System — approval_configurations, approval_tiers, approval_tier_approvers, approval_requests, approval_instances
  • AI Processing — ai_functions, ai_prompts, ai_prompt_functions, processing_jobs, processing_job_steps, processing_issues, processing_issue_templates, project_issue_settings, process_templates, process_template_steps, process_template_issue_actions
  • Integrations — integration_credentials, integration_entity_mappings, integration_feature_dependencies, integration_features, integration_provider_countries, integration_providers, integration_reference_data, integration_sync_logs, project_integration_features, project_integrations, tax_rate_mappings
  • Tax & Tagging — tax_schemes, tax_rates, tags, taggings
  • System — rate_limit_configs, abuse_actions, abuse_patterns, addresses, exports
  • Views & Functions — database views, RPCs, triggers, realtime tables, provider-swap notes