my

Tables (42)

admin_copy_blocks

  • id — UUID
  • slug — TEXT — NOT NULL
  • locale — TEXT
  • content — JSONB — NOT NULL
  • version — INTEGER
  • updated_by — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • UNIQUE(slug, — locale)

admin_security_audit

  • id — UUID
  • action — TEXT — NOT NULL
  • user_id — TEXT — NOT NULL
  • details — JSONB
  • ip_address — INET
  • user_agent — TEXT
  • created_at — TIMESTAMPTZ

allergies

  • ID (id) — UUID — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name_ko — VARCHAR(200) — NOT NULL
  • name_en — VARCHAR(200)
  • category — VARCHAR(100)
  • severity_level — VARCHAR(20)
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

allergy_derived_ingredients

  • ID (id) — UUID — Primary key — NOT NULL
  • allergy_code — VARCHAR(50)
  • ingredient_name — VARCHAR(200) — NOT NULL
  • ingredient_type — VARCHAR(50)
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → allergies.ID — NOT NULL

calorie_calculation_formulas

  • ID (id) — UUID — Primary key — NOT NULL
  • formula_name — VARCHAR(100) — NOT NULL
  • formula_type — VARCHAR(50)
  • gender — VARCHAR(10)
  • age_min — INT
  • age_max — INT
  • formula_expression — TEXT — NOT NULL
  • description — TEXT
  • is_default — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

diet_notification_settings

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • popup_enabled — BOOLEAN — NOT NULL
  • browser_enabled — BOOLEAN
  • notification_time — TIME
  • kcdc_enabled — BOOLEAN — NOT NULL
  • last_notification_date — DATE
  • last_dismissed_date — DATE
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

diet_plans

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • family_member_id — UUID
  • plan_date — DATE — NOT NULL
  • meal_type — TEXT — NOT NULL
  • recipe_id — TEXT
  • recipe_title — TEXT — NOT NULL
  • recipe_description — TEXT
  • ingredients — JSONB
  • instructions — TEXT
  • calories — INTEGER
  • protein_g — NUMERIC
  • carbs_g — NUMERIC
  • fat_g — NUMERIC
  • sodium_mg — INTEGER
  • fiber_g — NUMERIC
  • potassium_mg — INTEGER
  • phosphorus_mg — INTEGER
  • gi_index — NUMERIC
  • composition_summary — JSONB
  • is_unified — BOOLEAN
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → family_members.ID — NOT NULL
  • ID (id4) — UUID — Foreign key → family_members.ID — NOT NULL

disease_excluded_foods_extended

  • ID (id) — UUID — Primary key — NOT NULL
  • disease_code — VARCHAR(50)
  • food_name — VARCHAR(200) — NOT NULL
  • food_type — VARCHAR(50)
  • severity — VARCHAR(20)
  • reason — TEXT
  • exclusion_type — TEXT
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → diseases.ID — NOT NULL

diseases

  • ID (id) — UUID — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name_ko — VARCHAR(200) — NOT NULL
  • name_en — VARCHAR(200)
  • category — VARCHAR(100)
  • description — TEXT
  • calorie_adjustment_factor — NUMERIC
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

emergency_procedures

  • ID (id) — UUID — Primary key — NOT NULL
  • allergy_code — VARCHAR(50)
  • procedure_type — VARCHAR(50)
  • title_ko — VARCHAR(200) — NOT NULL
  • title_en — VARCHAR(200)
  • steps — JSONB — NOT NULL
  • warning_signs — JSONB
  • when_to_call_911 — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → allergies.ID — NOT NULL

family_members

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — TEXT
  • relationship — TEXT — NOT NULL
  • diseases — TEXT
  • allergies — TEXT
  • height_cm — INTEGER
  • weight_kg — NUMERIC
  • activity_level — TEXT
  • dietary_preferences — TEXT
  • include_in_unified_diet — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

favorite_meals

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • recipe_id — UUID
  • recipe_title — TEXT — NOT NULL
  • meal_type — TEXT
  • calories — INTEGER
  • protein — NUMERIC
  • carbs — NUMERIC
  • fat — NUMERIC
  • notes — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • UNIQUE(user_id, — recipe_id)
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → recipes.ID — NOT NULL

