Constraint – Foreign Key – One To One

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