Notes on Using GARD
Each individual table can be searched by entering search criteria in the fields shown when you click on the table link. Searches are case-insensitive.
An 'OR' facility does exist - use the pipe symbol "|". However, beware of using unnecessary spaces. A search for "crokinole|pool" will find items that "crokinole | pool" does not.
These are real-text searches and do not work in the same way as search engines. So if you search Examples for "quail" you will find a game called "Quails" but you will also get several games called "Squails".
In the same vein, if you search for 'The Journey' in the Game Example 'name' field you will not find a game entitled 'Journey (The)'. A better strategy is to stick to the key words i.e. in this example just search for 'Journey'.
The Scan Repositories facility is less specific but very powerful. Using the same search technology as above, all relevant fields in all selected tables will be searched for the text entered in the single scan field. Results are produced from all selected tables in a single list. This facility only scans the main repositories, not the core tables.
The following table shows the existing main repositories of data in GARD. These are the outer tables with the primary information:
The outer tables surround and link to the the core tables:
The front-end source code for GARD and the data schema have been written by James Masters. Source code and Schema are freely given to be used for the purposes of GARD for perpetuity. Anybody wishing to use the source code for any other reason whatsoever, should first contact him.
The back-end database for GARD is MySQL, an open-source relational database.