household account book
Tables (5)
accounts
- id — INT
- user_id — INT — NOT NULL
- account_name — VARCHAR(255) — NOT NULL
- account_number — VARCHAR(255) — NOT NULL
- bank_code — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- is_primary — TINYINT(1) — NOT NULL
analysis
- id — INT
- user_id — INT — NOT NULL
- is_income — TINYINT(1) — NOT NULL
- period — VARCHAR(20) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- description — TEXT
- result_image — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notifications
- id — INT
- user_id — INT — NOT NULL
- message — TEXT — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
transaction_history
- id — INT
- account_id — INT — NOT NULL
- amount — INT — NOT NULL
- balance — INT — NOT NULL
- description — VARCHAR(255)
- is_deposit — TINYINT(1) — NOT NULL
- transaction_type — VARCHAR(20) — NOT NULL
- transacted_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone_num — VARCHAR(20)
- last_login — DATETIME
- is_staff — TINYINT(1) — NOT NULL
- is_active — TINYINT(1) — NOT NULL