데문해팀플_Instacart Market

테이블 (7)

Aisles (통로)

  • aisle_id (Field) — 기본 키
  • aisle (Field2)

Departments (부서)

  • department_id (Field) — 기본 키
  • department (Field2)

Order_product_train (최근주문)

  • order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
  • prodcuct_id (Key) — 외래 키 → Products.prodcuct_id — NOT NULL
  • add_to_cart_order (Field2)
  • reordered (Field3)

Order_products_prior (이전 주문)

  • order_id (Key2) — 외래 키 → Orders.order_id — NOT NULL
  • prodcuct_id (Key) — 외래 키 → Products.prodcuct_id — NOT NULL
  • add_to_cart_order (Field3)
  • reordered (Field4)

Orders (주문)

  • order_id (Key) — 기본 키 — NOT NULL
  • eval_set (Field)
  • user_id (Field2)
  • order_number (Field3)
  • order_dow (Field4)
  • order_hour_of_day (Field5)
  • days_since_prior_order (Field6)

Products (상품)

  • prodcuct_id (Key) — 기본 키 — NOT NULL
  • aisle_id (Field4) — 외래 키 → Aisles.aisle_id
  • department_id (Field2) — 외래 키 → Departments.department_id
  • product_name (Field)

Untitled (sample_submission)

  • Key (order_id) — 기본 키 — NOT NULL
  • Field (products)