Back to Home

Schema hub

Database and module diagrams, column definitions, and data browsers—grouped by area.

KPI

KPI algorithm module — tables, FKs, and row-level data

KPI schema (diagram)Tree & foreign-key views for KPI modules, algorithm, framework, bases, result.
KPI schema dataBrowse and query KPI schema tables; export & SQL templates.
KPI manageHub for KPI settings, modules, queries, framework, and schema shortcuts.

System

Remote system DB — modules_meta-linked tables and relationships

System schema (diagram)Module → table tree and FK graph for the system database.
System schema dataBrowse system tables, columns, and rows.

Modules & navigation

Application screen groups and menu structure (scm_modules_meta)

Module schemaTree of module groups, screens, and relationships (scm_modules_meta).

Generic table viewer

Any table — structure, sample data, export (remote or local DB)

Table viewerPick a database and table; inspect columns and relationships.
Table viewer (data)Paginated rows, filters, export, ad-hoc SQL for selected tables.

Rates & pricing

Rate engine masters, basis mapping, port matrices, and lane tools

Rate calculation engineMaster tables — schema per entity (rate_basis, packages, lanes, etc.).
Booking - Consol QueryMetrics by booking or consolidation code (remote DB).
Rate basis (dimension 1)Quantity mapping — CTR, CBM, PCS by category / UOM.
Port group rate matrixPort groups and matrix-backed rate structure.
Route rate finderLookup rates by route context.
Customer rateCustomer-facing rate maintenance.
Carrier rates + DB Q&ACarrier rates with natural-language DB context.
Costing templatesManage template versions (by region).
Costing templateEdit sections, charges, margin; assign template name.
Rate Search PortalSearch rates; surcharge columns by costing template.

Charges

Charge codes, meta settings, and CRUD with live column schema

Charges masterMain charges table — schema-driven grid.
Charges metaMeta / settings rows with column definitions from API schema.
Add chargeCreate charge rows using current table schema.

Explore & docs

Natural language and reference material

DB Q&AAsk questions in plain language; answers use live database schema (Ollama).