Brazilian E-Commerce Public Dataset

Tables (9)

Untitled (olist_customers_dataset)

  • Key (customer_id) — STR — Primary key — NOT NULL
  • Key (customer_unique_id) — STR — Primary key — NOT NULL
  • Field (customer_zip_code_prefix) — INT — NOT NULL
  • Field2 (customer_city) — STR — NOT NULL
  • Field (customer_state) — STR — NOT NULL

Untitled (olist_geolocation_dataset)

  • Field (geolocation_zip_code_prefix) — INT — NOT NULL
  • Field (geolocation_lat) — INT — NOT NULL
  • Field (geolocation_lng) — INT — NOT NULL
  • Field2 (geolocation_city) — STR — NOT NULL
  • Field3 (geolocation_state) — STR — NOT NULL

Untitled (olist_order_items_dataset)

  • Key (order_item_id) — STR — Primary key — NOT NULL
  • Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Key (seller_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Field (shipping_limit_date) — DATE — NOT NULL
  • Field2 (price) — INT — NOT NULL
  • Field3 (freight_value) — INT — NOT NULL

Untitled (olist_order_payments_dataset)

  • Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Field (payment_sequential) — INT — NOT NULL
  • Field (payment_type) — STR — NOT NULL
  • Field (payment_installments) — INT — NOT NULL
  • Field (payment_value) — INT — NOT NULL

Untitled (olist_order_reviews_dataset)

  • Key2 (review_id) — STR — Primary key — NOT NULL
  • Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Field5 (review_score) — INT — NOT NULL
  • Field (review_comment_title) — STR
  • Field2 (review_comment_message) — STR
  • Field3 (review_creation_date) — DATE — NOT NULL
  • Field4 (review_answer_timestamp) — DATE — NOT NULL

Untitled (olist_orders_dataset)

  • Key (order_id) — STR — Primary key — NOT NULL
  • Key (customer_id) — STR — Foreign key → Untitled.Key — NOT NULL
  • Field (order_status) — STR — NOT NULL
  • Field2 (order_purchase_timestamp) — DATE — NOT NULL
  • Field3 (order_approved_at) — DATE — NOT NULL
  • Field4 (order_delivered_carrier_date) — DATE
  • Field5 (order_delivered_customer_date) — DATE
  • Field6 (order_estimated_delivery_date) — DATE — NOT NULL

Untitled (olist_products_dataset)

  • Key (product_id) — STR — Primary key — NOT NULL
  • Field (product_category_name) — STR
  • Field2 (product_name_lenght) — INT
  • Field3 (product_description_lenght) — INT
  • Field4 (product_photos_qty) — INT
  • Field5 (product_weight_g) — INT — NOT NULL
  • Field (product_length_cm) — INT — NOT NULL
  • Field6 (product_height_cm) — INT — NOT NULL
  • Field7 (product_width_cm) — INT — NOT NULL

Untitled (olist_sellers_dataset)

  • Key (seller_id) — STR — Primary key — NOT NULL
  • Field (seller_zip_code_prefix) — INT — NOT NULL
  • Field2 (seller_city) — STR — NOT NULL
  • Field3 (seller_state) — STR — NOT NULL

Untitled (product_category_name_translation)

  • Field (product_category_name) — NOT NULL
  • Field2 (product_category_name_english) — NOT NULL