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)