HomeLog InSign Up

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.).

Progress
PreviousIntegrate reCAPTCHANextSystem Definitions

Last updated

Was this helpful?