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