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