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