사자사자 가계부
테이블 (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)