This appendix contains a complete list of the available tables and columns, as well as the type of data that each column contains.

Where the datatype of a field is listed as the name of a table in italics, that means the field is used to  Cross-referencing Table Fields to the table.

Example:

The table tickets has a field called charges of datatype Ticket Charge.

That means that in a query that is FROM tickets, you can use tickets.charges.* cross-references to retrieve information from the Ticket Charge table.

e.g. to retrieve the charge time for a ticket:

tickets.charges.charge_time