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