mini-project

Tables (3)

Member (회원)

  • memberPk (member_pk) — Long — Primary key — NOT NULL
  • memberId (member_id) — String
  • memberName (member_name) — String
  • memberPw (member_pw) — String
  • tqqqQuantity (tqqq_quantity) — int
  • sqqqQuantity (sqqq_quantity) — int
  • cash — double

stock (주식)

  • stockPk (stock_pk) — Long — Primary key — NOT NULL
  • stockName (stock_name) — String

stock_price (주식 가격)

  • stockPricePk (stock_price_pk) — Long — Primary key — NOT NULL
  • stockId (stock_id) — Long — Foreign key → stock.stockPk — NOT NULL
  • price — int