Where'sMyMoney

Tables (8)

budget_category

  • id — varchar(12) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL

discord_service_type

  • id — varchar(20) — Primary key — NOT NULL
  • description — varchar(50)

id_sequence

  • id — varchar(6) — Primary key — NOT NULL — 시퀀스 id
  • no — int — NOT NULL — 시퀀스 no

user

  • id — varchar(30) — Primary key — NOT NULL
  • username — varchar(20) — NOT NULL
  • password — varchar(100) — NOT NULL
  • created_dt — datetime — NOT NULL
  • updated_dt — datetime — NOT NULL

user_budget

  • id — varchar(30) — Primary key — NOT NULL
  • user_id — varchar(30) — Foreign key → user.id — NOT NULL
  • budget — decimal(18,4)
  • acc_spend — decimal(18,4)
  • period_start — date — NOT NULL
  • period_end — date — NOT NULL
  • created_dt — datetime — NOT NULL
  • updated_dt — datetime — NOT NULL

user_budget_category

  • id — varchar(30) — Primary key — NOT NULL
  • user_budget_id — varchar(30) — Foreign key → user_budget.id — NOT NULL
  • budget_category_id — varchar(12) — NOT NULL
  • budget — decimal(18,4)
  • budget_per — decimal(18,4)
  • acc_spend — decimal(18,4)
  • created_dt — datetime — NOT NULL
  • updated_dt — datetime — NOT NULL

user_discord_service

  • user_id — varchar(30) — Primary key — NOT NULL
  • service_id — varchar(20) — Primary key — NOT NULL
  • discord_url — varchar(255) — NOT NULL
  • created_dt — datetime
  • updated_dt — datetime

user_spend_history

  • id — varchar(30) — Primary key — NOT NULL
  • user_budget_category_id — varchar(30) — Foreign key → user_budget_category.id — NOT NULL
  • spend_amount — decimal(18,4)
  • description — varchar(50)
  • spend_date — date — NOT NULL
  • is_sum — tinyint
  • created_dt — datetime
  • updated_dt — datetime