Schema Migrations - Table Usage Reference

This document lists all database tables that are referenced in the codebase, specifically in /apps/dashboard and /apps/api directories.

Tables Used in Dashboard (/apps/dashboard)

Core Tables

• account_access_groups
• accounting_rules
• access_groups
• audit_log
• balance_sheets
• calendar_events
• changelog
• companies
• company_members
• company_settings
• company_usage
• contact_persons
• contacts
• customer_activity
• customer_jurisdictions
• customer_types
• customers
• dashboards
• domains
• emails
• email_templates
• export_requests
• feature_flags
• files
• frontend_config
• global_companies_registry
• global_merchants_registry
• import_schema_mappings
• incoming_emails
• integration_registry
• integrations
• invoice_settings
• invoices
• ip_identities
• jobs
• line_item_invoice
• notifications
• payment_method_configuration
• payment_methods
• ponto_account
• prices
• products
• quote_line_items
• quotes
• reconciliation_activity
• reconciliations
• reconciliations_match_scores
• reconciliations_staging
• reconciliations_weight_registry
• resource_routes
• sidebar_layout
• tickets
• transactions
• user_view_settings
• users
• versioning

Aurora Tables

• aurora_keys
• aurora_line_items
• aurora_parser_rules
• aurora_requests

Documents Tables

• documents_v2

Microsoft Graph Integration Tables

• microsoft_calendar_events
• microsoft_graph_calendars
• microsoft_graph_contacts
• microsoft_graph_inbox_rules
• microsoft_graph_onedrive_files
• microsoft_graph_user

Mollie Integration Tables

• mollie_accounts
• mollie_balances
• mollie_oath2_authorizations

SF Formations Tables

• sf_formation_tickets
• sf_formations_cases
• sf_formations_members

Shopify Integration Tables

• shopify_orders

Stargate Tables

• stargate_audit_log
• stargate_logs
• stargate_ponto_accounts
• stargate_ponto_consents
• stargate_ponto_tokens
• stargate_ponto_transactions
• stargate_ponto_webhook_events

Views

• v_cases
• v_cases_stats
• v_sf_formations_company_status_counts
• v_user_states

Other Integration Tables

• yuki_credentials

Tables Used in API (/apps/api)

Core Tables

• shopify_orders (used in shopify-import-service.ts)

Notes

• Tables are listed alphabetically within each category
• Views are listed separately as they are not actual tables but database views
• Some tables may be referenced in both directories
• This list is compiled from actual code references found in the repository
• Tables are referenced via:
  • table_name parameter in API calls
  • table property in useApiClient hooks
  • .from() calls in Supabase queries
  • Direct table name strings in various contexts

Usage Patterns

API Pattern

{
  table_name: "table_name",
  conditions: [...],
  ...
}
```typescript

### Supabase Pattern
```typescript
supabase.from("table_name").select(...)
```typescript

### useApiClient Pattern
```typescript
useApiClient({
  table: "table_name",
  conditions: [...],
  ...
})
```typescript