bankbank

Tables (5)

Account (계좌)

  • ID (인덱스) — int — Primary key — NOT NULL
  • userId (유저ID) — int — Foreign key → User.ID — NOT NULL
  • Field

Card (카드)

  • ID (인덱스) — int — Primary key — NOT NULL
  • userId (유저ID) — int — Foreign key → User.ID — NOT NULL
  • name (카드이름) — VARCHAR(255)
  • Field

CardTradeHistory (카드거래내역)

  • ID (인덱스) — int — Primary key — NOT NULL
  • cardId (카드ID) — int — Foreign key → Card.ID — NOT NULL
  • price (금액) — int
  • TradeDate (거래일자) — LocalDateTime
  • type (분류) — VARCHAR(255)
  • Field

TradeHistory (거래내역)

  • ID (인덱스) — int — Primary key — NOT NULL
  • accountId (계좌ID) — int — Foreign key → Account.ID — NOT NULL
  • type (거래형태) — VARCHAR(10)
  • price (금액) — int
  • tradeDate (거래일자) — LocalDateTime
  • Field

User (사용자)

  • ID (인덱스) — int — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255)
  • name (이름) — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • Field