Budget
Tables (5)
AuditLog
- id — INT
- table_name — VARCHAR(255) — NOT NULL
- operation — ENUM('INSERT', 'UPDATE', 'DELETE') — NOT NULL
- changed_by_user_id — INT
- changed_data — TEXT
- timestamp — TIMESTAMP
Budget
- id — INT
- user_id — INT — Foreign key → User.id — NOT NULL
- category_id — INT — Foreign key → Category.id — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- month — DATE — NOT NULL
Category
- id — INT
- name — VARCHAR(255) — NOT NULL
Expense
- id — INT
- user_id — INT — Foreign key → User.id — NOT NULL
- category_id — INT — Foreign key → Category.id — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- date — DATE — NOT NULL
- note — VARCHAR(255)
User
- id — INT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL