CREATE VERTEX User (PRIMARY_ID id STRING, age INT, gender STRING) WITH primary_id_as_attribute="true";
CREATE VERTEX Item (PRIMARY_ID id STRING, name STRING, category STRING) WITH primary_id_as_attribute="true";
CREATE EDGE Purchase (FROM User, TO Item, purchase_date DATETIME, price DOUBLE);
CREATE EDGE Rate (FROM User, TO Item, rating DOUBLE, comment STRING);
CREATE EDGE View (FROM User, TO Item, view_date DATETIME);
CREATE VERTEX User (PRIMARY_ID id STRING, username STRING) WITH primary_id_as_attribute="true";
CREATE VERTEX Order (PRIMARY_ID id STRING, total_amount DOUBLE, payment_method STRING) WITH primary_id_as_attribute="true";
CREATE EDGE Make (FROM User, TO Order, make_date DATETIME);
CREATE EDGE Pay (FROM User, TO Order, payment_date DATETIME);
CREATE EDGE Refund (FROM User, TO Order, refund_date DATETIME);
CREATE EDGE Return (FROM User, TO Order, return_date DATETIME);
CREATE VERTEX Supplier (PRIMARY_ID id STRING, name STRING) WITH primary_id_as_attribute="true";
CREATE VERTEX Product (PRIMARY_ID id STRING, name STRING) WITH primary_id_as_attribute="true";
CREATE EDGE Supply (FROM Supplier, TO Product, supply_date DATETIME, price DOUBLE);
CREATE EDGE Purchase (FROM Product, TO Supplier, purchase_date DATETIME, quantity INT);