A very nice database for management of football wordcups.
Was first designed for the tournament in Brazil. In the mean time updated for that in Russia.
Designed by Villeroy.
This database makes use of hierarchical form names.
The documentation of such forms will be available with LibreOffice 6,2.
Nevertheless it is already shown as from now.
HSQL Database Engine 1.8.0
Connection by user
Quoting character for table & field names
Field types [* max. length]
LONGVARBINARY * 2147483647
VARBINARY * 2147483647
BINARY * 2147483647
LONGVARCHAR * 2147483647
CHAR * 2147483647
VARCHAR * 2147483647
VARCHAR_IGNORECASE * 2147483647
|Options used for documentation generation :
✔ Scan tables
✔ Collect data samples
✔ Collect data statistics
✔ Scan queries
✔ Parse and beautify SQL code
✔ Scan forms
✔ Include form screenshots in output pages
✔ Scan dialogs
✔ Include dialog screenshots in output pages
✖ Include dialogs stored in preloaded libraries
✖ Scan toolbar buttons
✔ Scan modules
✔ Parse Basic procedures
✖ Include modules stored in preloaded Basic libraries
Dependencies between items are identified when :
✔ a table or a query name is used as a literal in a Basic procedure
✔ a table or a query is the record source of a form or a subform
✔ a table or a query is the data source of a list- or combobox
✔ a table or a query is referenced in a SQL statement
✔ a form name is used as a literal in a Basic procedure
✔ a dialog name is used as a literal in a Basic procedure
✔ a procedure is referenced in a document event
✔ a procedure is referenced in a form event
✔ a procedure is referenced in a dialog event
✔ a procedure is referenced in a (form or dialog) control event
✖ a procedure is referenced by a toolbar button
✔ a procedure is called by another procedure