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