CREATE TABLE voucher_purchases (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_name TEXT NOT NULL,
customer_phone TEXT NOT NULL,
amount INTEGER NOT NULL,
description TEXT,
type TEXT NOT NULL DEFAULT 'voucher',
voucher_package TEXT NOT NULL,
voucher_quantity INTEGER NOT NULL DEFAULT 1,
voucher_profile TEXT NOT NULL,
voucher_data TEXT,
-- JSON data untuk menyimpan detail voucher yang digenerate
status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'completed', 'failed', 'cancelled')),
payment_gateway TEXT,
payment_transaction_id TEXT,
payment_url TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
completed_at DATETIME,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
invoice_id TEXT,
FOREIGN KEY (payment_transaction_id) REFERENCES payment_gateway_transactions(id)
)