복식부기 가계부
테이블 (11)
Untitled (TransactionParty)
- Key (id) — 기본 키 — NOT NULL
- Field (name)
- Field (createdAt)
- Field (updatedAt)
- (userId) — CHAR — 외래 키 → 사용자.id — NOT NULL
Untitled (Account)
- Key (id) — 기본 키 — NOT NULL
- Field (name)
- Field (debitOrCredit)
- Field (accountType)
- Field (isActive)
- Field (createdAt)
- Field (updatedAt)
- (userId) — CHAR — 외래 키 → 사용자.id — NOT NULL
- Key (parentId) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AccountBalance)
- Key (fiscalYear) — 기본 키 — NOT NULL
- Key (accountId) — 외래 키 → Untitled.Key — NOT NULL
- Field (balance)
- Field (createdAt)
- Field (updatedAt)
Untitled (Transaction)
- Key (id) — 기본 키 — NOT NULL
- (userId) — CHAR — 외래 키 → 사용자.id — NOT NULL
- Key (debitAccountId) — 외래 키 → Untitled.Key — NOT NULL
- Key (creditAccountId) — 외래 키 → Untitled.Key — NOT NULL
- Field (date)
- Field (amount)
- Field (where)
- Key (transactionPartyId) — 외래 키 → Untitled.Key — NOT NULL
- Field (description)
- Field (includeSimulation)
- Field (createdAt)
- Field (updatedAt)
Untitled (Tag)
- Key (id) — 기본 키 — NOT NULL
- (userId) — CHAR — 외래 키 → 사용자.id — NOT NULL
- Field (name)
- Field (category)
- Key (parentId) — 외래 키 → Untitled.Key — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (isActive)
Untitled (TransactionTag)
- Key (id) — 기본 키 — NOT NULL
- Key (transactionId) — 외래 키 → Untitled.Key — NOT NULL
- Key (tagId) — 외래 키 → Untitled.Key — NOT NULL
- Field (createdAt)
- Field (updatedAt)
Untitled (Budget)
- Key (id) — 기본 키 — NOT NULL
- Key (tagId) — 외래 키 → Untitled.Key — NOT NULL
- Field (startDate)
- Field (endDate)
- Field (amount)
- Field (createdAt)
- Field (updatedAt)
Untitled (ProfitTarget)
- Key (id) — 기본 키 — NOT NULL
- Key (tagId) — 외래 키 → Untitled.Key — NOT NULL
- Field (startDate)
- Field (endDate)
- Field (amount)
- Field (createdAt)
- Field (updatedAt)
Untitled (FixedTransaction)
- Key (id) — 기본 키 — NOT NULL
- (userId) — CHAR — 외래 키 → 사용자.id — NOT NULL
- Key (debitAccountId) — 외래 키 → Untitled.Key — NOT NULL
- Key (creditAccountId) — 외래 키 → Untitled.Key — NOT NULL
- Field (where)
- Key (transactionPartyId) — 외래 키 → Untitled.Key — NOT NULL
- Field (description)
- Field (includeSimulation)
- Field (createdAt)
- Field (updatedAt)
- Field (startDate)
- Field (endDate)
- Field (cycle)
- Field (frequencyMultiplier)
Untitled (FixedTransactionTag)
- Key (id) — 기본 키 — NOT NULL
- Key (fixedTransactionTagId) — 외래 키 → Untitled.Key — NOT NULL
- Key (tagId) — 외래 키 → Untitled.Key — NOT NULL
- Field (createdAt)
- Field (updatedAt)
사용자 (User)
- (id) — CHAR — 기본 키 — NOT NULL
- Field (password)
- Field (salt)
- Field (createdAt)
- Field (updatedAt)