가계부
테이블 (5)
Accounts (account)
- Account id (account_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
- User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
- Account Number (account_number) — VARCHAR(20)
- Bank Code (bank_code) — VARCHAR(10)
- Account Type (account_type) — VARCHAR(20)
- Balance (balance) — DECIMAL(18, 2)
Analysis (analysis)
- Analysis id (analysis_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
- User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
- Analysis Target (analysis_target) — VARCHAR(10)
- Analysis Period (analysis_period) — VARCHAR(20)
- Start Date (start_date) — DATE
- End Date (end_date) — DATE
- Description (description) — TEXT
- Created At (created_at) — TIMESTAMP
- Updated At (updated_at) — TIMESTAMP
- Image (image) — VARCHAR(255)
Notifications (notifications)
- Notifications id (notifications_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
- User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
- Message (message) — TEXT
- Is Read (is_read) — BOOLEAN
- Created At (created_at) — TIMESTAMP
Transaction History (transaction_history)
- Transaction id (transaction_id) — AUTO_INCREMENT — 기본 키
- Account id (account_id) — AUTO_INCREMENT — 외래 키 → Accounts.Account id — NOT NULL
- Transaction Amount (transaction_amount) — DECIMAL(18, 2) — NOT NULL
- Post Transaction Balance (post_transaction_balance) — DECIMAL(18, 2)
- Transaction Details (transaction_details) — VARCHAR(100)
- Transaction Type (transaction_type) — VARCHAR(10)
- Transaction Method (transaction_method) — VARCHAR(10)
- Transaction Date (transaction_date) — TIMESTAMP
Users (users)
- User ID (user_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
- Email (email) — VARCHAR(100)
- Password (password) — VARCHAR(20)
- Name (name) — VARCHAR(50)
- Nickname (nickname) — VARCHAR(50)
- Phone Number (phone_number) — VARCHAR(20)
- Last Login (last_login) — TIMESTAMP
- Is Staff (is_staff) — BOOLEAN
- Is Admin (is_admin) — BOOLEAN
- Is Active (is_active) — BOOLEAN