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