Control Database
Admin panel and database control design
A control layer is important for subscription, preview access, shops, devices, payments, sync status and security verification.
Admin controls to show user
- Tenant/shop list
- Active/inactive subscription
- Payment request approval
- Device registration/status
- 15-day offline verification status
- Preview account create/disable
- Medicine data tools
- Backup/restore tools
- Security/OTP/recovery
- Live activity view
Control database concept
| Table | Purpose |
|---|---|
| tenants | Shop/company accounts |
| subscriptions | Plan, expiry, grace period |
| devices | PC/mobile device security |
| payments | Payment requests and approval |
| sync_logs | Offline/online sync audit |
| demo_access | Verified user preview users |
Admin dashboard placeholders
