

CREATE TABLE customers(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(200),
mobile VARCHAR(20),
gstn VARCHAR(20)
);

CREATE TABLE suppliers(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(200),
mobile VARCHAR(20),
gstn VARCHAR(20)
);

CREATE TABLE sales(
id INT AUTO_INCREMENT PRIMARY KEY,
invoice_no VARCHAR(50),
customer_id INT,
invoice_date DATE,
total_amount DECIMAL(10,2)
);
