| Account |
Unique Identifier |
A unique identifier assigned to a customer or agent. |
OTS |
- |
- |
Many Customers to One Account, Many Agents to One Account |
| Address |
String |
The customer's mailing address for ticket delivery. |
Customer Input |
- |
- |
Many Customers to One Address |
| Agent |
Entity |
A representative of the BCPA authorized to sell tickets. |
BCPA |
- |
- |
Many Events to Many Agents, Many Tickets to One Agent |
| Assigned Seats |
Seat List |
The seats that an agent is authorized to sell. |
Contracts |
Linked to agent's contract with BCPA. |
- |
Many Agents to Many Seats |
| Best Available Seats |
Seat List |
Seats available for purchase based on customer preferences. |
OTS |
Calculated based on customer's desired price range and seat availability. |
- |
Many Customers to Many Seats, Many Events to Many Seats |
| Card Number |
String |
Unique identifier for a credit card. |
Customer Input |
- |
Format: Numeric, Length: 16 digits |
- |
| Commission |
Percentage |
The percentage of ticket price paid to the agent. |
Contracts |
Defined in the agent's contract with BCPA. |
Value Range: 0% to 100% |
- |
| Contract |
Agreement |
Agreement between BCPA and an agent defining terms. |
BCPA |
Governs agent's authorization and ticket sale terms. |
- |
Many Agents to One Contract |
| Customer |
Entity |
Individual or organization purchasing tickets. |
Customers |
- |
- |
Many Tickets to One Customer |
| Date Range |
Date Period |
A specified period of time (e.g., week or month). |
OTS |
Used for selecting events within a specific timeframe. |
- |
Many Events to Many Date Ranges |
| Discount |
Percentage |
Reduction in ticket price. |
Promotions |
Applied as part of marketing campaigns. |
Value Range: 0% to 100% |
Many Events to Many Discounts |
| Event |
Event Details |
Performance or activity held at the BCPA. |
BCPA |
Represents the various events and shows. |
- |
Many Performances to One Event, Many Tickets to One Event |
| Hold State |
Boolean |
The status of a seat during the purchase process. |
OTS |
Indicates whether a seat is currently on hold. |
- |
Many Seats to Many Hold States |
| Maximum Seats Per Customer |
Integer |
Maximum seats a customer can purchase for an event. |
Venue Manager |
Controlled by venue manager for each event. |
Value Range: Positive integers |
Many Events to One Maximum Seats Per Customer |
| Order Number |
Unique Identifier |
Unique identifier assigned to a ticket purchase. |
OTS |
- |
- |
Many Tickets to One Order Number |
| Password |
String |
Secret code for user authentication and OTS access. |
User |
Must be kept secure and not shared. |
- |
Many Customers to One Password |
| Performance |
Event Details |
A specific showing of an event at the BCPA. |
BCPA |
Linked to an event, representing individual showings. |
- |
Many Tickets to One Performance, Many Events to Many Performances |
| Price Range |
Price Range |
A range of ticket prices. |
OTS |
Used for customer's selection of desired price range. |
- |
Many Events to Many Price Ranges |
| Promotion |
Marketing Campaign |
Marketing campaign offering discounts or incentives. |
Promotions |
Defines promotional offers for ticket purchases. |
- |
Many Events to Many Promotions, Many Tickets to Many Promotions |
| Reserved Seat |
Seat |
A seat that has been purchased and cannot be bought by others. |
OTS |
Indicates seats that are already sold. |
- |
Many Tickets to Many Reserved Seats |
| Seating Chart |
Diagram |
A diagram of BCPA's seats, showing seat statuses. |
BCPA |
Provides visual representation of seat availability. |
- |
One Seating Chart for Many Events, Many Seats to One Seating Chart |
| Seat Assignment |
Seat |
Specific seat assigned to a ticket. |
OTS |
Links each ticket to a particular seat. |
- |
Many Tickets to Many Seat Assignments |
| Show |
Event Details |
General term for an event or performance at the BCPA. |
BCPA |
Represents all events and performances. |
- |
Many Performances to One Show, Many Tickets to One Show |
| Sign On |
Authentication |
The process of logging into the OTS. |
OTS |
Required for access to the online ticketing system. |
- |
Many Customers to One Sign On |
| Ticket |
Ticket Details |
A document granting the holder the right to attend an event. |
OTS |
Represents the ticket for attending an event. |
- |
Many Seats to Many Tickets, Many Customers to Many Tickets |
| Venue Manager |
Entity |
Person responsible for managing the BCPA. |
BCPA |
Overseeing BCPA operations and event scheduling. |
- |
Many Events to One Venue Manager |
| Volume Discount |
Percentage |
Discount offered for purchasing multiple tickets. |
Promotions |
Applies to bulk ticket purchases. |
Value Range: 0% to 100% |
Many Events to Many Volume Discounts |