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)