ERD
Tables (12)
Cart (Untitled4)
- id (Key) — Primary key — NOT NULL
- product_count (Field)
- user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL
- product_id (Key2) — Foreign key → Product.id — NOT NULL
Discount (Untitled13)
- id (Key) — Primary key — NOT NULL
- value (Field)
- Field2
- product_id (Key2) — Foreign key → Product.id — NOT NULL
Display_Product (Untitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- main_image_url (Field3)
- created_at (Field4)
- updated_at (Field5)
Order (Untitled9)
- id (Key) — Primary key — NOT NULL
- receiver_name (Field)
- receiver_phone (Field2)
- recipient_address (Field3)
- order_status (Field4)
- created_at (Field5)
- delivered_at (Field6)
- user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL
Order_Product (Untitled8)
- id (Key) — Primary key — NOT NULL
- count (Field)
- order_id (Key2) — Foreign key → Product.id — NOT NULL
- product_id (Key3) — Foreign key → Order.id — NOT NULL
Payment (Untitled10)
- Key — Primary key — NOT NULL
- total_price (Field)
- discount_price (Field2)
- delivery_fee (Field3)
- final_price (Field4)
- created_at (Field5)
- payment_type_id (Key2) — Foreign key → Payment_Type.id — NOT NULL
- order_id (Key3) — Foreign key → Order.id — NOT NULL
Payment_Type (Untitled11)
- id (Key) — Primary key — NOT NULL
- name (Field)
Product (Untitled6)
- id (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- stock (Field3)
- status (Field4)
- display_product_id (Key2) — Foreign key → Display_Product.id — NOT NULL
Review (Untitled5)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
- created_at (Field3)
- user_id (Field4)
- Order_Product_id (Field5)
- user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL
- Order_Product_id (Key2) — Foreign key → Order_Product.id — NOT NULL
Review_Photo (Untitled)
- id (BIGINT UNSIGNED) — Primary key — NOT NULL
- photo_url (VARCHAR(100))
- review_id (Key) — Foreign key → Review.id — NOT NULL
Shipping_Address (Untitled3)
- id (BIGINT UNSIGNED) — Primary key — NOT NULL
- address (Field2)
- user_id (INT UNSIGNED2) — Foreign key → User.id — NOT NULL
User (Untitled2)
- id (INT UNSIGNED) — Primary key — NOT NULL
- login_id (VARCHAR(30))
- passward (VARCHAR(256))
- name (Field3)
- email (Field4)
- phone_number (VARCHAR(11))
- gender (ENUM)
- birth (DATE)