Creating a foreign key table in mysql with references.

gistfile1.txt

-- Creating a table with foreign key references. 
create table user_order(
    id int not null PRIMARY key AUTO_INCREMENT,
    user_id int not null, 
    shipping_address_id int not null,
    order_date timestamp DEFAULT CURRENT_TIMESTAMP,
    total_quantity int not null, 
    total_price int not null,
    FOREIGN KEY (user_id) REFERENCES user(id),
    FOREIGN KEY (shipping_address_id) REFERENCES shipping_address(id)
    )