Query

billing.db — monthly_summary

+/- table definition

Query 

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)
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop