[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