LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/WorldCup/WorldCup.odb
File actual save date2018-08-14 17:26:18
Scanning done on2018-08-21 17:56:57
Documentation generated on2018-08-21 17:57:07
Table of contents
WorldCup
Database
Free comments Technical specifications BaseDocumenter : Preferences
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