File size: 583 Bytes
981d8b1 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | CREATE TABLE customers (
customer_id INTEGER PRIMARY KEY,
name VARCHAR,
email VARCHAR,
country VARCHAR,
created_at DATE
);
CREATE TABLE products (
product_id INTEGER PRIMARY KEY,
name VARCHAR,
category VARCHAR,
price DECIMAL(10,2)
);
CREATE TABLE orders (
order_id INTEGER PRIMARY KEY,
customer_id INTEGER,
order_date DATE,
status VARCHAR
);
CREATE TABLE order_items (
order_item_id INTEGER PRIMARY KEY,
order_id INTEGER,
product_id INTEGER,
quantity INTEGER,
unit_price DECIMAL(10,2)
);
|