product
Tables (7)
Accessory
- AccessoryID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- AccessoryType — VARCHAR(100)
- Price — DECIMAL(10, 2)
- Description — TEXT
AddOnService
- AddOnID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- ServiceType — VARCHAR(100)
- Price — DECIMAL(10, 2)
- Description — TEXT
BundleProduct
- BundleID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- BundleName — VARCHAR(255)
- BundleType — VARCHAR(100)
- Price — DECIMAL(10, 2)
- Description — TEXT
BundleProductDetail
- BundleDetailID — INT — Primary key
- BundleID — INT — Foreign key → BundleProduct.BundleID
- ProductID (ProductID2) — INT — Foreign key → BundleProduct.ProductID
- Quantity — INT
- Price — DECIMAL(10, 2)
- AccessoryID — INT — Foreign key → Accessory.AccessoryID
- TicketID — INT — Foreign key → FlightTicket.TicketID
- PartnerID — INT — Foreign key → PartnerProduct.PartnerID
- AddOnID — INT — Foreign key → AddOnService.AddOnID
- ProductID — INT — Foreign key → PartnerProduct.ProductID
- ProductID (ProductID3) — INT — Foreign key → Accessory.ProductID
- ProductID (ProductID4) — INT — Foreign key → FlightTicket.ProductID
- ProductID (ProductID5) — INT — Foreign key → AddOnService.ProductID
FlightTicket
- TicketID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- FlightNumber — VARCHAR(10)
- DepartureCity — VARCHAR(100)
- ArrivalCity — VARCHAR(100)
- FlightSchedule — DATE
- Leg — VARCHAR(100)
- Segment — VARCHAR(100)
PartnerProduct
- PartnerID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- PartnerType — VARCHAR(100)
- PartnerName — VARCHAR(255)
- Price — DECIMAL(10, 2)
- Description — TEXT
Product
- ProductID — INT — Primary key
- ProductName — VARCHAR(255) — NOT NULL
- ProductType — VARCHAR(50) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
- Description — TEXT
- CreatedAt — TIMESTAMP
- UpdatedAt — TIMESTAMP