Create Table

--Cart Table 
CREATE TABLE cart(
    cart_id NUMBER NOT NULL, 
    user_id NUMBER NOT NULL, 
    product_id NUMBER NOT NULL, 
    amount NUMBER DEFAULT 0, 
    cart_date DATE DEFAULT sysdate, 
    purchase NUMBER(4,0), 
    money NUMBER, 
    PRIMARY KEY (cart_id), 
    CONSTRAINT cart_userid_fk FOREIGN KEY (user_id)
     REFERENCES member(user_id) , 
    CONSTRAINT cart_product_fk FOREIGN KEY (product_id)
     REFERENCES product(product_id) 
);
--Member Table
CREATE TABLE member (   
    user_id NUMBER primary key, 
    user_name VARCHAR2(50),
  user_name2 VARCHAR2(50),
    join_date DATE DEFAULT sysdate
);
--Product
CREATE TABLE product(
    product_id NUMBER, 
    product_name VARCHAR2(50) NOT NULL,
    PRIMARY KEY (product_id)
);