데문해팀플_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)