Skip to main content

Data Model Reference

Primary tables:

  • users
  • otp_codes
  • projects
  • tickets
  • ticket_history
  • comments
  • attachments
  • dev_tasks
  • ticket_relations
  • ticket_external_references
  • telemetry_events
  • domain_events
  • event_outbox
  • settings

Key relations​

  • tickets.reporter_id -> users.id
  • tickets.assignee_id -> users.id
  • comments.ticket_id -> tickets.id
  • attachments.ticket_id -> tickets.id
  • dev_tasks.ticket_id -> tickets.id
  • event_outbox.event_id -> domain_events.id

Defaults worth knowing​

  • settings.app_name = OpenArca
  • settings.edition = open_core
  • settings.feature_flags = {}
  • settings.mail_provider = smtp