red-custom-no

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)