가계부

테이블 (9)

accounts

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • account_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100)
  • balance — DECIMAL(18, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

analysis_requests

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • analysis_target — VARCHAR(20) — NOT NULL
  • period_type — VARCHAR(10) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • description — VARCHAR(255)
  • result_image_url — VARCHAR(255)
  • result_summary — TEXT
  • created_at — TIMESTAMP

analysis_schedule

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • schedule_type — VARCHAR(10) — NOT NULL
  • run_day — VARCHAR(10)
  • is_active — BOOLEAN
  • updated_at — TIMESTAMP

common_codes

  • id — SERIAL
  • category — VARCHAR(50) — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • description — VARCHAR(100)
  • created_at — TIMESTAMP

notification_settings

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • setting_type — VARCHAR(50) — NOT NULL
  • threshold — DECIMAL(18, 2)
  • is_email_active — BOOLEAN
  • is_app_active — BOOLEAN
  • created_at — TIMESTAMP

notifications

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

token_blacklist

  • id — SERIAL
  • token — VARCHAR(512) — NOT NULL
  • user_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP

transactions

  • id — SERIAL
  • account_id — INTEGER — NOT NULL
  • transaction_type — VARCHAR(10) — NOT NULL
  • transaction_method — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(18, 2) — NOT NULL
  • balance_after — DECIMAL(18, 2) — NOT NULL
  • transaction_details — VARCHAR(255)
  • transaction_timestamp — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

users

  • id — SERIAL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20)
  • is_staff — BOOLEAN
  • is_superuser — BOOLEAN
  • is_active — BOOLEAN
  • last_login — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP