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)