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