numble_toss
Tables (8)
Account (계좌)
- account_id (id) — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
- bank_name (bank) — String
- account_number — String
- balance — Long
Reservation (예약 결제)
- rsv_id (id) — bigint(20) — Primary key — NOT NULL
- account_id — bigint(20) — Foreign key → Account.account_id — NOT NULL
- price — bigint(20)
- sendAt — String
Stock (주식)
- stock_id (id) — bigint(20) — Primary key — NOT NULL
- name — String
- price (nickname) — Long
Stock_Detail (주식 가격 기록)
- stock_detail_id (Key) — bigint(20) — Primary key — NOT NULL
- stock_id (id) — bigint(20) — Foreign key → Stock.stock_id — NOT NULL
- price — Long
- createdAt — String
- stock_name — String
Token (토큰)
- token_id (id) — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
- token — String
- expired — boolean
- revoked — boolean
- token_type — String
Transaction (계좌 사용내역)
- id — bigint(20) — Primary key — NOT NULL
- account_id — bigint(20) — Foreign key → Account.account_id — NOT NULL
- user_id — bigint(20) — Foreign key → Account.user_id — NOT NULL
- type — String
- amount — bigint(20)
- balance — bigint(20)
- createdAt — String
- receiver — String
- senders (sender) — String
User (회원정보)
- user_id (id) — bigint(20) — Primary key — NOT NULL
- name — String
- nickname — String
- birthDay — String
- password — String
- role — String
User_Stock (보유주식)
- stock_holdings_id (id) — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
- stock_count — bigint(20)
- stock_name — String
- average_price — bigint(20)