MetaVerse
Tables (6)
Order (Untitled5)
- order_id (PK) — int — Primary key — NOT NULL
- customer(user_id) (Key) — VARCHAR(255) — Foreign key → User.user_id — NOT NULL
- product_id (FK) — VARCHAR(255) — Foreign key → Product.product_id — NOT NULL
- timestamp (Field) — timestamp
Owner (Untitled4)
- user_id (PK) — int — Foreign key → User.user_id — NOT NULL
- owner_info (Field) — VARCHAR(255)
Product (Untitled2)
- product_id (PK) — int — Primary key — NOT NULL
- product_name (Field) — VARCHAR(255)
- price (Field2) — int
- description (Field3) — VARCHAR(255)
- store_id (FK) — int — Foreign key → Store.store_id — NOT NULL
- Field4 — VARCHAR(255)
Store (Untitled)
- store_id (PK) — VARCHAR(255) — Primary key — NOT NULL
- store_name (Field) — VARCHAR(255)
- description (Field2) — VARCHAR(255)
- owner_id (FK) — int — Foreign key → Owner.user_id — NOT NULL
User
- user_id (Key) — int — Primary key — NOT NULL
- user_name (Field) — VARCHAR(255)
- email (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
- avatar (Field4) — VARCHAR(255)
customer (Untitled3)
- customer(user_id) (PK) — int — Foreign key → User.user_id — NOT NULL
- customer_info (Field) — VARCHAR(255)