Olist

Tables (5)

customer (Untitled)

  • customer_id — VARCHAR — Primary key — NOT NULL
  • customer_unique_id — VARCHAR
  • customer_zip_code_prefix — INT
  • customer_city — VARCHAR
  • customer_state — VARCHAR

order (Untitled3)

  • order_id — VARCHAR — Primary key — NOT NULL
  • customer_id — VARCHAR — Foreign key → customer.customer_id — NOT NULL
  • order_status — VARCHAR
  • order_purchase_timestamp — TIMESTAMP
  • order_approved_at — TIMESTAMP
  • order_delivered_carrier_date — TIMESTAMP
  • order_delivered_customer_date — TIMESTAMP
  • order_estimated_delivery_date — TIMESTAMP

order_item (Untitled4)

  • Key — Primary key — NOT NULL

product (Untitled5)

  • product_id — VARCHAR — Primary key — NOT NULL
  • product_category_name — VARCHAR
  • product_name_length — INT
  • product_description_length — INT
  • product_photos_qty — INT
  • product_weight_g — FLOAT
  • product_length_cm — FLOAT
  • product_height_cm — FLOAT
  • product_width_cm — FLOAT

seller (Untitled2)

  • seller_ids (seller_id) — VARCHAR — Primary key — NOT NULL
  • seller_zip_code_prefix — INT
  • seller_city — VARCHAR
  • Field — VARCHAR