시가총액 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