Open christianpatrick opened 2 years ago
Still got a ways to go, but this is the first take on the database schema. It's funny, I started with just events and before you know it, there's an entire section of tables just for this. Here's the breakdown as I see it now:
events
will be the container for any public incident type (incident or maintenance)updates
will contain the details and timelinemilestones
will be each step in the event (e.g. Maintenance In Progress or Identified the Issue)statuses
are the critical impacts of the connections (e.g. Major Outage or Degraded Performance)I want users to be able to override the naming conventions per page for these labels, hence the reason for the overrides.
To get things started, let's setup the initial system for incident handling: events. Events will be used for reactive type incidents along with maintenance plans.