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