사자사자 가계부

테이블 (7)

asset

  • id — SERIAL
  • user_id — UUID — 외래 키 → user.id
  • asset_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • provider — VARCHAR(200)
  • balance — NUMERIC(18,2) — NOT NULL
  • display_number — VARCHAR(50)
  • encrypted_number — TEXT
  • is_saving_account — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

fixed_expense

  • id — SERIAL
  • user_id — UUID — 외래 키 → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • amount — NUMERIC(18,2) — NOT NULL
  • payment_day — INT — NOT NULL
  • category — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL

mission_goal

  • id — SERIAL
  • child_id — UUID — 외래 키 → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • target_price — NUMERIC(18,2) — NOT NULL
  • deadline — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • snapshot_saved_amount — NUMERIC(18,2)
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

money_proverb

  • id — SERIAL
  • content — TEXT — NOT NULL
  • author — VARCHAR(200)
  • category — VARCHAR(50)

proverb_scrap

  • id — SERIAL
  • user_id — UUID — 외래 키 → user.id — NOT NULL
  • proverb_id — INT — 외래 키 → money_proverb.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

transaction

  • id — SERIAL
  • user_id — UUID — 외래 키 → user.id — NOT NULL
  • asset_id — INT — 외래 키 → asset.id
  • amount — NUMERIC(18,2) — NOT NULL
  • store_name — VARCHAR(200)
  • category — VARCHAR(20) — NOT NULL
  • category_middle — VARCHAR(20)
  • etc — VARCHAR(255)
  • is_confirmed — BOOLEAN — NOT NULL
  • importance — INT
  • memo — TEXT
  • ai_feedback — TEXT
  • is_fixed_expense — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • real_date — TIMESTAMP — NOT NULL

user

  • id — UUID
  • username — VARCHAR(150) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • role — VARCHAR(10) — NOT NULL
  • parent_id — UUID — 외래 키 → user.id
  • birth_date — DATE
  • is_verified — BOOLEAN — NOT NULL
  • allow_monitoring — BOOLEAN — NOT NULL
  • is_email_verified — BOOLEAN — NOT NULL
  • verification_token — VARCHAR(255)