시가총액 32조 ERD

코드스테이츠 메인 프로젝트

테이블 (9)

BOARD (Untitled2)

  • BOARD_ID (Key) — Long — 기본 키 — NOT NULL
  • MEMBER_ID (Key2) — Long — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • TITLE (Field) — String
  • CONTENT (Field2) — String
  • COMMENTLIST (Field4) — List<Comment>

BOOKMARK (Untitled3)

  • BOOKMARK_ID (Key) — Long — 기본 키 — NOT NULL
  • MEMBER_ID (Key2) — Long — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • STOCK_CODE (Field) — String
  • STOCK_NAME (Field2) — String

COMMENT (Untitled4)

  • COMMENT_ID (Key) — Long — 기본 키 — NOT NULL
  • BOARD_ID (Key2) — Long — 외래 키 → BOARD.BOARD_ID — NOT NULL
  • MEMBER_ID (Key22) — Long — 외래 키 → BOARD.MEMBER_ID — NOT NULL
  • MEMBER_ID (Key3) — Long — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • CONTENT (Field) — String

KOSDAQ_STOCK_INDEX (Untitled7)

  • ID (Key) — Long — 기본 키 — NOT NULL
  • BAS_DT (Field) — String
  • IDX_NM (Field2) — String
  • IDX_CSF (Field3) — String
  • EPY_ITMS_CNT (Field4) — String
  • CLPR (Field5) — String
  • VS (Field6) — String
  • FLT_RT (Field7) — String
  • MKP (Field8) — String
  • HIPR (Field9) — String
  • LOPR (Field10) — String
  • TRQU (Field11) — String
  • TR_PRC (Field12) — String
  • LSTG_MRKT_TOT_AMT (Field13) — String
  • LS_YR_ED_VS_FLT_RG (Field14) — String
  • LS_YR_ED_VS_FLT_RT (Field15) — String
  • YR_W_RCRD_HGST (Field16) — String
  • YR_W_RCRD_HGST_DT (Field17) — String
  • YR_W_RCRD_LWST (Field18) — String
  • YR_W_RCRD_LWST_DT (Field19) — String
  • BAS_PNTM (Field20) — String
  • BAS_IDX (Field21) — String

KOSDAQ_STOCK_LIST (Untitled9)

  • ID (Key) — Long — 기본 키 — NOT NULL
  • BAS_DT (Field) — String
  • SRTN_CD (Field2) — String
  • ISIN_CD (Field3) — String
  • ITMS_NM (Field4) — String
  • MRKT_CTG (Field5) — String
  • CLPR (Field6) — String
  • VS (Field7) — String
  • FLT_RT (Field8) — String
  • MKP (Field9) — String
  • HIPR (Field10) — String
  • LOPR (Field11) — String
  • TRQU (Field12) — String
  • TR_PRC (Field13) — String
  • LSTG_ST_CNT (Field14) — String
  • MRKT_TOT_AMT (Field15) — String

KOSPI_STOCK_INDEX (Untitled6)

  • ID (Key) — Long — 기본 키 — NOT NULL
  • BAS_DT (Field) — String
  • IDX_NM (Field2) — String
  • IDX_CSF (Field3) — String
  • EPY_ITMS_CNT (Field4) — String
  • CLPR (Field5) — String
  • VS (Field6) — String
  • FLT_RT (Field7) — String
  • MKP (Field8) — String
  • HIPR (Field9) — String
  • LOPR (Field10) — String
  • TRQU (Field11) — String
  • TR_PRC (Field12) — String
  • LSTG_MRKT_TOT_AMT (Field13) — String
  • LS_YR_ED_VS_FLT_RG (Field14) — String
  • LS_YR_ED_VS_FLT_RT (Field15) — String
  • YR_W_RCRD_HGST (Field16) — String
  • YR_W_RCRD_HGST_DT (Field17) — String
  • YR_W_RCRD_LWST (Field18) — String
  • YR_W_RCRD_LWST_DT (Field19) — String
  • BAS_PNTM (Field20) — String
  • BAS_IDX (Field21) — String

KOSPI_STOCK_LIST (Untitled8)

  • ID (Key) — Long — 기본 키 — NOT NULL
  • BAS_DT (Field) — String
  • SRTN_CD (Field2) — String
  • ISIN_CD (Field3) — String
  • ITMS_NM (Field4) — String
  • MRKT_CTG (Field5) — String
  • CLPR (Field6) — String
  • VS (Field7) — String
  • FLT_RT (Field8) — String
  • MKP (Field9) — String
  • HIPR (Field10) — String
  • LOPR (Field11) — String
  • TRQU (Field12) — String
  • TR_PRC (Field13) — String
  • LSTG_ST_CNT (Field14) — String
  • MRKT_TOT_AMT (Field15) — String

MEMBER (Untitled)

  • MEMBER_ID (Key) — Long — 기본 키 — NOT NULL
  • USERNAME (Field2) — String
  • PASSWORD (Field) — String
  • NICKNAME (Field3) — String
  • EMAIL (Field4) — String
  • MONEY (Field5) — BigDecimal
  • COMMENTLIST (Field6) — List<Comment>
  • BOARDLIST (Field7) — List<Board>
  • ROLES (Field8) — List<String>
  • BOOKMARKS (Field9) — List<Bookmark>
  • TRADES (Field10) — List<Trade>

TRADE (Untitled5)

  • TRADE_ID (Key) — Long — 기본 키 — NOT NULL
  • MEMBER_ID (Key2) — Long — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • STOCK_CODE (Field) — String
  • STOCK_NAME (Field2) — String
  • PRICE (Field3) — BigDecimal
  • QUANTITY (Field4) — Long
  • TRADE_TYPE (Field5) — String
  • TOTAL_PRICE (Field6) — BigDecimal
  • TOTAL_STOCK_HOLDINGS (Field7) — Long