미션11
테이블 (8)
Customer (Untitled2)
- customer_id (Key) — 기본 키 — NOT NULL
- customer_unique_id (Key2) — 기본 키 — NOT NULL
- customer_zip_code_prefix (Field)
- customer_city (Field2)
- customer_state (Field3)
Order_item (Untitled3)
- order_item_id (Field) — 기본 키
- order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
- seller_id (Key) — 외래 키 → Seller.seller_id — NOT NULL
- product_id (Key3) — 외래 키 → Products.product_id — NOT NULL
- shipping_llimit_date (Field4)
- Price (Field5)
- freight_value (Field6)
Order_review (Untitled5)
- review_id (Key) — 기본 키 — NOT NULL
- order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
- review_score (Field2)
- review_comment_title (Field3)
- review_comment_message (Field4)
- review_creation_date (Field5)
- review_answer_timestamp (Field6)
Orders (Untitled)
- order_id (Key) — 기본 키 — NOT NULL
- customer_id (Key2) — 외래 키 → Customer.customer_id — NOT NULL
- order_status (Field2)
- order_purchase_timestamp (Field3)
- order_approved_at (Field4)
- order_delivered_carrier_date (Field5)
- order_delivered_customer_date (Field6)
- order_estimeated_delivery_date (Field7)
Payments (Untitled4)
- order_id (Key) — 외래 키 → Orders.order_id — NOT NULL
- payment_sequential (Field)
- Payment_type (Field2)
- payment_installments (Field3)
- payment_value (Field4)
Product_category_trans (Untitled8)
- product_category_name (Field3) — 외래 키 → Products.product_category_name
- Product_category_name_english (Field2)
Products (Untitled6)
- product_id (Key) — 기본 키 — NOT NULL
- product_category_name (Field) — 기본 키
- product_name_lenght (Field2)
- product_description_lenght (Field3)
- product_photos_qly (Field4)
- product_weight_g (Field5)
- product_length_cm (Field6)
- product_height_cm (Field7)
- product_width_cm (Field8)
Seller (Untitled7)
- seller_id (Key) — 기본 키 — NOT NULL
- seller_zip_code_prefix (Field)
- seller_city (Field2)
- seller_state (Field3)