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.
Source: HERE.
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. |
RDBMS
HSQL Database Engine 1.8.0
File location
/home/jean-pierre/Documents/BaseDocumenter/www/databases/WorldCup/WorldCup.odb
Connection string
sdbc:embedded:hsqldb
Connection by user
SA
Quoting character for table & field names
"
Field types [* max. length]
TINYINT
BIGINT
LONGVARBINARY * 2147483647
VARBINARY * 2147483647
BINARY * 2147483647
LONGVARCHAR * 2147483647
CHAR * 2147483647
NUMERIC
DECIMAL
INTEGER
SMALLINT
FLOAT
REAL
DOUBLE
VARCHAR * 2147483647
VARCHAR_IGNORECASE * 2147483647
BOOLEAN
DATE
TIME
TIMESTAMP
OTHER
|
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
|
