S
Sheba ISP ERPDOCS
Database

Complete Models Inventory (53 Models)

Exhaustive directory of all 53 Django models across all 13 backend apps.

Complete Models Inventory (53 Models)

IMPLEMENTED

The backend database schema consists of exactly 53 active Django models verified in the codebase.

1. apps.core (10 Models)

  1. Tenant: Root multi-tenant ISP organization.
  2. TenantDomain: Custom domain and subdomain mappings for host-derived tenancy.
  3. TenantApiToken: Machine-to-machine authentication tokens.
  4. CompanySetting: Tenant-specific branding, currency, and portal settings.
  5. AuditLog: Immutable audit trail for compliance and tracking.
  6. TenantOnboardingRequest: Self-service signup applications from potential ISP tenants.
  7. SaaSPackage: SaaS billing tiers and subscriber quota limits.
  8. TenantSubscription: Active SaaS contract binding a tenant to a SaaSPackage.
  9. SaaSPayment: Billing records for tenant platform payments.
  10. DatabaseBackup: Metadata records for automated database backups.

2. apps.authentication (6 Models)

  1. StaffProfile: User profile details linked to Django's auth.User.
  2. Permission: Granular system permission code.
  3. Role: Tenant-scoped collection of permissions.
  4. StaffMembership: User-to-tenant-to-role binding.
  5. Reseller: Wholesale bandwidth reseller profile.
  6. ResellerLedgerEntry: Financial balance transactions for resellers.

3. apps.customers (1 Model)

  1. Customer: Master subscriber entity with PPPoE credentials, location, and status.

4. apps.billing (5 Models)

  1. Package: Broadband tier with bandwidth, price, and MikroTik profile.
  2. ResellerPricing: Custom discounted wholesale rates for packages per reseller.
  3. Invoice: Monthly subscription invoice.
  4. Recharge: Record of subscription validity renewal.
  5. Offer: Promotional discounts and billing campaigns.

5. apps.finance (6 Models)

  1. BillingAccount: Double-entry accounting ledger account for a subscriber.
  2. InvoiceLine: Itemized charge on an Invoice.
  3. PaymentAllocation: Settlement mapping payments to specific invoices.
  4. LedgerEntry: Immutable credit/debit transaction journal.
  5. Adjustment: Staff manual fee adjustments or waivers.
  6. IdempotencyKey: Unique mutation protection keys with cached responses.

6. apps.payments (5 Models)

  1. PaymentGateway: bKash, Nagad, or bank gateway credentials.
  2. PaymentTransaction: Completed subscriber payments.
  3. PaymentAttempt: Raw payment gateway transaction attempts.
  4. InboundPaymentEvent: Staging buffer for SMS webhooks.
  5. SmsLog: Inbound/outbound SMS gateway records.

7. apps.network (6 Models)

  1. POPBranch: Network Point-of-Presence physical location.
  2. Router: MikroTik edge router registration and credentials.
  3. OLT: Optical Line Terminal chassis registration.
  4. ONU: Optical Network Unit attached to a PON port.
  5. UserSession: Real-time active PPPoE tunnel cache.
  6. NetworkSyncJob: Post-commit durable queue for router/OLT hardware sync operations.

8. apps.support (2 Models)

  1. Ticket: NOC and customer support tickets.
  2. TicketReply: Communication thread on a ticket.

9. apps.hr (5 Models)

  1. Employee: Staff employee record.
  2. Attendance: Daily attendance check-in/out.
  3. LeaveRequest: Employee leave applications.
  4. AdvanceSalary: Employee salary advance tracking.
  5. PayrollRecord: Monthly salary disbursement journal.

10. apps.store (3 Models)

  1. ItemCategory: Hardware inventory categories.
  2. StoreItem: Physical items in stock (cables, routers, SFPs).
  3. StockTransaction: Stock movements in and out of the warehouse.

11. apps.tasks (1 Model)

  1. Task: Maintenance and field technician work orders.

12. apps.callcenter (3 Models)

  1. CallLog: Telephony customer communication records.
  2. VoiceSetting: Telephony gateway configurations.
  3. VoiceTemplate: IVR broadcast audio scripts.

Database Schema Architecture & Invariants

PostgreSQL 16 schema design, indexing strategies, audit fields, and transactional integrity.

Entity-Relationship (ER) Diagram

Mermaid ER diagram representing relationships across tenants, customers, routers, billing, and ledger entries.

On this page

Complete Models Inventory (53 Models)1. apps.core (10 Models)2. apps.authentication (6 Models)3. apps.customers (1 Model)4. apps.billing (5 Models)5. apps.finance (6 Models)6. apps.payments (5 Models)7. apps.network (6 Models)8. apps.support (2 Models)9. apps.hr (5 Models)10. apps.store (3 Models)11. apps.tasks (1 Model)12. apps.callcenter (3 Models)