Domain - Access control
Domain description
This domain contains the access control history and corresponds to the ciew D_ACONTROL_TICKETCHECK_V1_0 in which:
1 record = 1 control performed on a ticket with information related to:
Control’s date and time
Control’s location (sector, gate)
Controlled product
Considered tariff
Sales channel
A record is identified in a unique way by means of the attribute T_TICKCHK_ID.
Domain's columns description
The following link contains more information on the data of the domain: linkmissing
Domain - List of tickets
Domain description
This domain contains the list of tickets and corresponds to the view D_SHIPMENTTICKET_TICKETS_V1_0 in which:
1 record = 1 ticket with information related to:
Ticket holder (name, address, structure in case of relay)
Ticket information (price, barcode, state,…)
Ticket purchase (order number, date, purchase contact)
Seat location (in case of performance or match)
Ticket delivery address
A record is identified in a unique way by means of the following attribute: T_TICKET_ID
Domain's columns description
The following link contains more information on the data of the domain: linkmissing
Domain - Questionnaires
Domain description
This domain contains answers to questionnaires and corresponds to the view D_SHIPMENTTICKET_QSTNR_V1_0 in which:
1 record = 1 answer to the questionnaire’s question linked to a ticket (the questionnaire is optional) with information related to:
Ticket holder (name, address, structure in case of relay)
Question and answer
Ticket information (price, barcode, state,…)
Ticket purchase (order number, date)
Linked product
A record is identified in a unique way by means of all the following attributes : T_TICKET_ID, QUESTION
Domain's columns description
The following link contains more information on the data of the domain: linkmissing