a
Tables (8)
Brand (Untitled3)
- id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key → Product.id — NOT NULL
- name (Field)
Cart (Untitled5)
- id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- product_id (Key2) — Foreign key → Product.id — NOT NULL
- Field
- Field2
Category (Untitled7)
- categoryid (Key) — Primary key — NOT NULL
- Field
Order (Untitled6)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- product_id (Key3) — Foreign key → Product.id — NOT NULL
- address (Field2)
- delivery (Field3)
Product (Untitled2)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- category_id (Key3) — Foreign key → Category.categoryid — NOT NULL
- name (Field)
- price (Field2)
- category (Field3)
- description (Field7)
ProductOption (Untitled8)
- product_id (Key) — Foreign key → Product.id — NOT NULL
- color (Field)
- size (Field2)
- stock (Field3)
Review (Untitled4)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- id (Key3) — Foreign key → Product.id — NOT NULL
- star (Field3)
- comment (Field4)
User (Untitled)
- id (Key) — Primary key — NOT NULL
- user_id (Field)
- email (Field2)
- password (Field3)
- nickname (Field4)
- phone_number (Field5)
- gender (Field6)
- is_admin (Field7)