기계학습_PBL2_연관분석

테이블 (6)

aisles

  • aisle_id — INT — 기본 키 — NOT NULL
  • aisle — VARCHAR(100) — NOT NULL

departments

  • department_id — INT — 기본 키 — NOT NULL
  • department — VARCHAR(100) — NOT NULL

order_products_prior

  • order_id — INT — 외래 키 → orders.order_id — NOT NULL
  • product_id — INT — 외래 키 → products.product_id — NOT NULL
  • add_to_cart_order — INT — NOT NULL
  • reordered — TINYINT — NOT NULL

order_products_train

  • order_id — INT — 외래 키 → orders.order_id — NOT NULL
  • product_id — INT — 외래 키 → products.product_id — NOT NULL
  • add_to_cart_order — INT — NOT NULL
  • reordered — TINYINT — NOT NULL

orders

  • order_id — INT — 기본 키 — NOT NULL
  • user_id — INT — NOT NULL
  • eval_set — VARCHAR(10) — NOT NULL
  • order_number — INT — NOT NULL
  • order_dow — INT — NOT NULL
  • order_hour_of_day — INT — NOT NULL
  • days_since_prior_order — FLOAT

products

  • product_id — INT — 기본 키 — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • aisle_id — INT — 외래 키 → aisles.aisle_id — NOT NULL
  • department_id — INT — 외래 키 → departments.department_id — NOT NULL