[Sprint_Mission_9] Olist

Tables (7)

Customers (Customer)

  • 고객_id (customer_id) — VARCHAR — Primary key — NOT NULL
  • 고객_고유_id (customer_unique_id) — VARCHAR
  • 고객_우편번호 (customer_zip_code_prefix) — INT
  • 고객_거주도시 (customer_city) — VARCHAR
  • 고객_거주_주 (customer_state) — VARCHAR

Order Items

  • 주문_상품 (order_item_id) — INT — Primary key — NOT NULL
  • 주문_id (order_id) — VARCHAR — Foreign key → Orders.주문_id — NOT NULL
  • 상품_id (product_id) — VARCHAR — Foreign key → Products.상품_id — NOT NULL
  • 셀러_id (seller_id) — VARCHAR — Foreign key → Sellers.셀러_id — NOT NULL
  • 발송마감일 (shipping_limit_date) — TIMESTAMP
  • 상품가격 (price) — FLOAT
  • 배송비 (freight_value) — FLOAT

Order Payments

  • 주문_id (order_id) — VARCHAR — Foreign key → Orders.주문_id — NOT NULL
  • 결제_순서 (payment_sequential) — INT
  • 결제_방식 (payment_type) — VARCHAR — (신용카드, 현금 등)
  • 할부_개월 (payment_installments) — INT
  • 결제금액 (payment_value) — FLOAT

Order Reviews

  • 리뷰_id (review_id) — VARCHAR — Primary key — NOT NULL
  • 주문_id (order_id) — VARCHAR — Foreign key → Orders.주문_id — NOT NULL
  • 평점 (review_score) — INT
  • 리뷰 제목 (review_comment_title) — VARCHAR
  • 리뷰 내용 (review_comment_message) — TEXT
  • 리뷰_작성일 (review_creation_date) — TIMESTAMP
  • 답변_작성일 (review_answer_timestamp) — TIMESTAMP

Orders

  • 주문_id (order_id) — VARCHAR — Primary key — NOT NULL
  • 고객_id (customer_id) — VARCHAR — Foreign key → Customers.고객_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

Products

  • 상품_id (product_id) — VARCHAR — Primary key — NOT NULL
  • 상품_카테고리 (product_category_name) — VARCHAR
  • 상품_이름_길이 (product_name_length) — INT
  • 상품_설명_길이 (product_description_length) — INT
  • 상품_사진_개수 (product_photos_qty) — INT
  • 상품무게(g) (product_weight_g) — FLOAT
  • 상품길이(cm) (product_length_cm) — FLOAT
  • 상품높이(cm) (product_height_cm) — FLOAT
  • 상품폭(cm) (product_width_cm) — FLOAT

Sellers

  • 셀러_id (seller_id) — VARCHAR — Primary key — NOT NULL
  • 셀러_우편번호 (seller_zip_code_prefix) — INT
  • 셀러_거주도시 (seller_city) — VARCHAR
  • 셀로_거주_주 (seller_state) — VARCHAR