Spaces:

shubh7
/

RetailGenie

Runtime error

RetailGenie / data /retail_schema.sql

Adding application file

5f946b0 over 1 year ago

572 Bytes

-- Table: transactions
CREATE TABLE transactions (
    transaction_id INT PRIMARY KEY,
    product_id INT,
    product_name VARCHAR(100),
    category VARCHAR(50),
    quantity INT,
    total_price DECIMAL(10, 2),
    store_id INT,
    date DATE
);

-- Table: returns
CREATE TABLE returns (
    return_id INT PRIMARY KEY,
    product_id INT,
    product_name VARCHAR(100),
    category VARCHAR(50),
    store_id INT,
    date DATE
);

-- Table: monthly_sales
CREATE TABLE monthly_sales (
    product_id INT,
    product_name VARCHAR(100),
    month INT,
    sales INT
);


	-- Table: transactions
	CREATE TABLE transactions (
	transaction_id INT PRIMARY KEY,
	product_id INT,
	product_name VARCHAR(100),
	category VARCHAR(50),
	quantity INT,
	total_price DECIMAL(10, 2),
	store_id INT,
	date DATE
	);

	-- Table: returns
	CREATE TABLE returns (
	return_id INT PRIMARY KEY,
	product_id INT,
	product_name VARCHAR(100),
	category VARCHAR(50),
	store_id INT,
	date DATE
	);

	-- Table: monthly_sales
	CREATE TABLE monthly_sales (
	product_id INT,
	product_name VARCHAR(100),
	month INT,
	sales INT
	);