Account

Tables (3)

Account (계좌 관리)

  • ACCOUNT_ID (계좌 식별자) — INT — Primary key — NOT NULL
  • BANK_NAME (은행명) — VARCHAR(50)
  • ACCOUNT_NUMBER (계좌번호) — VARCHAR(50)
  • BALANCE (잔액) — INT

EXPENSE (지출 내역)

  • EXPENSE_ID (지출 식별자) — INT — Primary key — NOT NULL
  • ACCOUNT_ID (계좌 식별자) — INT — Foreign key → Account.ACCOUNT_ID — NOT NULL
  • EXPENSE_TYPE (지출 유형) — VARCHAR(50)
  • AMOUNT (지출 금액) — INT
  • EXPENSE_DATE (지출 일자) — DATE
  • DESCRIPTION (지출 상세) — VARCHAR(200)

TRANSACTION_HISTORY (거래 내역)

  • TRANSACTION_ID (거래 식별자) — INT — Primary key — NOT NULL
  • ACCOUNT_ID (계좌 식별자) — INT — Foreign key → Account.ACCOUNT_ID — NOT NULL
  • TX_TYPE (거래 유형) — VARCHAR(20)
  • AMOUNT (거래 금액) — INT
  • TX_DATE (거래 일시) — DATETIME
  • DESCRIPTION (적요) — VARCHAR(200)