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)