foodsafety_recipes_cache

  • ID (id) — UUID — Primary key — NOT NULL
  • rcp_seq — TEXT — NOT NULL
  • rcp_nm — TEXT — NOT NULL
  • rcp_pat2 — TEXT
  • rcp_way2 — TEXT
  • info_eng — NUMERIC
  • info_car — NUMERIC
  • info_pro — NUMERIC
  • info_fat — NUMERIC
  • info_na — NUMERIC
  • rcp_parts_dtls — TEXT
  • rcp_na_tip — TEXT
  • att_file_no_main — TEXT
  • att_file_no_mk — TEXT
  • hash_tag — TEXT
  • manual_data — JSONB
  • cached_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

image_cache_cleanup_logs

  • ID (id) — UUID — Primary key — NOT NULL
  • cleanup_date — TIMESTAMPTZ — NOT NULL
  • images_removed — INTEGER
  • space_freed_mb — NUMERIC
  • cleanup_duration_ms — INTEGER
  • cleanup_type — TEXT
  • error_message — TEXT
  • created_at — TIMESTAMPTZ

image_cache_stats

  • ID (id) — UUID — Primary key — NOT NULL
  • stat_date — DATE — NOT NULL
  • total_images — INTEGER
  • static_images — INTEGER
  • gemini_images — INTEGER
  • placeholder_images — INTEGER
  • total_access_count — INTEGER
  • cache_hit_rate — NUMERIC
  • storage_size_mb — NUMERIC
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

image_usage_logs

  • ID (id) — UUID — Primary key — NOT NULL
  • image_path — TEXT — NOT NULL
  • food_name — TEXT
  • source_type — TEXT
  • access_count — INTEGER
  • last_accessed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

kcdc_alerts

  • id — UUID
  • alert_type — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • severity — TEXT
  • flu_stage — TEXT
  • flu_week — TEXT
  • vaccine_name — TEXT
  • target_age_group — TEXT
  • recommended_date — DATE
  • source_url — TEXT
  • published_at — TIMESTAMPTZ
  • is_active — BOOLEAN
  • priority — INTEGER
  • fetched_at — TIMESTAMPTZ
  • expires_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

legacy_documents

  • ID (id) — UUID — Primary key — NOT NULL
  • video_id — UUID
  • title — TEXT — NOT NULL
  • summary — TEXT — NOT NULL
  • region — TEXT — NOT NULL
  • era — TEXT — NOT NULL
  • ingredients — JSONB
  • tools — JSONB
  • source — JSONB
  • steps — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • ID (id2) — UUID — Foreign key → legacy_videos.ID — NOT NULL

legacy_masters

  • ID (id) — UUID — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • region — TEXT — NOT NULL
  • bio — TEXT

legacy_replacement_guides

  • ID (id) — UUID — Primary key — NOT NULL
  • traditional — JSONB — NOT NULL
  • modern — JSONB — NOT NULL
  • tips — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

legacy_videos

  • ID (id) — UUID — Primary key — NOT NULL
  • master_id — UUID
  • slug — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT — NOT NULL
  • duration_minutes — INTEGER — NOT NULL
  • region — TEXT — NOT NULL
  • era — TEXT — NOT NULL
  • ingredients — TEXT
  • thumbnail_url — TEXT — NOT NULL
  • video_url — TEXT — NOT NULL
  • premium_only — BOOLEAN
  • tags — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • ID (id2) — UUID — Foreign key → legacy_masters.ID — NOT NULL

meal_kit_products

  • ID (id) — UUID — Primary key — NOT NULL
  • coupang_product_id — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • image_url — TEXT
  • price — INTEGER — NOT NULL
  • original_price — INTEGER
  • discount_rate — INTEGER
  • product_url — TEXT — NOT NULL
  • affiliate_link — TEXT
  • calories — INTEGER
  • protein — NUMERIC
  • carbs — NUMERIC
  • fat — NUMERIC
  • category — TEXT
  • meal_type — TEXT
  • last_synced_at — TIMESTAMPTZ
  • sync_status — TEXT
  • sync_error — TEXT
  • is_active — BOOLEAN
  • is_available — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

meal_kits

  • ID (id) — UUID — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • image_url — TEXT
  • price — INTEGER — NOT NULL
  • serving_size — INTEGER
  • calories — INTEGER
  • protein — NUMERIC
  • carbs — NUMERIC
  • fat — NUMERIC
  • category — TEXT
  • meal_type — TEXT
  • purchase_url — TEXT
  • is_active — BOOLEAN
  • is_premium_only — BOOLEAN
  • created_by — UUID
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

