Условие:
Нарисуй мне диаграмму связей между следующими таблицами, с подписью один ко многим CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT UNIQUE,
email TEXT UNIQUE,
address TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS orders (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customerid INTEGER,
productid INTEGER,
date TEXT NOT NULL,
FOREIGN KEY (customerid) REFERENCES customers(id),
FOREIGN KEY (productid) REFERENCES products(id)
);
CREATE TABLE IF NOT EXISTS products (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT UNIQUE NOT NULL,
price TEXT NOT NULL,
stock INTEGER
);
CREATE TABLE IF NOT EXISTS suppliers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
productid INTEGER,
name TEXT NOT NULL,
phone INTEGER,
email TEXT UNIQUE,
FOREIGN KEY (productid) REFERENCES products(id)
);
CREATE TABLE IF NOT EXISTS shippings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
orderid INTEGER,
address TEXT NOT NULL,
data TEXT NOT NULL,
status TEXT NOT NULL,
FOREIGN KEY (orderid) REFERENCES orders(id)