---

CREATE TABLE suppliers(
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255)
);

CREATE TABLE manufacturers(
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255)
);

CREATE TABLE categories(
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255)
);

CREATE TABLE products(
    id INT PRIMARY KEY AUTO_INCREMENT,
    article VARCHAR(255),
    name VARCHAR(255),
    unit VARCHAR(255),
    price DECIMAL(5,2),
    supplier_id INT,
    manufacturer_id INT,
    category_id INT,
    discount INT,
    count INT,
    description VARCHAR(255),
    photo VARCHAR(255),

    FOREIGN KEY (supplier_id) REFERENCES suppliers(id),
    FOREIGN KEY (manufacturer_id) REFERENCES manufacturers(id),
    FOREIGN KEY (category_id) REFERENCES categories(id)
);

CREATE TABLE users(
    id INT PRIMARY KEY AUTO_INCREMENT,
    role VARCHAR(255),
    first_name VARCHAR(255),
    second_name VARCHAR(255),
    login VARCHAR(255),
    password VARCHAR(255)
);

CREATE TABLE points(
    id INT PRIMARY KEY AUTO_INCREMENT,
    adress VARCHAR(255)
);

CREATE TABLE orders(
    id INT PRIMARY KEY AUTO_INCREMENT,
    product_id INT,
    count INT,
    order_date DATE,
    delivery_date DATE,
    point_id INT,
    user_id INT,
    get_code INT,
    status VARCHAR(255),

    FOREIGN KEY (product_id) REFERENCES products(id),
    FOREIGN KEY (point_id) REFERENCES points(id),
    FOREIGN KEY (user_id) REFERENCES users(id)
)