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)