SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE customers( id INT (10) NOT NULL, name VARCHAR (50) NOT NULL, city VARCHAR (50) NOT NULL ); CREATE TABLE orders( cus_id INT (10) NOT NULL , order_date DATETIME NOT NULL ); CREATE TABLE products( id INT (5) NOT NULL, product_name VARCHAR(50) NOT NULL, product_price INT(10) NOT NULL ); CREATE TABLE ordered_items( id INT (10) NOT NULL, cus_id INT (10) NOT NULL, product_id INT(5) NOT NULL ); ALTER TABLE customers ADD CONSTRAINT customer_id PRIMARY KEY ( id ) ; ALTER TABLE orders ADD CONSTRAINT customers_id_fr FOREIGN KEY ( cus_id ) REFERENCES customers ( id ); ALTER TABLE ordered_items ADD CONSTRAINT ordered_items_fr FOREIGN KEY ( cus_id ) REFERENCES customers ( id );