stock-talk

Tables (6)

comment (댓글)

  • ID (댓긋ID) — LONG — Primary key — NOT NULL — AI
  • POST_ID (게시글ID) — LONG — Foreign key → posts.ID — NOT NULL
  • CONTENT (내용) — VARCHAR — NOT NULL
  • USER_ID (작성자ID) — VARCHAR — NOT NULL
  • LIKES (공감수) — LONG
  • DISLIKES (비공감수) — LONG
  • CREATED_AT (생성시간) — DATE — NOT NULL
  • UPDATED_AT (업데이트시간) — DATE

posts (게시판)

  • ID (게시글ID) — LONG — Primary key — NOT NULL — AI
  • TITLE (제목) — VARCHAR — NOT NULL
  • CONTENT (내용) — VARCHAR — NOT NULL
  • USER_ID (작성자ID) — VARCHAR — NOT NULL
  • STOCK_ID (종목ID) — VARCHAR — NOT NULL
  • VIEWS (조회수) — LONG
  • LIKES (공감수) — LONG
  • DISLIKES (비공감수) — LONG
  • CREATED_AT (생성시간) — DATE — NOT NULL
  • UPDATED_AT (업데이트시간) — DATE
  • STATUS (상태) — BIT — NOT NULL — 0: 비활성 1: 활성

price (주가)

  • ID (주가ID) — LONG — Primary key — NOT NULL — AI
  • STOCK_CODE (종목 CODE) — VARCHAR — NOT NULL — stock의 종목code랑 연결
  • DATE (날짜) — VARCHAR — NOT NULL
  • OPEN (시가) — LONG — NOT NULL
  • HIGH (고가) — LONG — NOT NULL
  • LOW (저가) — LONG — NOT NULL
  • CLOSE (종가) — LONG
  • VOLUME (거래량) — LONG
  • TOTALTRADE (거래금액) — LONG
  • PRICECHANGE (등락률) — LONG
  • CREATED_AT (수집시간) — DATE — NOT NULL

refresh_token (토큰)

  • ID (리프레쉬토큰ID) — LONG — Primary key — NOT NULL — AI
  • USER_ID (사용자ID) — LONG — Foreign key → users.ID — NOT NULL
  • TOKEN (토큰값) — VARCHAR — NOT NULL
  • EXPIRY (만료시간) — DATE — NOT NULL
  • CREATED_AT (생성시간) — DATE — NOT NULL
  • UPDATED_AT (업데이트시간) — DATE

stocks (종목)

  • ID (종목ID) — LONG — Primary key — NOT NULL — AI
  • NAME (종목이름) — VARCHAR — NOT NULL
  • CODE (종목코드) — VARCHAR — NOT NULL
  • CEO (대표자) — VARCHAR — NOT NULL
  • PLACE (지역) — VARCHAR — NOT NULL
  • MARKET_TYPE (시장종류) — BIT — NOT NULL — 0: 코스피 1: 코스닥
  • CREATED_AT (생성시간) — DATE — NOT NULL
  • UPDATED_AT (업데이트시간) — DATE
  • STATUS (상태) — BIT — NOT NULL — 0: 비활성 1: 활성

users (회원)

  • ID (사용자ID) — LONG — Primary key — NOT NULL — AI
  • NAME (이름) — VARCHAR — NOT NULL
  • EMAIL (이메일) — VARCHAR — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR — NOT NULL
  • ROLE (권한) — VARCHAR — NOT NULL
  • EMAIL_CHECK_TOKEN (이메일 인증 토큰) — VARCHAR — NOT NULL
  • EMAIL_VERIFIED (이메일 인증 유무) — BIT — NOT NULL — 0: 미인증 1: 인증
  • CREATED_AT (생성시간) — DATE — NOT NULL
  • UPDATED_AT (업데이트시간) — DATE
  • STATUS (상태) — BIT — NOT NULL — 0: 비활성 1: 활성