erd
Tables (12)
ai_insights
- insight_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- year — INT — NOT NULL
- month — INT — NOT NULL
- insight_type — VARCHAR(20) — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
categories
- category_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- name — VARCHAR(30) — NOT NULL
- type — VARCHAR(10) — NOT NULL
- sort_order — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- is_fixed — TINYINT(1) — NOT NULL
- is_budgetable — TINYINT(1) — NOT NULL
- temp_old_custom_id — BIGINT
category_orders
- category_order_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category_id — BIGINT — NOT NULL
- type — VARCHAR(10) — NOT NULL
- sort_order — INT — NOT NULL
emotions
- emotion_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- color — VARCHAR(20) — NOT NULL
- character_key — VARCHAR(30)
- sort_order — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
goals
- goal_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- target_amount — INT — NOT NULL
- current_amount — INT — NOT NULL
- start_date — DATE
- due_date — DATE
- is_main — TINYINT(1) — NOT NULL
- status — VARCHAR(12) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- initial_amount — BIGINT — NOT NULL
monthly_summaries
- summary_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- year — INT — NOT NULL
- month — INT — NOT NULL
- total_income — INT — NOT NULL
- total_expense — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
notification_settings
- notification_setting_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- record_reminder — TINYINT(1) — NOT NULL
- weekly_report — TINYINT(1) — NOT NULL
- goal_nudge — TINYINT(1) — NOT NULL
- remind_time — VARCHAR(5)
- updated_at — DATETIME — NOT NULL
refresh_tokens
- token_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
social_accounts
- social_account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(100) — NOT NULL
- connected_at — DATETIME — NOT NULL
terms_agreements
- agreement_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- terms_type — VARCHAR(15) — NOT NULL
- agreed — TINYINT(1) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- agreed_at — DATETIME — NOT NULL
transactions
- transaction_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- emotion_id — BIGINT — Foreign key → emotions.emotion_id — NOT NULL
- category_id — BIGINT — Foreign key → categories.category_id — NOT NULL
- type — VARCHAR(10) — NOT NULL
- amount — INT — NOT NULL
- memo — VARCHAR(200)
- occurred_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- goal_id — BIGINT — Foreign key → goals.goal_id
users
- user_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- profile_image_url — VARCHAR(500)
- onboarding_done — TINYINT(1) — NOT NULL
- theme_mode — VARCHAR(10) — NOT NULL
- aurora_theme — VARCHAR(20) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- total_asset — BIGINT — NOT NULL
- fcm_token — VARCHAR(255)