Products Domain
productsproducts.ts
departmentsproducts.ts
tax_ratesproducts.ts
tax_groupsproducts.ts
tax_group_ratesproducts.ts
suppliersproducts.ts
product_suppliersproducts.ts
product_specialsproducts.ts
Stores Domain
storesstores.ts
store_product_dynamicstores.ts
store_configstores.ts
purchase_ordersstores.ts
purchase_order_itemsstores.ts
Inventory Domain
inventoryinventory.ts
inventory_adjustmentsinventory.ts
Transfer Domain
transferstransfers.ts
transfer_itemstransfers.ts
Register Domain
register_sessionsregisters.ts
monthly_closingsregisters.ts (HQ only)
Other
customerscustomers.ts
sales_repssales-reps.ts
tenderstenders.ts
worksheetsworksheets.ts (HQ only)
worksheet_itemsworksheets.ts (HQ only)
worksheet_storesworksheets.ts (HQ only)
audit_logaudit.ts
Key Relationships
products → departments (departmentId) → departments (parentId, self-ref)
products → tax_groups (taxGroupId)
tax_group_rates → tax_groups + tax_rates
product_suppliers → products + suppliers
product_specials → products
sales → users (cashierId) + stores (storeId) + register_sessions (sessionId) + customers (customerId)
sale_items → sales + products + sales_reps
sale_item_taxes → sale_items + tax_rates
sale_payments → sales + tenders
inventory → products + stores
inventory_adjustments → products + stores + users
transfers → stores (fromStoreId, toStoreId) + users
transfer_items → transfers + products
store_product_dynamic → stores + products (per-store price/tax overrides)
store_config → stores
purchase_orders → stores + suppliers + users
purchase_order_items → purchase_orders + products
role_permissions → roles + permissions
user_store_roles → users + stores + roles
worksheets → users (createdBy/approvedBy)
worksheet_items → worksheets + products
worksheet_stores → worksheets + stores
sync_outbox → entity tracking (entityType, entityId)