C.3. Airline Pricing Database
The airline pricing database is similar to the hotel database. The pricing logic is used in either case; however, the fields are somewhat different. For the airline database, the table PriceMaster has the necessary prices for a certain class, origin, and destination, and the effective dates for each entry. The schema for this table is in Table C.9.
| Field Name | Type | Description |
|---|---|---|
| ID | AutoNumber | Record key |
| RoomType | Text | Type of room. Three possible values. SB — Single Bed, DB — Double Bed, SU — Suite |
| BasePrice | Number | The minimum price hotel must charge |
| MaxMarkup | Number | Maximum markup over the base price |
| EffStartMonth | Number | Month when the rate takes effect |
| EffEndMonth | Number | Month ... |
Get Web Services: A Java™ Developer’s Guide Using E-Speak now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
