An analysis screen that displays the data model behind the service: which tables there are, what they contain and how many rows there are.
## One screen per table
Each table in the data model has its own screen. This appears as a tile in Menu, in the group corresponding to the table (“Reports”, “Transactions” or “Reference Tables”), labelled with the table’s name in plain language: “Queries”, “Messages”, “Daily Budget”. The address is /table/ followed by the table name.
A screen like this does not display all the columns, but only the ones that matter, in a logical order and with the most recent row at the top. The table of questions has 68 columns and the screen displays fourteen of them. Where it is useful, there is a search field above it that searches within a few specified columns; the specific columns are listed below the field.
A screen doesn’t change anything. It just displays text.
If you do need a column that omits the screen, click at the bottom to go to the generic table view. This displays all the columns in every table, including those that do not yet have their own screen.
What a column means
Above each column is a name in plain English: “Asked at” above asked_at, “Cost (EUR)” above cost_eur. If you hover your mouse over one of these headings, you’ll see the technical name of the column and a sentence explaining what it contains.
That explanation is also included in the database itself, as a comment on the table and on the column. Anyone viewing the database using a different programme, such as psql or pgAdmin, will see exactly the same sentence there. So there is only one source for that explanation.
Each table also has a short three-letter code in accordance with Oracle’s QMS/CDM standard. The code is derived from the name and is not made up. The table containing queries is called ‘qtn’, whilst the table containing messages is called ‘mse’.
The headings and explanations are in English, even if the rest of the screen is in Dutch.
Values in a list
A ‘yes’ or ‘no’ appears as a tick box in the list, just as on the other screens of the console, rather than as the word ‘True’. An empty box means ‘no’. If there is nothing at all, the value is empty, which is different from ‘no’: in some columns, ‘empty’ means that something has never been determined.
Dates are displayed in the format corresponding to the logged-in user, the same format as on the other screens. Times are shown in UTC.
A whole number (smallint, integer or bigint) is right-aligned, using the registered user’s thousands separator, as elsewhere in the console. An amount or other decimal number (numeric, decimal) is still displayed exactly as it is stored, without any separators: this is not a matter of preference, as such a value loses precision when it passes through a double on its way to the screen, whereas a whole number has nothing to lose because it has no decimal part. Up to and including version 1.3.68, integers were also displayed without a separator.
A short code such as the language (culture) is centred beneath its heading, rather than aligned to the left-hand side of a column that is much wider than the code itself.
Available from version 1.3.41. The column names and descriptions are included from version 1.3.51. The tick boxes and dates are included from version 1.3.52. The thousands separator for whole numbers and the centring of short codes are available from version 1.3.69.