expense-manager-erd-enhanced

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