bobo(budget oh)

Tables (3)

budgets

  • id — BIGINT — Primary key — NOT NULL — 식별자
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — 식별자
  • category — VARCHAR(50)
  • amount — INT — NOT NULL — 예산 금액
  • yearmonth — VARCHAR(50)

expenses

  • id — BIGINT — Primary key — NOT NULL — 식별자
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — 식별자
  • category — VARCHAR(50)
  • amount — INT — NOT NULL — 지출 금액
  • memo — VARCHAR(255) — NOT NULL — 년
  • date — VARCHAR(50) — NOT NULL — 지출일시
  • is_exclude — TINYINT — NOT NULL — 합계제외

users

  • id — BIGINT — Primary key — NOT NULL — 식별자
  • username — VARCHAR(50) — NOT NULL — 계정
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • url (web hook url) — VARCHAR(255)