Sql - foreign key example

    
    CREATE TABLE product(
        id INT PRIMARY KEY,
        customer_id INT NOT NULL,
        CONSTRAINT fk-product-customer_id
        FOREIGN KEY (customer_id)
        REFERENCES customer (id)
        ON UPDATE CASCADE
        ON DELETE CASCADE
    );
    

Comments