Axe Mart ERP

SQLite format 3@ .WJ ��q+5)1%Axe Mart36BCBPA5537J1ZRTelangana36Hyderabad, Telangana+91 7799711514contact@axemart.inAXE-AxeMart@2026 3e;=� � "��e�U%%�mtablereturn_itemsreturn_items CREATE TABLE return_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_id INTEGER NOT NULL, order_item_id INTEGER NOT NULL, product_id INTEGER NOT NULL, quantity INTEGER NOT NULL, refund_amount REAL NOT NULL, FOREIGN KEY(return_id) REFERENCES returns(id) ON DELETE CASCADE )�P �wtablereturnsreturnsCREATE TABLE returns ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_no TEXT UNIQUE NOT NULL, order_id INTEGER NOT NULL, marketplace_order_id TEXT, return_date DATE NOT NULL, return_reason TEXT NOT NULL, restock_inventory INTEGER DEFAULT 1, total_refund REAL DEFAULT 0.0, notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY(order_id) REFERENCES orders(id) ON DELETE CASCADE )-Aindexsqlite_autoindex_returns_1returns�) ##�tableorder_itemsorder_items CREATE TABLE order_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, order_id INTEGER NOT NULL, product_id INTEGER NOT NULL, product_name TEXT NOT NULL, hsn_code TEXT NOT NULL, quantity INTEGER NOT NULL, unit_price REAL NOT NULL, gst_rate REAL NOT NULL, tax_amount REAL NOT NULL, total_price REAL NOT NULL, returned_qty INTEGER DEFAULT 0, FOREIGN KEY(order_id) REFERENCES orders(id) ON DELETE CASCADE, FOREIGN KEY(product_id) REFERENCES products(id) ON DELETE RESTRICT )��itableordersordersCREATE TABLE orders ( id INTEGER PRIMARY KEY AUTOINCREMENT, invoice_no TEXT UNIQUE NOT NULL, channel TEXT NOT NULL, marketplace_order_id TEXT, marketplace_invoice_no TEXT, courier_awb TEXT, customer_name TEXT DEFAULT 'Walk-in Customer', customer_phone TEXT, customer_state TEXT DEFAULT 'Telangana', payment_method TEXT DEFAULT 'Cash', payment_status TEXT DEFAULT 'Paid', subtotal REAL DEFAULT 0.0, tax_amount REAL DEFAULT 0.0, cgst_amount REAL DEFAULT 0.0, sgst_amount REAL DEFAULT 0.0, igst_amount REAL DEFAULT 0.0, total_amount REAL DEFAULT 0.0, order_date DATE NOT NULL, status TEXT DEFAULT 'Completed', notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )+?indexsqlite_autoindex_orders_1orders �%%�wtableinward_itemsinward_itemsCREATE TABLE inward_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, inward_id INTEGER NOT NULL, product_id INTEGER NOT NULL, quantity INTEGER NOT NULL, unit_price REAL NOT NULL, total_price REAL NOT NULL, FOREIGN KEY(inward_id) REFERENCES inward_stock(id) ON DELETE CASCADE, FOREIGN KEY(product_id) REFERENCES products(id) ON DELETE RESTRICT )�)%%�tableinward_stockinward_stockCREATE TABLE inward_stock ( id INTEGER PRIMARY KEY AUTOINCREMENT, reference_no TEXT, supplier_name TEXT NOT NULL, invoice_date DATE NOT NULL, total_amount REAL DEFAULT 0.0, notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�B�WtableproductsproductsCREATE TABLE products ( id INTEGER PRIMARY KEY AUTOINCREMENT, sku TEXT UNIQUE NOT NULL, barcode TEXT, name TEXT NOT NULL, hsn_code TEXT NOT NULL, gst_rate REAL DEFAULT 18.0, purchase_price REAL DEFAULT 0.0, selling_price REAL DEFAULT 0.0, current_stock INTEGER DEFAULT 0, min_stock INTEGER DEFAULT 5, unit TEXT DEFAULT 'Nos', created_at DATETIME DEFAULT CURRENT_TIMESTAMP )/Cindexsqlite_autoindex_products_1products�B�WtablesettingssettingsCREATE TABLE settings ( id INTEGER PRIMARY KEY, company_name TEXT DEFAULT 'Axe Mart', gstin TEXT DEFAULT '', state TEXT DEFAULT 'Telangana', state_code TEXT DEFAULT '36', address TEXT DEFAULT 'Hyderabad, Telangana, India', phone TEXT DEFAULT '+91 9876543210', email TEXT DEFAULT 'contact@axemart.in', invoice_prefix TEXT DEFAULT 'AXE-', admin_password TEXT DEFAULT 'AxeMart@2026' )