Backline Vegas
Data model
Maya Chen
owner
Tenant isolation
RLS
Every tenant-owned table has organization_id
Role model
5 roles
Owner, admin, manager, staff, viewer
Live keys
None
Mock UI stays local until Supabase is connected
Tenant setup
Organizations, settings, branding, and setup progress describe each hosted customer before any live data sync exists.
organizations, organization_settings, organization_branding, setup_progress
Access control
Profiles identify users, while staff members decide who belongs to a tenant and what role they have.
profiles, staff_members
Rental operations
Customers, inventory, packages, orders, invoices, payments, and maintenance logs power the day-to-day workflow.
customers, inventory_items, inventory_units, rental_packages, rental_orders, rental_order_items, invoices, payments, maintenance_logs
Audit trail
Activity logs capture important changes so support and future automation can explain what happened.
activity_logs
System tables
Plain-English map for future Supabase integration work.
| Table | Purpose | Development note |
|---|---|---|
| organizations | One customer tenant | Root record for Backline Vegas or any future tenant. |
| organization_settings | Tenant preferences | Timezone, currency, deposit defaults, and enabled modules. |
| organization_branding | Tenant brand | Logo, colors, invoice footer, and public-facing copy. |
| setup_progress | Onboarding checklist | Tracks what Sierra Technology Group has configured. |
| profiles | Signed-in users | App profile that will map to Supabase Auth users later. |
| staff_members | Roles and permissions | Owner, admin, manager, staff, and viewer access. |
| customers | Rental clients | Companies or people that book gear and services. |
| inventory_items | Catalog items | Reusable item definitions like consoles, truss, or wireless racks. |
| inventory_units | Physical assets | Serialized units with asset tags, status, and location. |
| rental_packages | Reusable bundles | Common package templates with price, deposit, and visibility. |
| rental_orders | Rental jobs | Booked work with event details, status, totals, and customer. |
| rental_order_items | Order lines | Packages, inventory, labor, delivery, discounts, or custom lines. |
| invoices | Billing documents | Amounts due and paid, linked to customers and rental orders. |
| payments | Money received | Payment records with placeholder Stripe ids for now. |
| maintenance_logs | Service records | Repair and QC notes for units or item families. |
| activity_logs | Audit events | A timeline of setup, order, maintenance, and support actions. |
Roles
These roles are ready for Row Level Security policies in Supabase.
| Role | Access level | Simple meaning |
|---|---|---|
| owner | Full tenant control | Billing, settings, staff, and all tenant data. |
| admin | Full operations control | Can manage setup, staff, branding, and tenant records. |
| manager | Operations lead | Can manage customers, inventory, orders, invoices, and payments. |
| staff | Operations user | Can work customers, gear, orders, maintenance, and activity. |
| viewer | Read-only | Can inspect tenant data without making changes. |