Instacart

Tables (6)

aisles (분류)

  • aisle_id (Key) — int — Primary key — NOT NULL
  • aisle (Field) — text

departments (부서)

  • department_id (Key) — int — Primary key — NOT NULL
  • department (Field) — text

orders (주문)

  • order_id (Key) — int — Primary key — NOT NULL
  • user_id (Field) — int
  • eval_set (Field2) — text
  • order_number (Field3) — int
  • order_dow (Field4) — int
  • order_hour_of_day (Field5) — int
  • days_since_prior_order (Field6) — int

prior_order (과거 주문)

  • order_id (Key2) — int — Foreign key → orders.order_id — NOT NULL
  • product_id (Key) — int — Foreign key → products.product_id — NOT NULL
  • add_to_cart_order (Field2) — int
  • reordered (Field3) — int

products (상품)

  • product_id (Key) — int — Primary key — NOT NULL
  • aisle_id (Key2) — int — Foreign key → aisles.aisle_id — NOT NULL
  • department_id (Key3) — int — Foreign key → departments.department_id — NOT NULL
  • product_name (Field) — text

train_order (학습 주문)

  • order_id (Key2) — int — Foreign key → orders.order_id — NOT NULL
  • product_id (Key) — int — Foreign key → products.product_id — NOT NULL
  • add_to_cart_order (Field2) — int
  • reordered (Field3) — int