olist_erd

Tables (7)

Order_Items (Untitled3)

  • 주문내 각상품 식별자 (order_item_id) — INT — Primary key — NOT NULL
  • 발송마감기한 (chipping_limit_date) — TIMESTAMP
  • 상품가격 (price) — FLOAT
  • 배송비 (freight_value) — FLOAT
  • 주문고유식별자 (order_id) — VARCHAR — Foreign key → Orders.주문고유식별자 — NOT NULL
  • 상품고유식별자 (product_id) — VARCHAR — Foreign key → Products.상품고유식별자 — NOT NULL
  • 판매자고유식별자 (seller_id) — VARCHAR — Foreign key → Sellers.판매자고유식별자 — NOT NULL

Order_payments (Untitled6)

  • 주문고유식별자 (order_id) — VARCHAR — Foreign key → Orders.주문고유식별자 — NOT NULL
  • 결제수단순서 (payment_sequential) — INT
  • 결제방식 (payment_type) — VARCHAR
  • 할부개월수 (payment_installments) — INT
  • 결제금액 (payment_value) — FLOAT

Order_reviews (Untitled7)

  • 리뷰고유식별자 (review_id) — VARCHAR — Primary key — NOT NULL
  • 평점 (review_score) — INT
  • 리뷰제목 (review_comment_title) — VARCHAR
  • 리뷰내용 (review_comment_message) — TEXT
  • 리뷰생성일 (review_createion_date) — TIMESTAMP
  • 리뷰답변시간 (review_answer_timestamp)
  • 주문고유식별자 (order_id) — VARCHAR — Foreign key → Orders.주문고유식별자 — NOT NULL

Orders (Untitled2)

  • 주문고유식별자 (order_id) — VARCHAR — Primary key — NOT NULL
  • 주문상태 (order_staus) — VARCHAR
  • 주문시각 (order_purchase_timestamp) — TIMESTAMP
  • 결제승인시각 (order_approved_at) — TIMESTAMP
  • 배송시작시각 (order_delivered_carrier_date) — TIMESTAMP
  • 배송된날짜 (order_delivered_customer_date) — TIMESTAMP
  • 예상배송일 (order_estimated_delivery_date) — TIMESTAMP
  • 고객고유식별자 (customer_id) — VARCHAR — Foreign key → customers.고객고유식별자 — NOT NULL

Products (Untitled4)

  • 상품고유식별자 (product_id) — VARCHAR — Primary key — NOT NULL
  • 카테고리 (product_category_name) — VARCHAR
  • 상품이름길이 (product_name_length) — INT
  • 상품설명길이 (product_description_length) — INT
  • 상품사진수 (rpoduct_photos_qty) — INT
  • 상품무게 (product_weight_g) — FLOAT
  • 상품길이 (product_length_cm) — FLOAT
  • 상품높이 (product_height_cm) — FLOAT
  • 상품폭 (product_width_cm) — FLOAT

Sellers (Untitled5)

  • 판매자고유식별자 (seller_id) — VARCHAR — Primary key — NOT NULL
  • 판매자우편번호앞부분 (seller_zip_code_prefix) — INT
  • 판매자도시 (seller_city) — VARCHAR
  • 판매자주 (seller_state) — VARCHAR

customers (Untitled)

  • 고객고유식별자 (customer_id) — VARCHAR — Primary key — NOT NULL
  • 고객의고유ID (customer_unique_id) — VARCHAR
  • 고객의 우편번호 앞부분 (customer_zip_code_prefix) — INT
  • 고객의도시 (customer_city) — VARCHAR
  • 고객의주 (customer_state) — VARCHAR