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.
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: