Wiki 🔍 Search

QIIUB — Entity Relationship Diagrams

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

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

Created: 2026-03-20 · Last Updated: 2026-06-17

174
Total Tables
31
Central DB
107
Merchant dbo
36
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