| Server IP : 72.60.21.38 / Your IP : 216.73.217.140 Web Server : LiteSpeed System : Linux uk-fast-web1372.main-hosting.eu 4.18.0-553.121.1.lve.el8.x86_64 #1 SMP Thu Apr 30 16:40:41 UTC 2026 x86_64 User : u390967363 ( 390967363) PHP Version : 8.2.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u390967363/domains/aibenproperties.com/public_html/app/ |
Upload File : |
erDiagram
COMPANY ||--o{ USER : has
COMPANY ||--o{ ESTATE : owns
COMPANY ||--o{ CLIENT : serves
COMPANY ||--o{ AGENT : engages
COMPANY ||--o{ PAYMENT_PLAN : offers
COMPANY ||--o{ DOCUMENT : manages
COMPANY ||--o{ NOTIFICATION_TEMPLATE : defines
USER }o--|| ROLE : assigned
ESTATE ||--o{ PHASE : contains
PHASE ||--o{ BLOCK : contains
BLOCK ||--o{ PROPERTY : groups
PROPERTY ||--o{ RESERVATION : reserved_in
PROPERTY ||--o{ ALLOCATION : allocated_in
PROPERTY ||--o{ PROPERTY_STATUS_HISTORY : tracked_by
CLIENT ||--o{ LEAD : originates
CLIENT ||--o{ RESERVATION : books
CLIENT ||--o{ ALLOCATION : owns
CLIENT ||--o{ PAYMENT : pays
CLIENT ||--o{ INSTALLMENT : obligated_to
CLIENT ||--o{ CLIENT_KYC : verified_by
CLIENT ||--o{ CLIENT_LEDGER_ENTRY : recorded_in
AGENT ||--o{ LEAD : handles
AGENT ||--o{ RESERVATION : drives
AGENT ||--o{ COMMISSION : earns
RESERVATION ||--o{ RESERVATION_APPROVAL : checked_by
RESERVATION ||--o{ PAYMENT : seeded_by
ALLOCATION ||--o{ ALLOCATION_LETTER : documented_by
ALLOCATION ||--o{ REALLOCATION_REQUEST : may_have
ALLOCATION ||--o{ CANCELLATION_REQUEST : may_have
PAYMENT_PLAN ||--o{ INSTALLMENT : schedules
INSTALLMENT ||--o{ PAYMENT : settled_by
PAYMENT ||--o{ RECEIPT : confirmed_by
PAYMENT ||--o{ REFUND : may_be_refunded_by
AGENT ||--o{ COMMISSION_RULE : governed_by
COMMISSION_RULE ||--o{ COMMISSION : calculates
DOCUMENT ||--o{ DOCUMENT_VERSION : versions
DOCUMENT ||--o{ DOCUMENT_LINK : linked_to
NOTIFICATION_TEMPLATE ||--o{ NOTIFICATION : used_for
USER ||--o{ AUDIT_LOG : generates
USER ||--o{ NOTIFICATION : receives