Constraint – Foreign Key – One To Many

/* Create Table orders*/
CREATE TABLE orders (
    order_id INT NOT NULL,
    price varchar(255),
    client_id INT,
    PRIMARY KEY(order_id),
    FOREIGN KEY(client_id) REFERENCES clients(id)
) ENGINE = INNODB;

/* Create Table comments*/
CREATE TABLE comments (
    c_id INT NOT NULL,
    comment varchar(255),
    client_id INT,
    PRIMARY KEY(c_id),
    FOREIGN KEY(client_id) REFERENCES clients(id)
) ENGINE = INNODB;