ygy-hack

Tables (9)

brands

  • brand_id — NUMBER — Primary key — NOT NULL
  • brand_name — VARCHAR2(100) — NOT NULL

correction_factors

  • factor_id — NUMBER — Primary key — NOT NULL
  • scope_type — VARCHAR2(10) — NOT NULL
  • scope_id — NUMBER
  • scope_value — VARCHAR2(50)
  • factor_value — NUMBER — NOT NULL
  • sample_count — NUMBER
  • updated_at — TIMESTAMP

customers

  • customer_id — NUMBER — Primary key — NOT NULL
  • delivery_lat — NUMBER(9,6)
  • delivery_lng — NUMBER(9,6)
  • delivery_address — VARCHAR2(200)

explanations

  • explanation_id — NUMBER — Primary key — NOT NULL
  • package_id — NUMBER — Foreign key → packages.package_id
  • consumer_text — CLOB
  • rider_text — CLOB
  • created_at — TIMESTAMP

orders

  • order_id — NUMBER — Primary key — NOT NULL
  • customer_id — NUMBER — Foreign key → customers.customer_id
  • store_id — NUMBER — Foreign key → stores.store_id
  • package_id — NUMBER — Foreign key → packages.package_id
  • menu_summary — VARCHAR2(200)
  • amount — NUMBER
  • delivery_fee — NUMBER
  • request_note — VARCHAR2(200)
  • status — VARCHAR2(20)
  • created_at — TIMESTAMP
  • predicted_ready_at — TIMESTAMP
  • vector_corrected_at — TIMESTAMP
  • actual_ready_at — TIMESTAMP
  • picked_up_at — TIMESTAMP
  • delivered_at — TIMESTAMP

packages

  • package_id — NUMBER — Primary key — NOT NULL
  • rider_id — NUMBER — Foreign key → riders.rider_id
  • status — VARCHAR2(20)
  • bundle_size — NUMBER
  • route_strategy — VARCHAR2(20)
  • selected_route_score — NUMBER
  • candidate_route_count — NUMBER
  • created_at — TIMESTAMP
  • offered_at — TIMESTAMP
  • accepted_at — TIMESTAMP
  • completed_at — TIMESTAMP

riders

  • rider_id — NUMBER — Primary key — NOT NULL
  • display_name — VARCHAR2(50)
  • vehicle — VARCHAR2(20)
  • status — VARCHAR2(20)
  • current_lat — NUMBER(9,6)
  • current_lng — NUMBER(9,6)
  • location_updated_at — TIMESTAMP
  • completed_order_count — NUMBER

stores

  • store_id — NUMBER — Primary key — NOT NULL
  • brand_id — NUMBER — Foreign key → brands.brand_id
  • name — VARCHAR2(100) — NOT NULL
  • category — VARCHAR2(50) — NOT NULL
  • address — VARCHAR2(200)
  • lat — NUMBER(9,6) — NOT NULL
  • lng — NUMBER(9,6) — NOT NULL
  • base_cooking_min — NUMBER — NOT NULL
  • current_order_count — NUMBER
  • congestion — VARCHAR2(10)
  • prediction_accuracy_pct — NUMBER

vector_cases

  • case_id — NUMBER — Primary key — NOT NULL
  • store_id — NUMBER — Foreign key → stores.store_id
  • weekday — NUMBER
  • time_slot — VARCHAR2(20)
  • concurrent_order_count — NUMBER
  • actual_cook_time — NUMBER
  • embedding — VECTOR(1024, FLOAT32)