
CREATE TABLE brands (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100));
CREATE TABLE invoices (id INT AUTO_INCREMENT PRIMARY KEY, brand_id INT, invoice_number VARCHAR(50), customer_id INT, vat_enabled BOOLEAN, due_date DATE, status VARCHAR(50), created_at DATETIME);
CREATE TABLE invoice_items (id INT AUTO_INCREMENT PRIMARY KEY, invoice_id INT, description VARCHAR(255), quantity DECIMAL(10,2), unit_price DECIMAL(10,2));
CREATE TABLE subscriptions (id INT AUTO_INCREMENT PRIMARY KEY, brand_id INT, customer_id INT, amount DECIMAL(10,2), next_billing_date DATE);
CREATE TABLE bank_transactions (id INT AUTO_INCREMENT PRIMARY KEY, brand_id INT, amount DECIMAL(10,2), reference VARCHAR(255), matched BOOLEAN DEFAULT 0);
