---

CREATE TABLE Clients (
    client_id INT PRIMARY KEY AUTO_INCREMENT,
    company_name VARCHAR(100) NOT NULL,
    contact_person VARCHAR(100),
    phone VARCHAR(20)
);

CREATE TABLE Orders (
    order_id INT PRIMARY KEY AUTO_INCREMENT,
    client_id INT,
    title VARCHAR(150) NOT NULL,
    product_desc TEXT,
    budget DECIMAL(15,2),
    target_audience VARCHAR(255),
    start_date DATE,
    deadline DATE,
    FOREIGN KEY (client_id) REFERENCES Clients(client_id)
);

CREATE TABLE Channels (
    channel_id INT PRIMARY KEY AUTO_INCREMENT,
    channel_name VARCHAR(50) NOT NULL
);

CREATE TABLE Order_Channels (
    order_id INT,
    channel_id INT,
    PRIMARY KEY (order_id, channel_id),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id),
    FOREIGN KEY (channel_id) REFERENCES Channels(channel_id)
);

CREATE TABLE Finance (
    transaction_id INT PRIMARY KEY AUTO_INCREMENT,
    order_id INT,
    type ENUM('income', 'expense'),
    amount DECIMAL(15,2),
    description VARCHAR(255),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id)
);