Command Center Database Requirements
Version: 1.0
Date: August 2026
Author: Pete Carroll, Founder — Traxs Group LLC
Status: Draft
Overview
This document defines a rough draft workthrough of the database requirements needed for the Command Center
Table Descriptions
| Table | Related Tables | Description |
|---|---|---|
| Tenant | Subscription, Entitlement | Data concerning the registered company. It relates to the companies Subription and what they are entitled to |
| Subscription | SubscriptionTypes, SubscriptionTier, Entitlement | Data about the tenants current subscription including the subscription tier and what entitlements the tenant is afforded. |
| Entitlement | PriceCommitment, Products | Data concerning what products a tenant is entitled to, what pricing commitmemt and any rate locks in place |
| Products | Modules | Data related to products the tenant is entitled to and which modules the tenant has paid for |
All of the tables described above are related to what a tenant has subscribed to and what they are entitled to. I think I need to also define tables that define the subscriptions, tiers, pricing, programs and discounts available. I should also define any special's or marketting offers in case we ever run something like that.
Subscription Architecture Tables
These tables will define the current available subscriptions, thier base price, add on user price. Also these will define what the subscription tiers are, pricing models, discounts, original rate, new rates, effective dates.
Platform Administration
These tables will support the platform administration. Things like number of tenants, status, revenue, expenses, system status, system logs, performance, system warnings and errors. Any other type of data I will need to be able to see how well Traxs Group LLC is doing.
Supporting Tables
Any other table that is needed to support the end goal of the company and the system.