moneyTracker

Tables (8)

Account (결제수단)

  • Key (AccountId) — Primary key — NOT NULL
  • Name (Field)
  • Type (Field2)
  • IsActive (Field3) — Boolean
  • createdAt (Field4) — TIMESTAMP
  • Field5

Budget (월/주 단위)

  • BudgetId (Key) — Primary key — NOT NULL
  • Period (Field)
  • Amount (Field2)
  • categoryId (Key2) — Foreign key → Category.categoryId — NOT NULL

Category (카테고리)

  • categoryId (Key) — Primary key — NOT NULL
  • Name (Field)
  • kind (Field2)
  • ParentCategoryID (Field3)
  • IsActive (Field4)

Tag (태그)

  • TagId (Key) — Primary key — NOT NULL
  • Name (Field)

TransactionTag (트랜잭션 태그)

  • TransactionId (Key) — Primary key — NOT NULL
  • Field
  • TagId (Key3) — Foreign key → Tag.TagId — NOT NULL
  • TransactionId (Key4) — Foreign key → Transactions.TransactionId — NOT NULL

Transactions (거래)

  • TransactionId (Key) — Primary key — NOT NULL
  • Field
  • Key (AccountId) — Foreign key → Account.Key — NOT NULL
  • categoryId (Key2) — Foreign key → Category.categoryId — NOT NULL

TransferLink (이체 연결)

  • Field
  • TransactionId (Key2) — Foreign key → Transactions.TransactionId — NOT NULL

index (인덱스)

  • indexId (Key) — Primary key — NOT NULL
  • Field