CREATE TABLE monthly_summary (
id INTEGER PRIMARY KEY AUTOINCREMENT,
year INTEGER NOT NULL,
month INTEGER NOT NULL,
total_customers INTEGER DEFAULT 0,
active_customers INTEGER DEFAULT 0,
monthly_invoices INTEGER DEFAULT 0,
voucher_invoices INTEGER DEFAULT 0,
paid_monthly_invoices INTEGER DEFAULT 0,
paid_voucher_invoices INTEGER DEFAULT 0,
unpaid_monthly_invoices INTEGER DEFAULT 0,
unpaid_voucher_invoices INTEGER DEFAULT 0,
monthly_revenue DECIMAL(15,2) DEFAULT 0,
voucher_revenue DECIMAL(15,2) DEFAULT 0,
monthly_unpaid DECIMAL(15,2) DEFAULT 0,
voucher_unpaid DECIMAL(15,2) DEFAULT 0,
total_revenue DECIMAL(15,2) DEFAULT 0,
total_unpaid DECIMAL(15,2) DEFAULT 0,
notes TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
UNIQUE(year, month)
)