System Module Architecture
10 Core Modules with Database Schema Mapping
Authentication & Accounts
Auth, sessions, OAuth
Tables:
user
session
account
verification
Organization & Membership
Teams, roles, invitations
Tables:
organization
member
invitation
Notifications & Preferences
User notifications
Tables:
notificationPreferences
notification
Ownership Transfer
Organization ownership
Tables:
ownershipTransfer
Security & Audit
Audit logs, tracking
Tables:
securityAuditLog
sessionTracking
Client Management
Client records
Tables:
client
Tender Management
Tenders, extensions
Tables:
tender
tenderExtension
Project Management
Projects, POs
Tables:
project
purchaseOrder
Support & Feedback
User support & feedback
Tables:
feedback
support_tickets
Document Management
Centralized file storage
Tables:
document
Module Relationships
Core Relationships:
Auth → Organization (Users belong to orgs)
Organization → All Business Modules (Org-scoped data)
Client → Tender (Clients have tenders)
Tender → Project (Tenders become projects)
Project → Purchase Orders (Projects have POs)
Cross-cutting Concerns:
Notifications monitors all modules
Security & Audit logs all actions
Ownership Transfer manages org transitions
Documents linked to Tender, Project, PO, & Extensions
Implementation Notes
- ✓Soft Deletion: Client, Tender, Project, Purchase Order, Follow-up support soft deletion
- ✓Multi-tenancy: All business data is organization-scoped
- ✓Role-based Access: Owner, Admin, Manager, Member roles supported
- ✓Audit Trail: Security audit log tracks all sensitive operations
- ✓Session Management: Comprehensive session tracking with suspicious activity detection