e-ticket

Tables (5)

eticket_inventory

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • status — ENUM('AVAILABLE', 'ISSUED', 'USED', 'EXPIRED')
  • issued_at — DATETIME
  • used_at — DATETIME
  • expires_at — DATETIME

eticket_issued

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • inventory_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • receiver_name — VARCHAR(50)
  • receiver_contact — VARCHAR(100)
  • message — TEXT
  • status — ENUM('ISSUED', 'USED', 'EXPIRED', 'REFUNDED')
  • used_at — DATETIME
  • sent_at — DATETIME

eticket_log

  • id — BIGINT
  • issued_id — BIGINT — NOT NULL
  • event_type — ENUM('SEND_SUCCESS', 'SEND_FAIL', 'USED', 'EXPIRED', 'REFUND_REQUEST', 'SYSTEM_ERROR')
  • message — TEXT
  • created_at — DATETIME

eticket_order

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • total_price — DECIMAL(10,2)
  • status — ENUM('REQUESTED', 'ISSUED', 'CANCELLED', 'REFUNDED')
  • requested_at — DATETIME
  • issued_at — DATETIME

eticket_product

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • brand — VARCHAR(100)
  • price — DECIMAL(10,2) — NOT NULL
  • valid_days — INT — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE')
  • created_at — DATETIME
  • updated_at — DATETIME