notification_logs

  • id — UUID
  • type — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • payload — JSONB
  • triggered_at — TIMESTAMPTZ — NOT NULL
  • actor — TEXT
  • error_message — TEXT
  • created_at — TIMESTAMPTZ

payment_transactions

  • ID (id) — UUID — Primary key — NOT NULL
  • subscription_id — UUID
  • user_id — UUID — NOT NULL
  • status — TEXT — NOT NULL
  • transaction_type — TEXT — NOT NULL
  • pg_provider — TEXT — NOT NULL
  • pg_transaction_id — TEXT
  • amount — INTEGER — NOT NULL
  • tax_amount — INTEGER
  • net_amount — INTEGER — NOT NULL
  • payment_method — TEXT
  • card_info — JSONB
  • paid_at — TIMESTAMPTZ
  • refunded_at — TIMESTAMPTZ
  • metadata — JSONB
  • is_test_mode — BOOLEAN
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → subscriptions.ID — NOT NULL

popup_announcements

  • id — UUID
  • title — TEXT — NOT NULL
  • body — TEXT — NOT NULL
  • active_from — TIMESTAMPTZ — NOT NULL
  • active_until — TIMESTAMPTZ
  • status — TEXT — NOT NULL
  • priority — INTEGER
  • target_segments — JSONB
  • metadata — JSONB
  • image_url — TEXT
  • link_url — TEXT
  • display_type — TEXT
  • created_by — TEXT — NOT NULL
  • updated_by — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

promo_code_uses

  • ID (id) — UUID — Primary key — NOT NULL
  • promo_code_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • subscription_id — UUID
  • used_at — TIMESTAMPTZ
  • UNIQUE(promo_code_id, — user_id)
  • ID (id2) — UUID — Foreign key → promo_codes.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → subscriptions.ID — NOT NULL
  • ID (id4) — UUID — Foreign key → promo_codes.ID — NOT NULL
  • ID (id5) — UUID — Foreign key → subscriptions.ID — NOT NULL

promo_codes

  • ID (id) — UUID — Primary key — NOT NULL
  • code — TEXT — NOT NULL
  • discount_type — TEXT — NOT NULL
  • discount_value — INTEGER — NOT NULL
  • max_uses — INTEGER
  • current_uses — INTEGER
  • valid_from — TIMESTAMPTZ — NOT NULL
  • valid_until — TIMESTAMPTZ — NOT NULL
  • applicable_plans — TEXT
  • new_users_only — BOOLEAN
  • description — TEXT
  • created_by — UUID
  • created_at — TIMESTAMPTZ

recipe_ingredients

  • ID (id) — UUID — Primary key — NOT NULL
  • recipe_id — UUID — NOT NULL
  • name — TEXT — NOT NULL
  • ingredient_name — TEXT
  • quantity — NUMERIC
  • unit — TEXT
  • notes — TEXT
  • display_order — INTEGER — NOT NULL
  • category — ingredient_category
  • is_optional — BOOLEAN
  • preparation_note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → recipes.ID — NOT NULL

recipe_ratings

  • ID (id) — UUID — Primary key — NOT NULL
  • recipe_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • rating — NUMERIC — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(recipe_id, — user_id)
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → recipes.ID — NOT NULL

recipe_reports

  • ID (id) — UUID — Primary key — NOT NULL
  • recipe_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • report_type — TEXT — NOT NULL
  • reason — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • ID (id2) — UUID — Foreign key → recipes.ID — NOT NULL

recipe_steps

  • ID (id) — UUID — Primary key — NOT NULL
  • recipe_id — UUID — NOT NULL
  • step_number — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — TEXT
  • video_url — TEXT
  • timer_minutes — INTEGER
  • foodsafety_manual_img — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • ID (id2) — UUID — Foreign key → recipes.ID — NOT NULL

recipe_usage_history

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • family_member_id — UUID
  • recipe_title — TEXT — NOT NULL
  • recipe_url — TEXT
  • meal_type — TEXT
  • used_date — DATE — NOT NULL
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → family_members.ID — NOT NULL

