practice
Tables (4)
order (Untitled3)
- order_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
- user_id (Field) — INT
- order_date (Field2) — INT
- total_price (Field3) — INT
- product_name (Field4) — VARCHAR
order_item (Untitled4)
- order_item (Key) — VARCHAR — Primary key — NOT NULL
- order_id (Key2) — INT — Foreign key → order.order_id — NOT NULL
- user_id (Key22) — INT — Foreign key → order.user_id — NOT NULL
- product_id (Key3) — INT — Foreign key → product.product_id — NOT NULL
- quantity (Field) — INT
- Field2
product (Untitled2)
- product_id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- price (Field2) — INT
- stock (Field3) — INT
- description (Field4) — VARCHAR
user (Untitled)
- user_id (Key) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
- join_at (Field4) — VARCHAR