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)