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)