more-joeun-bank
Tables (4)
Account (계좌)
- ID (Key) — BIGINT — Primary key — NOT NULL
- USER_ID (Key2) — BIGINT — Foreign key → User.ID — NOT NULL
- NAME (Field) — STRING
- BALANCE (Field2) — BIGINT
- INTEREST_RATE (Field3) — DOUBLE
- ACCOUNT_NUMBER (Field6) — STRING
Interest_History (이자 지금받기 한 내역)
- ID (Key) — BIGINT — Primary key — NOT NULL
- ACCOUNT_ID (Key2) — BIGINT — Foreign key → Account.USER_ID — NOT NULL
- IH_DATE (Field) — DATE
- IH_AMOUNT (Field2) — DOUBLE
Transaction_History (계좌 상세 내역)
- ID (Key) — BIGINT — Primary key — NOT NULL
- ACCOUNT_ID (Key2) — BIGINT — Foreign key → Account.ID — NOT NULL
- AMOUNT (Field) — INT
- TRANSCTION_NAME (Field2) — STRING
- TRANSACTION_DATE (Field3) — DATE
- TARGET_ACCOUNT_NUMBER (Field4) — STRING
- TRANSACTION_TYPE (Field5) — STRING
User (사용자)
- ID (Key) — BIGINT — Primary key — NOT NULL
- USERNAME (Field) — STRING