Schema Browser

The Schema Browser is a read-only reference tool within Commander4j that allows users to explore the structure of the application database. It is intended for use when building custom reports, writing queries, or understanding where particular data is stored.

Using the Schema Browser

The screen is divided into two panels:

Left panel — Tables: Lists all application database tables. Scroll through the list and click a table name to select it.

Right panel — Fields: Automatically populates with the column names available in the selected table when a table is chosen in the left panel.

Both panels are read-only. No data can be edited or deleted through the Schema Browser.

Purpose

Commander4j stores its data across more than 100 database tables, all prefixed with APP_. When creating a custom report in JasperSoft Studio, or when writing a query in the Report Admin screen, it is necessary to know which table holds the required data and what the column names are. The Schema Browser provides this information without needing direct access to the database management tool.

Related Tools

For users building custom reports, the following documentation is also relevant:

Standard Reports — how to duplicate and customise existing JasperReports templates
Report Admin — managing report definitions within Commander4j
System Keys — system-wide configuration settings stored in the control tables