Source and Synchronisation Domain
Overview
Sources are the 3rd party systems from whom we fetch details of the supplier and the products that they make available and to which we push details of all confirmed bookings. It is also the source that will provide us with final tickets for any booking which we then attach to our vouchers and send to the consumer or agent.
There is a special case source known as INTERNAL. This represents our own booking management system which we offer in a Software as a Service (SaaS) model to select partners. The internal source deals with products that were directly entered into our system by the partners and their suppliers.
The internal sourceIntegrationService provides the rest of our systems with the same interface as any other sourceIntegrationService.
The following tables are defined in the source domain:
Source - The primary table for this domain, containing credentials used to communicate with the domain.
SynchronisationSource - (to be refactored to SourceInstance) - Details specific instances of a source as may be required in some cases. There will always be at least one record in this table for a given Source. All Suppliers in the system are mapped to a SourceInstance.
SynchronisationActivity - Used by the system for monitoring and tracing.
SynchronisationError - Used by the system for monitoring and tracing.
SynchronisationReport - Used by the system for monitoring and tracing.
SynchronisationResponseNode - Details every JSON path known to the system from mapped from responses to fetch product requests.
SynchronisationResponseProduct - Used for logging and debugging this table holds a record of responses received from the given source.
Product Mapping
The following tables currently exist in the product domain and are used to map certain terms used by source systems to our standard taxonomies.
These tables will eventually by moved to the Taxonomy or Source domains
ProductKeywordMatch - Map keywords from source systems to our taxonomy
ProductContentMatch - Map content phrases from source systems to our taxonomy
Product Availability and Pricing
The following tables are only used by our INTERNAL source product and form part of the company booking management system which is offered to select partners on a Software as a Service (SaaS) commercial model.
The following additional tables are defined in the product domain:
ProductAvailability -
ProductAvailabilityPattern -
ProductPricingVariant -
ProductPrice -
ProductStartTime -
ProductStartTime
ProductPricingVariantAssociation -ProductPricingVariant
ProductAvailabilityPatternAssociation -
Invalid product domain tables
The following tables currently exist but are not technically part of the Product domain.
Their purpose is documented elsewhere in this document as referenced in the details below and there are tickets in the backlog to perform the necessary refactors.
The following tables are currently defined:
ProductImageImageCategoryAssociation - see image domain.
ProductContentMatch - see taxonomy domain.
ProductCategory - see taxonomy domain.
ProductAttribute - see taxonomy domain.
ProductBookingQuestion - see EntityQuestion.