Design Specifications
This document shows all table databases as well as the logic of the Jframework project.
Table Structure
We group the tables by the following categories:
System Definitions: Tables that define the system data.
System Configurations: Tables that store the system, brand, and user configurations/settings.
Soft Deletion: Tables that store soft-deleted records (i.e., Brand, User, Device).
Role-Based Access Control: Tables that store role-based access control data.
Plans & Pricing: Tables that store plan and pricing data (i.e., Package, Price, Coupon, License, etc.).
Payment-Related: Tables that store payment-related data (i.e., Payment, PaymentMethod, PaymentHistory, etc.).
Point-Related: Tables that store point-related data (i.e., Point, PointHistory, PointEvent, etc.).
Tracking-Related: Tables that store tracking-related data (i.e., TrackingActivity, TrackingEvent, etc.).
Relationships: Tables that store relationship tables (i.e., CouponUser, RolePermission, UserRole, etc.).
Last updated