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