bbbb

Tables (13)

brew_order_steps

  • step_id — UUID
  • order_id — UUID — Foreign key → brew_orders.order_id — NOT NULL
  • ingredient_id — INT — NOT NULL
  • pump_no — INT
  • amount_ml — DECIMAL(6,2) — NOT NULL
  • step_order — INT — NOT NULL
  • execution_status — VARCHAR(20) — NOT NULL
  • executed_at — TIMESTAMP

brew_orders

  • order_id — UUID
  • guest_session_id — UUID — Foreign key → guest_sessions.guest_session_id — NOT NULL
  • final_recommendation_id — UUID — Foreign key → final_recommendations.final_recommendation_id
  • order_type — VARCHAR(20) — NOT NULL
  • order_status — VARCHAR(20) — NOT NULL
  • total_volume_ml — INT — NOT NULL
  • device_command_json — JSONB — NOT NULL
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP

cocktail_notes

  • note_id — SERIAL
  • cocktail_id — INT — NOT NULL
  • note_layer — VARCHAR(10) — NOT NULL
  • note_name — VARCHAR(50) — NOT NULL
  • intensity — DECIMAL(3,1) — NOT NULL
  • note_description — TEXT
  • created_at — TIMESTAMP — NOT NULL

dialogue_turns

  • turn_id — UUID
  • guest_session_id — UUID — Foreign key → guest_sessions.guest_session_id — NOT NULL
  • turn_index — INT — NOT NULL
  • speaker_role — VARCHAR(20) — NOT NULL
  • utterance_text — TEXT — NOT NULL
  • extracted_slots_json — JSONB
  • created_at — TIMESTAMP — NOT NULL

final_recommendations

  • final_recommendation_id — UUID
  • guest_session_id — UUID — Foreign key → guest_sessions.guest_session_id — NOT NULL
  • sample_recommendation_id — UUID — Foreign key → sample_recommendations.sample_recommendation_id — NOT NULL
  • final_cocktail_id — INT — NOT NULL
  • used_feedback_ids_json — JSONB
  • is_adjusted_recipe — BOOLEAN — NOT NULL
  • adjustment_reason — TEXT
  • final_recipe_snapshot_json — JSONB — NOT NULL
  • final_reason_text — TEXT — NOT NULL
  • confirmed_at — TIMESTAMP — NOT NULL

guest_sessions

  • guest_session_id — UUID
  • party_session_id — UUID — Foreign key → party_sessions.party_session_id — NOT NULL
  • guest_label — VARCHAR(50) — NOT NULL
  • beverage_familiarity — VARCHAR(20)
  • session_status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

ingredient_sensory_profiles

  • sensory_profile_id — SERIAL
  • ingredient_id — INT — NOT NULL
  • sweet_score — DECIMAL(3,1) — NOT NULL
  • sour_score — DECIMAL(3,1) — NOT NULL
  • bitter_score — DECIMAL(3,1) — NOT NULL
  • body_score — DECIMAL(3,1) — NOT NULL
  • freshness_score — DECIMAL(3,1) — NOT NULL
  • creamy_score — DECIMAL(3,1) — NOT NULL
  • spicy_score — DECIMAL(3,1) — NOT NULL
  • nutty_score — DECIMAL(3,1) — NOT NULL
  • fruity_score — DECIMAL(3,1) — NOT NULL
  • woody_score — DECIMAL(3,1) — NOT NULL
  • coffee_score — DECIMAL(3,1) — NOT NULL
  • herbal_score — DECIMAL(3,1) — NOT NULL
  • floral_score — DECIMAL(3,1) — NOT NULL
  • citrus_score — DECIMAL(3,1) — NOT NULL
  • minty_score — DECIMAL(3,1) — NOT NULL
  • sensory_note — TEXT

inventory_transactions

  • transaction_id — UUID
  • ingredient_id — INT — NOT NULL
  • order_id — UUID
  • delta_ml — DECIMAL(8,2) — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

party_sessions

  • party_session_id — UUID
  • session_name — VARCHAR(100)
  • session_status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • device_id — VARCHAR(100)
  • demo_mode — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

party_space_analysis

  • space_analysis_id — UUID
  • party_session_id — UUID — Foreign key → party_sessions.party_session_id — NOT NULL
  • image_path — TEXT — NOT NULL
  • style_tag — VARCHAR(50)
  • mood_tag — VARCHAR(50) — NOT NULL
  • dominant_colors_json — JSONB — NOT NULL
  • mood_weight — DECIMAL(3,2) — NOT NULL
  • vision_summary — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

preference_vectors

  • vector_id — UUID
  • guest_session_id — UUID — Foreign key → guest_sessions.guest_session_id — NOT NULL
  • sweetness_score — DECIMAL(3,1) — NOT NULL
  • bitterness_score — DECIMAL(3,1) — NOT NULL
  • sourness_score — DECIMAL(3,1) — NOT NULL
  • freshness_score — DECIMAL(3,1) — NOT NULL
  • body_score — DECIMAL(3,1) — NOT NULL
  • herbal_score — DECIMAL(3,1) — NOT NULL
  • citrus_score — DECIMAL(3,1) — NOT NULL
  • alcohol_score — DECIMAL(3,1) — NOT NULL
  • version — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sample_feedback

  • sample_feedback_id — UUID
  • sample_recommendation_id — UUID — Foreign key → sample_recommendations.sample_recommendation_id — NOT NULL
  • feedback_text — TEXT — NOT NULL
  • feedback_intent — VARCHAR(20) — NOT NULL
  • sweetness_delta — DECIMAL(3,1)
  • sourness_delta — DECIMAL(3,1)
  • bitterness_delta — DECIMAL(3,1)
  • body_delta — DECIMAL(3,1)
  • freshness_delta — DECIMAL(3,1)
  • aroma_delta_json — JSONB
  • parsed_summary — TEXT
  • created_at — TIMESTAMP — NOT NULL

sample_recommendations

  • sample_recommendation_id — UUID
  • guest_session_id — UUID — Foreign key → guest_sessions.guest_session_id — NOT NULL
  • space_analysis_id — UUID — Foreign key → party_space_analysis.space_analysis_id — NOT NULL
  • recommended_cocktail_id — INT — NOT NULL
  • recommendation_reason — TEXT — NOT NULL
  • confidence_score — DECIMAL(5,2)
  • sample_volume_ml — INT — NOT NULL
  • recipe_snapshot_json — JSONB — NOT NULL
  • created_at — TIMESTAMP — NOT NULL