미션11

테이블 (8)

Customer (Untitled2)

  • customer_id (Key) — 기본 키 — NOT NULL
  • customer_unique_id (Key2) — 기본 키 — NOT NULL
  • customer_zip_code_prefix (Field)
  • customer_city (Field2)
  • customer_state (Field3)

Order_item (Untitled3)

  • order_item_id (Field) — 기본 키
  • order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
  • seller_id (Key) — 외래 키 → Seller.seller_id — NOT NULL
  • product_id (Key3) — 외래 키 → Products.product_id — NOT NULL
  • shipping_llimit_date (Field4)
  • Price (Field5)
  • freight_value (Field6)

Order_review (Untitled5)

  • review_id (Key) — 기본 키 — NOT NULL
  • order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
  • review_score (Field2)
  • review_comment_title (Field3)
  • review_comment_message (Field4)
  • review_creation_date (Field5)
  • review_answer_timestamp (Field6)

Orders (Untitled)

  • order_id (Key) — 기본 키 — NOT NULL
  • customer_id (Key2) — 외래 키 → Customer.customer_id — NOT NULL
  • order_status (Field2)
  • order_purchase_timestamp (Field3)
  • order_approved_at (Field4)
  • order_delivered_carrier_date (Field5)
  • order_delivered_customer_date (Field6)
  • order_estimeated_delivery_date (Field7)

Payments (Untitled4)

  • order_id (Key) — 외래 키 → Orders.order_id — NOT NULL
  • payment_sequential (Field)
  • Payment_type (Field2)
  • payment_installments (Field3)
  • payment_value (Field4)

Product_category_trans (Untitled8)

  • product_category_name (Field3) — 외래 키 → Products.product_category_name
  • Product_category_name_english (Field2)

Products (Untitled6)

  • product_id (Key) — 기본 키 — NOT NULL
  • product_category_name (Field) — 기본 키
  • product_name_lenght (Field2)
  • product_description_lenght (Field3)
  • product_photos_qly (Field4)
  • product_weight_g (Field5)
  • product_length_cm (Field6)
  • product_height_cm (Field7)
  • product_width_cm (Field8)

Seller (Untitled7)

  • seller_id (Key) — 기본 키 — NOT NULL
  • seller_zip_code_prefix (Field)
  • seller_city (Field2)
  • seller_state (Field3)