mydb
Tables (5)
Cart (Untitled3)
- cart_id (Key) — Primary key — NOT NULL
- User_id (Key2) — Foreign key → User.User_id — NOT NULL
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL
- quantity (Field)
Order (Untitled4)
- order_id (Key) — Primary key — NOT NULL
- total_price (Field)
- created_at (Field2)
- User_id (Key2) — Foreign key → User.User_id — NOT NULL
Product (Untitled2)
- product_id (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- stock (Field3)
User (Untitled)
- User_id (Key) — Primary key — NOT NULL
- login_id (Field)
- password (Field2)
order_item (Untitled5)
- order_item_id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → Order.order_id — NOT NULL
- product_id (Key3) — Foreign key → Product.product_id — NOT NULL
- quantity (Field)
- price (Field2)