Table: OTA_DELEGATE_BOOKINGS

Product:	OTA - Learning Management
Description:	An student booking (delegate booking) records an enrollment onto a scheduled, program or one time event.
Implementation/DBA Data:	OTA.OTA_DELEGATE_BOOKINGS

Primary Key: OTA_DELEGATE_BOOKINGS_PK

1. BOOKING_ID

Primary Key: OTA_DELEGATE_BOOKINGS_UK1

1. LINE_ID

Primary Key: OTA_DELEGATE_BOOKINGS_UK2

1. QUOTE_LINE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_DELEGATE_BOOKINGS		OTA_BOOKING_STATUS_TYPES	OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID
OTA_DELEGATE_BOOKINGS		OTA_EVENTS	OTA_DELEGATE_BOOKINGS.EVENT_ID
OTA_BOOKING_STATUS_HISTORIES		OTA_DELEGATE_BOOKINGS	OTA_BOOKING_STATUS_HISTORIES.BOOKING_ID
OTA_FINANCE_LINES		OTA_DELEGATE_BOOKINGS	OTA_FINANCE_LINES.BOOKING_ID
OTA_RESOURCE_ALLOCATIONS		OTA_DELEGATE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS.BOOKING_ID
OTA_TRAINING_PLAN_COSTS		OTA_DELEGATE_BOOKINGS	OTA_TRAINING_PLAN_COSTS.BOOKING_ID