V1~V14 ERD

Tables (23)

ai_setting

  • id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • provide_extra_info — BOOLEAN — NOT NULL
  • priority_expiration — BOOLEAN — NOT NULL
  • priority_nutrition — BOOLEAN — NOT NULL
  • priority_frequent — BOOLEAN — NOT NULL
  • notify_recipe_complete — BOOLEAN — NOT NULL
  • notify_ai_recommend — BOOLEAN — NOT NULL
  • response_style — VARCHAR(255)
  • include_image — BOOLEAN — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

alarm

  • alarm_id — BIGINT — Primary key — NOT NULL
  • alarm_date_time — TIMESTAMP
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • url — VARCHAR(255)
  • img — VARCHAR(255)
  • user_id — BIGINT
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

catalog_expiry_rule

  • id — BIGINT
  • catalog_id — BIGINT — Foreign key → ingredient_catalog.id — NOT NULL
  • storage_type — VARCHAR(20) — NOT NULL
  • shelf_life_days — INT — NOT NULL
  • reference_note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → ingredient_catalog.Key — NOT NULL

category_expiry_rule

  • id — BIGINT
  • category — VARCHAR(30) — NOT NULL
  • storage_type — VARCHAR(20) — NOT NULL
  • shelf_life_days — INT — NOT NULL
  • reference_note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

chat_message

  • id — BIGINT
  • content — TEXT — NOT NULL
  • sender — VARCHAR(50) — NOT NULL
  • ai_payload — TEXT
  • room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

chat_room

  • id — BIGINT
  • title — VARCHAR(255)
  • user_id — BIGINT — Foreign key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

image_asset

  • id — BIGINT
  • user_id — BIGINT — Foreign key
  • asset_type — VARCHAR(30) — NOT NULL
  • kind — VARCHAR(30) — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • object_key — TEXT — NOT NULL
  • width — INT
  • height — INT
  • created_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

image_variant

  • id — BIGINT
  • image_asset_id — BIGINT — Foreign key → image_asset.id — NOT NULL
  • variant_type — VARCHAR(20) — NOT NULL
  • object_key — TEXT — NOT NULL
  • width — INT — NOT NULL
  • height — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → image_asset.Key — NOT NULL

ingredient

  • id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • storage_id — BIGINT — Foreign key → storage.id — NOT NULL
  • catalog_id — BIGINT — Foreign key → ingredient_catalog.id
  • name — VARCHAR(100) — NOT NULL
  • registered_at — DATE
  • expires_at — DATE
  • expiry_source_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • consumed_at — DATE
  • discarded_at — DATE
  • note — TEXT
  • source_type — VARCHAR(20) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

ingredient_catalog

  • id — BIGINT
  • default_image_asset_id — BIGINT — Foreign key → image_asset.id
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • default_storage_type — VARCHAR(20) — NOT NULL
  • emoji — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → image_asset.Key — NOT NULL

ingredient_image

  • id — BIGINT
  • ingredient_id — BIGINT — Foreign key → ingredient.id — NOT NULL
  • image_asset_id — BIGINT — Foreign key → image_asset.id — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → ingredient.Key — NOT NULL

inquiry

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(1024)
  • status — VARCHAR(20) — NOT NULL
  • admin_reply — TEXT
  • answered_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • id (id2) — BIGINT — Foreign key → users.id — NOT NULL

recycling_guide

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • waste_type — VARCHAR(50) — NOT NULL
  • description — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

spring_ai_chat_memory

  • conversation_id — VARCHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL

storage

  • id — BIGINT
  • user_id — BIGINT — Foreign key — NOT NULL
  • storage_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

storage_tip

  • id — BIGINT
  • category — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • emoji — VARCHAR(10)
  • tip — TEXT — NOT NULL
  • storage_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

user_profile

  • user_id — BIGINT — Foreign key
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — TEXT
  • bio — TEXT
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • Key — Foreign key → users.id — NOT NULL

user_profile_allergy

  • allergy_type — VARCHAR(50) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • Key — Foreign key → user_profile.Key — NOT NULL

user_profile_cooking_tool

  • cooking_tool — VARCHAR(50) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • Key — Foreign key → user_profile.Key — NOT NULL

user_profile_food_style

  • food_style — VARCHAR(50) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • Key — Foreign key → user_profile.Key — NOT NULL

user_profile_preferred_ingredient

  • ingredient_name — VARCHAR(100) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • Key — Foreign key → user_profile.Key — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • inactive_at — TIMESTAMPTZ
  • terms_agreed_at — TIMESTAMPTZ
  • privacy_agreed_at — TIMESTAMPTZ
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

vector_store

  • id — UUID
  • content — TEXT
  • metadata — JSONB
  • embedding — VARCHAR(50)