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