가계부

테이블 (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