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