Skip to content

update datatypes

Luke Brown requested to merge schema-changes into master

Updated the schema datatypes of the PK's to use the smallest acceptable data type that would hold the desired sane value.

  • 99 categories
  • 65535 people
  • 999 queues
  • 4294967295 replies
  • 99 SLA's
  • 99 statuses
  • 16777215 tickets

The primary key for replies was shifted away from UUID as this does not scale well for b-tree indexing. A composite PK for this table makes the most sense from a normalization standpoint, however, the amount of complexity is not really worth it so the decision was made that with the 16 million amount of possible tickets with 4.2 billion possible replies which averages to around 256 replies per ticket which seems like a very reasonable average on the total amount of estimated replies per ticket.

Merge request reports