f-mart

Tables (6)

Cart (Untitled3)

  • id — int — Primary key — NOT NULL
  • id (id3) — int — Foreign key → User.id — NOT NULL
  • productId — int
  • quantity — int
  • id (id2) — int — Foreign key → Product.id — NOT NULL
  • storeid — int — Foreign key → Product.storeid — NOT NULL
  • categoryid — int — Foreign key → Product.categoryid — NOT NULL

Order (Untitled6)

  • orderid (orderId) — int — Primary key — NOT NULL
  • id — int — Foreign key → User.id — NOT NULL
  • id (id2) — int — Foreign key → Product.id — NOT NULL
  • storeid — int — Foreign key → Product.storeid — NOT NULL
  • categoryid — int — Foreign key → Product.categoryid — NOT NULL
  • id (id3) — int — Foreign key → Cart.id — NOT NULL
  • createdAt (createAt) — timestamp
  • quantity — int
  • address — varchar2

Product (Untitled2)

  • id — int — Primary key — NOT NULL
  • storeid — int — Foreign key → Store.storeid — NOT NULL
  • categoryid — int — Foreign key → category.categoryid — NOT NULL
  • name — varchar2
  • weight — varchar2
  • price — int
  • quantity — int
  • thumbnail — varchar2
  • descriptionURL — varchar2

Store (Untitled4)

  • storeid — int — Primary key — NOT NULL
  • name — varchar2

User (Untitled)

  • id — int — Primary key — NOT NULL
  • email — varchar2
  • password — varchar2
  • address — varchar2

category (Untitled5)

  • categoryid — int — Primary key — NOT NULL
  • name — varchar2
  • Field