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)