Tables

There are two types of tables in a FADA database:

• Tables that you define, which contain basic data and user data.
• FADA tables .

Your tables

You can create as many tables as you want. For each table and field, you'll define the FADA properties that determine your application's behavior.

Your tables are defined in CreateTables.sql.

FADA tables

See tooltips in FADAcore for more information.

fada_launchers

Contains your application's launchers (menu and buttons), each with:

• the table or view to display/edit, or the script to execute
• the tab or user dialog title
• the description that appears in the tooltip
• the predefined data filters (WHERE) (for tables and views)
• the parameters for displaying the data as a graph (for tables and views).

fada_t_schema

Contains the list of your tables/views, with the following information for each:

• a description that appears in a tooltip
• how to create the text summary for a record
• whether to position the view at the top or bottom of the record display
• an SQL query determining if the table/view can be viewed/edited (if not read-only)
• the text to display if the table/view cannot be viewed/edited
• the display color of the table/view
• whether the table/view is read-only

fada_f_schema

Contains the list of the fields in your tables/views, with the following information for each:

• a description that appears in a tooltip
• whether the column should be hidden by default when viewing/editing
• the default column width
• whether the display cell should be merged with adjacent cells
• the display color if different from the table color
• conditional formats for displaying user data
• the list of values ​​for a dropdown list
• the data filter (WHERE) to apply when selecting a foreign key (FK)
• the display order (ORDER BY) of foreign keys upon selection
• whether the field is monetary
• whether the field is multi-line text
• whether the field is drawn
• an SQL query dynamically determining the field's column header
• whether the field is read-only for the end user
• the unit for numeric fields

fada_scripts

Contains the scripts, each with:

• creation date, last modification date, and last execution date
• its status: in development, in production

fada_u_schema

Contains the updates of your application, each with:

• which older versions the update should be applied to
• SQL statements that will be applied to the old tables

fada_tr_keys

Contains the words and phrases to be translated (keys):

• FADAcore keys displayed in tables (Settings) and are already translated.
• keys from your application (table keys, field keys, dialog keys, etc.)
• whether the key is a reference
• the contexts of use
• translator's notes

FADAcore keys are NOT visible from the translation tab.

Your application's keys are created at runtime.

fada_translations

Contains translations in the languages ​​supported by FADAcore, each with:

• the translation status
• verification of the translation length against the key length
• verification of compliance with reference keys
• translator's notes

FADAcore keys are NOT visible from the translation tab.