기계학습_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