olist

Tables (7)

Customers (Untitled)

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

Order Payments (Untitled6)

  • payment_sequential (Key) — INT — Primary key — NOT NULL
  • order_id (Field) — VARHCAR
  • payment_type (Field2) — VARCHAR
  • payment_installments (Field3) — INT
  • payment_value (Field4) — FLOAT

Order Reviews (Untitled7)

  • review_id (Key) — VARCHAR — Primary key — NOT NULL
  • order_id (Field) — VARCHAR
  • review_score (Field2) — INT
  • review_comment_title (Field3) — VARCHAR
  • review_comment_message (Field4) — TEXT
  • review_careation_date (Field5) — TIMESTAMP
  • review_answer_timestamp (Field6) — TIMESTAMP

Order_items (Untitled3)

  • customer_id (Key22) — VARCHAR — Foreign key → Orders.customer_id — NOT NULL
  • order_item_id (Field) — INT
  • seller_id (Field3) — VARCHAR
  • shipping_limit_date (Field4) — TIMESTAMP
  • price (Field5) — FLOAT
  • freight_value (Field6) — FLOAT
  • Field7

Orders (Untitled2)

  • order_id (Key) — VARCHAR — Primary key — NOT NULL
  • customer_id (Key2) — VARCHAR — Foreign key → Customers.customer_id — NOT NULL
  • order_status (Field2) — VARHCHAR
  • order_purchase_timestamp (Field3) — TIMESTAMP
  • order_approved_at (Field4) — TIMESTAMP
  • order_delivered_customer_date (Field5) — TIMESTAMP
  • order_delivered_carrier_date (Field6) — TIMESTAMP
  • order_estimated_delivery_date (Field7) — TIMESTAMP

Products (Untitled4)

  • product_id (Key) — VARCHAR — Primary key — NOT NULL
  • product_category_name (Field) — VARCHAR
  • product_name_length (Field2) — INT
  • product_description_length (Field3) — INT
  • product_photos_qty (Field4) — INT
  • product_weight_g (Field5) — FLOAT
  • product_lenght_cm (Field6) — FLOAT
  • product_height_cm (Field7) — FLOAT
  • product_width_cm (Field8) — FLOAT

Sellers (Untitled5)

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