Overview of AL-Pro DataBase

Top Previous Next

The AL-Pro Web Portal Server was designed to allow Web Developers to have access to AL-Pro Data without having to have a complete and intimate knowledge of all of the internal AL-Pro Database table structures. We have purposely surfaced only the absolute minimal data information to allow Web Developers to concentrate on quickly deploying Websites that use AL-Pro data for their content.

We invite any feedback from AL-Pro Web Portal Users to improve our interface to external systems.

The AL-Pro Web Portal provides a rich set of interfaces to allow you to

•	Use a default Agency Price Schedule for a Web Site

•	Show a list of bases

•	Show a List of Tours, Products and Product Categories

•	Getting formatted content from Product and Tour Information

•	Show a list of Tours for an Agency.

•	Choose a Product from a Category or Group

•	Show Product Categories for a chosen Product

•	Get a list of Rates by tour or product

•	Package Support

•	Get Availability by getting a list of scheduled Events for Tours, Products or Packages

•	Show a Manifest for a specific Event

•	Show a Seating chart for a given Event (for AL-Pro Installations that support Seats)

•	Show Seating Detail for a given Event (for AL-Pro Installations that support Seats)

•	Show Reservation information for an event

•	Show Payment information for a given Reservation

•	Show all Seats for a Reservation for a specific Reservation or a specific date

•	Create Reservations that include product categories and seat entries payments

•	Create and Organize Web Clients to support returning Web Customers

•	Process Credit Cards

•	Send Email or Faxes

•	Assign an Event to a Reservation

As is customary in Database applications, AL-Pro uses an SQL Database with fully normalized tables. Thus Web Methods that Get data consist of the "Thing" or "Noun" type Data and an Integer value or "Code" that uniquely identifies that item. Puts involve Verbs or transactions performed on the nouns.

Noun	Integer Code Field
Base	Code
Vessels	Code
Products	Code
ProductGroup	Code
Agencies	Code
Categories	CategoryCode
Agents	Code
Reservation	Code
Seats	SeatCode
Payments	Code

Verbs	Associated Integer Code Fields