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