-- Novus Examples — sample e-commerce database (SQLite/PostgreSQL compatible)
CREATE TABLE products (
  product_id INTEGER PRIMARY KEY, sku TEXT, name TEXT,
  category TEXT, price REAL, stock INTEGER, rating REAL
);
CREATE TABLE customers (
  customer_id INTEGER PRIMARY KEY, name TEXT, email TEXT,
  city TEXT, country TEXT, signup_date DATE
);
CREATE TABLE orders (
  order_id INTEGER PRIMARY KEY, customer_id INTEGER, product_id INTEGER,
  quantity INTEGER, total REAL, status TEXT, order_date DATE,
  FOREIGN KEY (customer_id) REFERENCES customers(customer_id),
  FOREIGN KEY (product_id) REFERENCES products(product_id)
);

-- Sample rows (first 25 of each table; full data in the CSV/JSON/Parquet twins)
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (1, 'SKU-00001', 'Wireless Coffee Beans', 'Home & Kitchen', 222.23, 216, 4.4);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (2, 'SKU-00002', 'Deluxe Notebook', 'Books', 487.92, 47, 4.5);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (3, 'SKU-00003', 'Classic Coffee Beans', 'Clothing', 68.41, 419, 3.7);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (4, 'SKU-00004', 'Ergonomic Blender', 'Sports', 323.7, 463, 4.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (5, 'SKU-00005', 'Stainless Yoga Mat', 'Toys', 117.47, 46, 3.1);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (6, 'SKU-00006', 'Stainless Desk Lamp', 'Beauty', 317.66, 413, 4.5);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (7, 'SKU-00007', 'Classic T-Shirt', 'Grocery', 485.49, 222, 4.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (8, 'SKU-00008', 'Deluxe Coffee Beans', 'Electronics', 236.02, 97, 3.1);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (9, 'SKU-00009', 'Stainless Blender', 'Home & Kitchen', 343.1, 461, 4.9);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (10, 'SKU-00010', 'Classic Yoga Mat', 'Books', 188.37, 162, 3.9);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (11, 'SKU-00011', 'Classic Blender', 'Clothing', 69.3, 343, 3.5);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (12, 'SKU-00012', 'Ergonomic Building Blocks', 'Sports', 221.38, 334, 4.7);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (13, 'SKU-00013', 'Portable Coffee Beans', 'Toys', 159.61, 383, 4.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (14, 'SKU-00014', 'Deluxe Desk Lamp', 'Beauty', 147.71, 193, 4.4);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (15, 'SKU-00015', 'Portable Blender', 'Grocery', 103.94, 402, 4.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (16, 'SKU-00016', 'Wireless Coffee Beans', 'Electronics', 354.05, 332, 4.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (17, 'SKU-00017', 'Stainless Yoga Mat', 'Home & Kitchen', 286.52, 18, 3.2);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (18, 'SKU-00018', 'Organic Yoga Mat', 'Books', 238.18, 334, 4.1);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (19, 'SKU-00019', 'Wireless Coffee Beans', 'Clothing', 319.18, 282, 4.1);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (20, 'SKU-00020', 'Stainless Coffee Beans', 'Sports', 20.24, 151, 3.9);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (21, 'SKU-00021', 'Eco Notebook', 'Toys', 207.21, 496, 3.5);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (22, 'SKU-00022', 'Deluxe Desk Lamp', 'Beauty', 144.28, 29, 3.6);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (23, 'SKU-00023', 'Ergonomic Face Cream', 'Grocery', 280.72, 252, 4.3);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (24, 'SKU-00024', 'Classic Yoga Mat', 'Electronics', 407.93, 203, 3.3);
INSERT INTO products (product_id, sku, name, category, price, stock, rating) VALUES (25, 'SKU-00025', 'Compact Headphones', 'Home & Kitchen', 49.56, 385, 3.9);
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (1, 'Edward Smith', 'reyespatricia@example.org', 'North Josephhaven', 'CU', '2024-02-16');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (2, 'Ryan Rogers', 'michael85@example.net', 'Lake Michelleberg', 'BH', '2023-10-25');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (3, 'Maria Brooks', 'michele55@example.com', 'South Katherinefurt', 'GQ', '2024-10-31');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (4, 'Paul Smith', 'fcummings@example.net', 'North Grace', 'CO', '2023-02-20');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (5, 'Casey Miller', 'peter28@example.org', 'Weaverfurt', 'BY', '2024-06-09');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (6, 'William Ewing', 'moorewilliam@example.net', 'Webbmouth', 'FJ', '2025-01-02');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (7, 'John Parker', 'hensonsara@example.org', 'Ashleymouth', 'NZ', '2025-12-17');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (8, 'Curtis Leon', 'collierlawrence@example.org', 'Juarezport', 'GM', '2025-03-10');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (9, 'Connie Roberts', 'robert67@example.com', 'Johnsonchester', 'MU', '2025-06-08');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (10, 'Alexis Roberts', 'martinandrew@example.net', 'Michaelfurt', 'PT', '2025-06-13');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (11, 'Anthony Nelson', 'jordanjohn@example.com', 'Loritown', 'TR', '2023-11-06');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (12, 'Cory Davis', 'trujillobill@example.net', 'Williamshaven', 'GW', '2024-06-08');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (13, 'Ricky Montoya', 'garciakevin@example.net', 'Smithfort', 'PY', '2025-04-23');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (14, 'Stephanie Stuart', 'meganosborn@example.com', 'Rodriguezbury', 'PE', '2025-09-14');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (15, 'Shelby Smith', 'wharris@example.org', 'Christopherfort', 'AR', '2025-01-01');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (16, 'Heather Reid', 'christophergreene@example.com', 'Whitakerville', 'LT', '2024-11-29');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (17, 'Lisa Huynh', 'michael90@example.com', 'Bonnietown', 'IN', '2024-11-19');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (18, 'James Soto', 'brittanyreeves@example.com', 'South Christinaborough', 'MW', '2025-06-18');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (19, 'Miranda Holmes', 'smithdaniel@example.org', 'East Kevin', 'MT', '2025-01-10');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (20, 'Jennifer Spencer', 'craig72@example.org', 'Nicolefurt', 'BH', '2024-05-01');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (21, 'Casey Davis', 'ymorris@example.net', 'Sarafort', 'CL', '2024-03-19');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (22, 'Mary Gray', 'ogriffin@example.net', 'East Jennifer', 'YE', '2025-11-01');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (23, 'Jessica Elliott MD', 'robert30@example.net', 'Port Amyburgh', 'CI', '2023-06-21');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (24, 'Thomas Prince', 'floresamy@example.net', 'Mcdonaldview', 'NL', '2023-04-24');
INSERT INTO customers (customer_id, name, email, city, country, signup_date) VALUES (25, 'Russell Ellison', 'amber39@example.net', 'East Ericaberg', 'CV', '2023-08-16');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (1, 150, 171, 2, 705.98, 'paid', '2025-10-19');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (2, 174, 36, 1, 25.59, 'refunded', '2025-06-09');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (3, 31, 1, 2, 444.46, 'shipped', '2025-04-27');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (4, 293, 51, 4, 881.44, 'delivered', '2025-08-22');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (5, 431, 127, 3, 1105.89, 'shipped', '2025-03-12');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (6, 295, 190, 5, 234.85, 'delivered', '2025-05-03');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (7, 336, 52, 5, 2229.65, 'refunded', '2025-05-26');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (8, 236, 54, 4, 207.0, 'pending', '2025-04-29');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (9, 160, 35, 3, 882.36, 'pending', '2025-05-20');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (10, 160, 86, 4, 1292.08, 'refunded', '2025-04-28');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (11, 468, 156, 3, 225.24, 'shipped', '2025-12-26');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (12, 470, 28, 1, 184.09, 'refunded', '2025-02-19');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (13, 147, 148, 1, 160.37, 'pending', '2025-01-24');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (14, 287, 11, 2, 138.6, 'pending', '2025-03-27');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (15, 132, 197, 3, 1439.4, 'shipped', '2025-05-22');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (16, 24, 159, 2, 54.18, 'pending', '2025-12-06');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (17, 318, 171, 1, 352.99, 'paid', '2025-06-19');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (18, 449, 156, 1, 75.08, 'delivered', '2025-05-06');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (19, 489, 90, 2, 373.82, 'paid', '2025-03-28');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (20, 116, 99, 2, 784.78, 'shipped', '2025-12-25');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (21, 145, 31, 1, 227.42, 'pending', '2025-05-25');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (22, 82, 83, 5, 1321.25, 'pending', '2025-01-08');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (23, 138, 23, 3, 842.16, 'shipped', '2025-12-13');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (24, 206, 6, 2, 635.32, 'shipped', '2025-11-28');
INSERT INTO orders (order_id, customer_id, product_id, quantity, total, status, order_date) VALUES (25, 234, 111, 4, 1441.12, 'refunded', '2025-09-01');
