QIIUB — Entity Relationship Diagrams

Multi-tenant, Offline-First POS Platform — Full Database ERD

148 tables across 2 databases · Click any section to explore relationships

158
Total Tables
23
Central DB
93
Merchant dbo
37
Reference (ref)
15
ERD Sections

Legend

Schema Colors

dbo (business)
ref (lookup/seed)
audit (trail)
sync (infrastructure)
central DB

Relationship Notation (Crow's Foot)

||--|| One to One (exactly one)
||--o{ One to Many (one to zero or more)
||--o| One to Zero-or-One (optional)
}o--o{ Many to Many (via junction table)

Column Markers

PK Primary Key
FK Foreign Key
UK Unique Constraint

Table Index — Click to highlight in diagrams