복식부기 가계부

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