가계부
테이블 (8)
Budgets
- Id — INTEGER — 기본 키 — NOT NULL
- CategoryParentName — TEXT — NOT NULL
- MonthlyExtra — TEXT — NOT NULL
Categories
- Id — INTEGER — 기본 키 — NOT NULL
- ParentName — TEXT — NOT NULL
- Name — TEXT — NOT NULL
Entries
- Id — TEXT — 기본 키 — NOT NULL
- UserId — TEXT
- Date — TEXT — NOT NULL
- CategoryId — INTEGER — 외래 키 → Categories.Id — NOT NULL
- PayerId — INTEGER — 외래 키 → Payers.Id — NOT NULL
- PaymentMethodId — INTEGER — 외래 키 → PaymentMethods.Id — NOT NULL
- Content — TEXT — NOT NULL
- Memo — TEXT
- Amount — TEXT — NOT NULL
- ReceiptUrl — TEXT
- CreatedAt — TEXT — NOT NULL
FixedItems
- Id — INTEGER — 기본 키 — NOT NULL
- GroupType — TEXT — NOT NULL
- Owner — TEXT — NOT NULL
- Name — TEXT — NOT NULL
- PaymentNote — TEXT
- CategoryId — INTEGER — 외래 키 → Categories.Id — NOT NULL
- Amount — TEXT — NOT NULL
- Memo — TEXT
Installments
- Id — INTEGER — 기본 키 — NOT NULL
- Name — TEXT — NOT NULL
- Card — TEXT — NOT NULL
- TotalAmount — TEXT — NOT NULL
- Months — INTEGER — NOT NULL
- LastPayDate — TEXT — NOT NULL
MonthlyFixedActuals
- Id — INTEGER — 기본 키 — NOT NULL
- FixedItemId — INTEGER — 외래 키 → FixedItems.Id — NOT NULL
- Year — INTEGER — NOT NULL
- Month — INTEGER — NOT NULL
- ActualAmount — TEXT — NOT NULL
Payers
- Id — INTEGER — 기본 키 — NOT NULL
- Name — TEXT — NOT NULL
PaymentMethods
- Id — INTEGER — 기본 키 — NOT NULL
- Name — TEXT — NOT NULL