budget-manager
Tables (9)
Copy Of Untitled (stats_spd_month)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL — INDEX
- id (cat_id) — BIGINT — Foreign key → category.id — NOT NULL
- Field (date) — DATE — NOT NULL — INDEX
- Field (sum) — BIGINT — NOT NULL
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
Copy Of spending (outbox_spending_stats)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (type) — VARCHAR(255) — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL
- id (cat_id) — BIGINT — Foreign key → category.id — NOT NULL
- date — DATE
- amount — INT
Untitled (budget_detail)
- bg_id — BIGINT — Foreign key → budget.id — NOT NULL
- cat_id — BIGINT — Foreign key → category.id — NOT NULL
- Field (amount) — BIGINT — NOT NULL
Untitled (stats_spd_day)
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL — INDEX
- id (cat_id) — BIGINT — Foreign key → category.id — NOT NULL
- Field (date) — DATE — NOT NULL — INDEX
- Field (sum) — BIGINT — NOT NULL
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
Untitled (stats_budget_detail_average)
- id (cat_id) — BIGINT — Foreign key → category.id — NOT NULL
- Field (percentage) — INT — NOT NULL
- Field (created_at) — DATETIME
- Field2 (updated_at) — DATETIME
budget
- id — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL — INDEX
- start (date) — DATE — NOT NULL
- Field (deleted) — TINYINT(1) — NOT NULL — default '0'
category
- id — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
spending
- Key (id) — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL — INDEX
- id (cat_id) — BIGINT — Foreign key → category.id — NOT NULL
- date — DATE
- amount — INT
- memo — VARCHAR(255)
- Field (excluded) — TINYINT(1) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL — UNIQUE
- password — VARCHAR(255) — NOT NULL
- account — VARCHAR(255) — NOT NULL
- user_role — VARCHAR(255) — NOT NULL
- deleted — TINYINT(1) — NOT NULL — default '0'
- created_at — DATETIME
- updated_at — DATETIME