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