ERD
Tables (5)
Category (Untitled2)
- category_id (Key) — BigInt — Primary key — NOT NULL
- name (Field) — varchar
- Field2
User (Untitled)
- user_id (Key) — BigInt — Primary key — NOT NULL
- username (사용자 이름) — varchar
- password (비밀번호) — varchar
- phone (전화번호) — varchar
- createdAt (가입일자) — DateTime
- user_role (사용자 역할) — varchar
- Field
budget (Untitled4)
- budget_id (사용자 예산 식별자) — BigInt — Primary key — NOT NULL
- user_id (사용자 식별자) — BigInt — Foreign key → User.user_id — NOT NULL
- category_id (Key) — BigInt — Foreign key → Category.category_id — NOT NULL
- date (년 월) — Date
- amount (예산) — int
expenditure (Untitled5)
- expenditure _id (지출 식별자) — BigInt — Primary key — NOT NULL
- user_id (사용자 식별자) — BigInt — Foreign key → User.user_id — NOT NULL
- category_id (Key) — BigInt — Foreign key → Category.category_id — NOT NULL
- data (지출 일자) — DateTime
- amount (지출 금액) — Int
- memo (메모) — varchar
- banned_expenditure (boolean) — varhar
total_budget (전체 예산)
- total_budget_id (전체 지출 식별자) — BigInt — Primary key — NOT NULL
- category_id (Key) — BigInt — Foreign key → Category.category_id — NOT NULL
- total_budget (전체 지출) — BigInt
- Field2