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: 활성