recipes

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID
  • slug — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT
  • thumbnail_url — TEXT
  • difficulty — INTEGER — NOT NULL
  • cooking_time_minutes — INTEGER — NOT NULL
  • servings — INTEGER
  • calories — NUMERIC
  • carbohydrates — NUMERIC
  • protein — NUMERIC
  • fat — NUMERIC
  • sodium — NUMERIC
  • foodsafety_rcp_seq — TEXT
  • foodsafety_rcp_way2 — TEXT
  • foodsafety_rcp_pat2 — TEXT
  • foodsafety_info_eng — NUMERIC
  • foodsafety_info_car — NUMERIC
  • foodsafety_info_pro — NUMERIC
  • foodsafety_info_fat — NUMERIC
  • foodsafety_info_na — NUMERIC
  • foodsafety_info_fiber — NUMERIC
  • foodsafety_rcp_parts_dtls — TEXT
  • foodsafety_att_file_no_main — TEXT
  • foodsafety_att_file_no_mk — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

royal_recipes_posts

  • ID (id) — UUID — Primary key — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • era — TEXT — NOT NULL
  • author_id — TEXT — NOT NULL
  • slug — TEXT — NOT NULL
  • published — BOOLEAN — NOT NULL
  • thumbnail_url — TEXT
  • excerpt — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

subscriptions

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • status — TEXT — NOT NULL
  • plan_type — TEXT — NOT NULL
  • billing_key — TEXT
  • payment_method — TEXT
  • last_four_digits — TEXT
  • started_at — TIMESTAMPTZ — NOT NULL
  • current_period_start — TIMESTAMPTZ — NOT NULL
  • current_period_end — TIMESTAMPTZ — NOT NULL
  • cancelled_at — TIMESTAMPTZ
  • price_per_month — INTEGER — NOT NULL
  • total_paid — INTEGER
  • is_test_mode — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

user_health_profiles

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • diseases — TEXT
  • allergies — TEXT
  • preferred_ingredients — TEXT
  • disliked_ingredients — TEXT
  • excluded_ingredients — JSONB
  • dietary_preferences — TEXT
  • premium_features — TEXT
  • diseases_jsonb — JSONB
  • allergies_jsonb — JSONB
  • preferred_ingredients_jsonb — JSONB
  • dietary_preferences_jsonb — JSONB
  • height_cm — INTEGER
  • weight_kg — NUMERIC
  • age — INTEGER
  • gender — TEXT
  • activity_level — TEXT
  • daily_calorie_goal — INTEGER
  • calorie_calculation_method — VARCHAR(50)
  • manual_target_calories — INT
  • show_calculation_formula — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

user_subscriptions

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • subscription_plan — TEXT — NOT NULL
  • started_at — TIMESTAMPTZ
  • expires_at — TIMESTAMPTZ
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

users

  • ID (id) — UUID — Primary key — NOT NULL
  • clerk_id — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • is_premium — BOOLEAN
  • premium_expires_at — TIMESTAMPTZ
  • trial_ends_at — TIMESTAMPTZ
  • mfa_secret — TEXT
  • mfa_enabled — BOOLEAN
  • mfa_backup_codes — TEXT
  • notification_settings — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

weekly_diet_plans

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • week_start_date — DATE — NOT NULL
  • week_year — INTEGER — NOT NULL
  • week_number — INTEGER — NOT NULL
  • is_family — BOOLEAN
  • total_recipes_count — INTEGER
  • generation_duration_ms — INTEGER
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • UNIQUE(user_id, — week_year,

weekly_nutrition_stats

  • ID (id) — UUID — Primary key — NOT NULL
  • weekly_diet_plan_id — UUID — NOT NULL
  • day_of_week — INTEGER — NOT NULL
  • date — DATE — NOT NULL
  • total_calories — NUMERIC
  • total_carbohydrates — NUMERIC
  • total_protein — NUMERIC
  • total_fat — NUMERIC
  • total_sodium — NUMERIC
  • meal_count — INTEGER
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → weekly_diet_plans.ID — NOT NULL

weekly_shopping_lists

  • ID (id) — UUID — Primary key — NOT NULL
  • weekly_diet_plan_id — UUID — NOT NULL
  • ingredient_name — TEXT — NOT NULL
  • total_quantity — NUMERIC
  • unit — TEXT
  • category — TEXT
  • recipes_using — JSONB
  • is_purchased — BOOLEAN
  • created_at — TIMESTAMPTZ
  • ID (id2) — UUID — Foreign key → weekly_diet_plans.ID — NOT NULL