Mexico Toy Sales
Sales & inventory data for a fictitious chain of toy stores in Mexico.
@kaggle.mysarahmadbhat_toy_sales
Sales & inventory data for a fictitious chain of toy stores in Mexico.
@kaggle.mysarahmadbhat_toy_sales
CREATE TABLE inventory (
"store_id" BIGINT,
"product_id" BIGINT,
"stock_on_hand" BIGINT
);
CREATE TABLE products (
"product_id" BIGINT,
"product_name" VARCHAR,
"product_category" VARCHAR,
"product_cost" VARCHAR,
"product_price" VARCHAR
);
CREATE TABLE sales (
"sale_id" BIGINT,
"date" TIMESTAMP,
"store_id" BIGINT,
"product_id" BIGINT,
"units" BIGINT
);
CREATE TABLE stores (
"store_id" BIGINT,
"store_name" VARCHAR,
"store_city" VARCHAR,
"store_location" VARCHAR,
"store_open_date" TIMESTAMP
);
Anyone who has the link will be able to view this.