db_final_exam
Tables (6)
Cart (Untitled2)
- user_id (int) — pk — Foreign key → User.id — NOT NULL
- product_id (Key) — pk — Foreign key → Product.id — NOT NULL
- quantity (Field)
- added_at (Field2)
Order (Untitled3)
- id (Key) — Primary key — NOT NULL
- user_id (int) — pk — Foreign key → User.id — NOT NULL
- total_amount (Field)
- payment_date (Field2)
- payment_method (Field3)
- recipient_name (Field4)
- shipping_address (Field5)
- shipping_phone (Field6)
- shipping_status (Field7)
- shipping_company (Field8)
- tracking_number (Field9)
- created_at (Field10)
OrderItem (Untitled4)
- order_id (Key3) — pk — Foreign key → Order.id — NOT NULL
- product_id (Key2) — pk — Foreign key → Product.id — NOT NULL
- quantity (Field)
Product (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- price (Field3)
- brand (Field4)
- category_id (Field5)
- stock_quantity (Field6)
- is_available (Field7)
- registered_at (Field8)
Review (Untitled5)
- product_id (Key) — pk — Foreign key → Product.id — NOT NULL
- user_id (int) — pk — Foreign key → User.id — NOT NULL
- rating (Field)
- comment (Field2)
- image_url (Field3)
User (사용자)
- id (int) — pk — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2)
- password_hash (Field3)
- phone (Field4)
- default_address (Field5)
- registered_at (Field6)