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