Flow

Tables (6)

Bank (은행)

  • bankIdx (Key) — Primary key — NOT NULL
  • userIdx (Key2) — Foreign key → User.userIdx — NOT NULL
  • name (Field)
  • form (Field2)

Category (카테고리)

  • categoryIdx (Key) — Primary key — NOT NULL
  • userIdx (Key2) — Foreign key → User.userIdx — NOT NULL
  • name (Field)
  • icon (Field2)
  • class (Field3)
  • income (Field4)
  • expenses (Field5)

Date (날짜 별 수입, 지출)

  • dateIdx (Key) — Primary key — NOT NULL
  • monthIdx (Key2) — Foreign key → Month.monthIdx — NOT NULL
  • userIdx (Key22) — Foreign key → Month.userIdx — NOT NULL
  • date (Field)
  • income (Field2)
  • expenses (Field3)

Detail (내역)

  • detailId (Key) — Primary key — NOT NULL
  • categoryIdx (Key3) — Foreign key → Category.categoryIdx — NOT NULL
  • userIdx (Key22) — Foreign key → Category.userIdx — NOT NULL
  • dateIdx (Key2) — Foreign key → Date.dateIdx — NOT NULL
  • monthIdx (Key23) — Foreign key → Date.monthIdx — NOT NULL
  • userIdx (Key222) — Foreign key → Date.userIdx — NOT NULL
  • title (Field)
  • price (Field3)
  • memo (Field4)
  • class (수입/지출)
  • include (수입/지출 포함 여부)

Month (월 별 수입, 지출)

  • monthIdx (Key) — Primary key — NOT NULL
  • userIdx (Key2) — Foreign key → User.userIdx — NOT NULL
  • month (Field)
  • income (Field2)
  • expenses (Field3)

User (사용자 정보)

  • userIdx (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • createdAt (Field4)
  • updatedAt (Field5)
  • status (Field6)
  • message (Field3)
  • budget (Field8)
  • budgetAgree (Field9)
  • budgetPercent (Field10)
  • categoryAgree (Field11)
  • fingerPrintAgree (Field13)