Documentation

Database Usage Guide

This guide explains how your information is saved and updated in the system when you use the website and dashboard. You do not need SQL knowledge. Every update happens through forms and actions in the app.

Quick navigation

What this means Data lifecycle Statuses Best practices Security and privacy Troubleshooting

What database usage means for users

When you submit a form, the system creates or updates a record in the database.
When you view Cars, Containers, Wallet, Reports, and Rates, you are reading saved records.
When you upload images/documents, file paths are stored and linked to your records.
Your dashboard data is filtered to your account where access rules require it.

Data lifecycle by module

Cars

A car request is submitted first, then an admin can assign a car record to your request. You can view details and export PDF for assigned cars.

Containers

A container request is submitted, then assigned by admin. Assigned containers appear in your list and can be opened for details or exported as PDF.

Rates and PDFs

Shipping and towing rates are read from managed tables. PDF generation can run immediately or through a queued flow depending on action.

Profile and settings

Your profile details (name, email, phone, company, avatar) are saved to your user record and reused across dashboard pages.

Request statuses and assignment flow

Status	Meaning	What to do
pending	Your request is received and waiting for admin action.	Review your request details and wait for assignment.
assigned	An admin linked your request to a specific car or container.	Open the assigned record and verify all details.
cancelled	The request was stopped and is no longer active.	Create a new request if you still need service.

Data quality best practices

Use complete, consistent names for make/model, location, and destination fields.
Double-check ID-like values such as VIN, LOT, booking number, and container number.
Upload clear images/documents and avoid duplicates to keep records clean.
Add short, specific notes that help admins process your request faster.
Update old records instead of creating duplicate requests for the same case.

Security and privacy basics

Always use your own account and keep your password private.
User-level pages are restricted so you only access records assigned to your account.
Admin-only sections are protected and hidden for non-admin users.
If access is denied, verify login state and account permissions before retrying.

Troubleshooting common issues

Validation error after submit

Review highlighted fields and input format, then submit again.

Missing assigned car/container

Refresh the listing page and check request status. If still missing, contact support/admin.

403 or unauthorized page

You may be trying to open data that does not belong to your account or requires admin access.

PDF not ready or expired link

Request a fresh PDF from the rates page, then download from the newest generated link.