ecommerce-modular-app

Tables (6)

Category (Untitled3)

  • category_id (Key) — Primary key — NOT NULL
  • name (Field)

Member (Untitled)

  • member_id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String

Order (Untitled4)

  • order_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • total_price (Field)
  • status (Field2)

OrderITem (Untitled5)

  • order_item_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → Order.order_id — NOT NULL
  • quantity (Field) — int
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL

Product (Untitled2)

  • product_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • category_id (Key2) — Foreign key → Category.category_id — NOT NULL

Review (Untitled6)

  • review_id (Key) — Primary key — NOT NULL
  • content (Field)
  • rateing (Field2) — int
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL