n1A3SvCV

1customers_table_query = """CREATE TABLE IF NOT EXISTS customers(
2                        customer_id INTEGER PRIMARY KEY,
3                        first_name TEXT,
4                        last_name TEXT,
5                        date_created TEXT)"""
6
7db_query(customers_table_query)
8
9product_table_query = """CREATE TABLE IF NOT EXISTS product(
10                        product_id INTEGER PRIMARY KEY,
11                        product_name TEXT,
12                        price INTEGER,
13                        date_created TEXT)"""
14db_query(product_table_query)
15
16order_table_query = """CREATE TABLE IF NOT EXISTS order(
17                        order_id INTEGER PRIMARY KEY,
18                        customer_id INTEGER,
19                        FOREIGN KEY(customer_id) REFERENCES customers(customer_id),
20                        product_id INTEGER,
21                        FOREIGN KEY(product_id) REFERENCES product(product_id))"""
22db_query(order_table_query)