e-commerce data

테이블 (9)

결제방식 (order_payments)

  • Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
  • Field2 (payment_sequential) — long
  • Field3 (payment_type) — string
  • Field4 (payment_installments) — long
  • Field5 (payment_value) — double

리뷰 (order_reviews)

  • Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
  • Field (review_id) — string
  • Field3 (review_score) — long
  • Field4 (review_creation_date) — string
  • Field5 (review_answer_timestamp) — string

소비자 (customer)

  • Key (customer_id) — long — 기본 키 — NOT NULL
  • Key (geolocation_zip_code_prefix) — string — 외래 키 → 지역.Key — NOT NULL
  • Field2 (customer_unique_id) — string
  • Field3 (customer_zip_code_prefix) — string
  • Field (customer_city) — string
  • Field3 (customer_state) — string

제품 (products)

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

주문 (orders)

  • Key (order_id) — long — 기본 키 — NOT NULL
  • Key (customer_id2) — long — 외래 키 → 소비자.Key — NOT NULL
  • Field2 (customer_id) — string
  • Field3 (order_status) — string
  • Field4 (order_purchase_timestamp) — string
  • Field5 (order_approved_at) — string
  • Field6 (order_delivered_carrier_date) — string
  • Field7 (order_delivered_customer_date) — string
  • Field8 (order_estimated_delivery_date) — string

주문_제품 (order_items)

  • Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
  • Key (product_id) — string — 외래 키 → 제품.Key — NOT NULL
  • Key (seller_id) — string — 외래 키 → 판매자.Key — NOT NULL
  • Field2 (order_item_id) — long
  • Field5 (shipping_limit_date) — string
  • Field6 (price) — double
  • Field7 (freight_value) — double

지역 (geolocation)

  • Key (geolocation_zip_code_prefix) — string — 기본 키 — NOT NULL
  • Field2 (geolocation_lat) — double
  • Field3 (geolocation_lng) — double
  • Field4 (geolocation_city) — string
  • Field5 (geolocation_state) — string

카테고리 이름 (product_category_name)

  • Field (product_category_name) — string
  • Field2 (product_category_name_english) — string

판매자 (sellers)

  • Key (seller_id) — string — 기본 키 — NOT NULL
  • Key (geolocation_zip_code_prefix) — string — 외래 키 → 지역.Key — NOT NULL
  • Field2 (seller_zip_code_prefix) — long
  • Field3 (seller_city) — string
  • Field4 (seller_state) — string