Ticket-Express

Tables (5)

Find Card (Untitled5)

  • Card Name (card_name) — VARCHAR(255) — Primary key — NOT NULL
  • Promotino ID (p_id) — VARCHAR(255) — Foreign key → Promotion.Promotino ID — NOT NULL
  • Card Company (card_company) — VARCHAR(255)

Promotion (Untitled)

  • Promotino ID (p_id) — VARCHAR(255) — Primary key — NOT NULL
  • Promotion Price (p_price) — INT
  • Promotion Rate (p_rate) — FLOAT
  • Promotion Adult (p_adt) — INT
  • Promotion Child (p_child) — INT

Promotion_D (Untitled2)

  • Promotion Detail (d_id) — VARCHAR(255) — Primary key — NOT NULL
  • Promotino ID (p_id) — VARCHAR(255) — Foreign key → Promotion.Promotino ID — NOT NULL
  • Regular ID (r_id) — VARCHAR(255) — Foreign key → Regular_Price.Regular ID — NOT NULL
  • Season Date (season_date) — DATE — Foreign key → Season.Season Date — NOT NULL
  • Promotion Name (p_name) — VARCHAR(255)
  • Sell Type (sell_type) — VARCHAR(255)

Regular_Price (Untitled4)

  • Regular ID (r_id) — VARCHAR(255) — Primary key — NOT NULL
  • Regular Price (r_price) — INT
  • Season Name (season_name) — VARCHAR(255)
  • Time (r_time) — VARCHAR(255)

Season (Untitled3)

  • Season Date (season_date) — DATE — Primary key — NOT NULL
  • Season Name (season_name) — VARCHAR(255)