e-commerce data
테이블 (9)
결제방식 (order_payments)
- Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
- Field2 (payment_sequential) — long
- Field3 (payment_type) — string
- Field4 (payment_installments) — long
- Field5 (payment_value) — double
리뷰 (order_reviews)
- Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
- Field (review_id) — string
- Field3 (review_score) — long
- Field4 (review_creation_date) — string
- Field5 (review_answer_timestamp) — string
소비자 (customer)
- Key (customer_id) — long — 기본 키 — NOT NULL
- Key (geolocation_zip_code_prefix) — string — 외래 키 → 지역.Key — NOT NULL
- Field2 (customer_unique_id) — string
- Field3 (customer_zip_code_prefix) — string
- Field (customer_city) — string
- Field3 (customer_state) — string
제품 (products)
- Key (product_id) — string — 기본 키 — NOT NULL
- Field2 (product_category_name) — string
- Field3 (product_name_lenght) — double
- Field4 (product_description_lenght) — double
- Field5 (product_photos_qty) — double
- Field6 (product_weight_g) — double
- Field7 (product_length_cm) — double
- Field8 (product_height_cm) — double
- Field9 (product_width_cm) — double
주문 (orders)
- Key (order_id) — long — 기본 키 — NOT NULL
- Key (customer_id2) — long — 외래 키 → 소비자.Key — NOT NULL
- Field2 (customer_id) — string
- Field3 (order_status) — string
- Field4 (order_purchase_timestamp) — string
- Field5 (order_approved_at) — string
- Field6 (order_delivered_carrier_date) — string
- Field7 (order_delivered_customer_date) — string
- Field8 (order_estimated_delivery_date) — string
주문_제품 (order_items)
- Key (order_id) — long — 외래 키 → 주문.Key — NOT NULL
- Key (product_id) — string — 외래 키 → 제품.Key — NOT NULL
- Key (seller_id) — string — 외래 키 → 판매자.Key — NOT NULL
- Field2 (order_item_id) — long
- Field5 (shipping_limit_date) — string
- Field6 (price) — double
- Field7 (freight_value) — double
지역 (geolocation)
- Key (geolocation_zip_code_prefix) — string — 기본 키 — NOT NULL
- Field2 (geolocation_lat) — double
- Field3 (geolocation_lng) — double
- Field4 (geolocation_city) — string
- Field5 (geolocation_state) — string
카테고리 이름 (product_category_name)
- Field (product_category_name) — string
- Field2 (product_category_name_english) — string
판매자 (sellers)
- Key (seller_id) — string — 기본 키 — NOT NULL
- Key (geolocation_zip_code_prefix) — string — 외래 키 → 지역.Key — NOT NULL
- Field2 (seller_zip_code_prefix) — long
- Field3 (seller_city) — string
- Field4 (seller_state) — string