10mindaily

Tables (17)

ANSWER (answer)

  • 아이디 (ID) — INT — Primary key — NOT NULL
  • Field (CONTENT) — TEXT — NOT NULL
  • Field2 (CREATE_DATE) — DATETIME — NOT NULL
  • Field (MODIFY_DATE) — DATETIME
  • Field (AUTHOR_ID) — BIGINT — NOT NULL
  • Field (QUESTION_ID) — INT — NOT NULL
  • 아이디 (ID2) — INT — Foreign key → question.아이디 — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

ANSWER_VOTE (answer_vote)

  • 추천인id (VOTER_ID) — BIGINT — Primary key — NOT NULL
  • 답변ID (ANSWER_ID) — INT — Primary key — NOT NULL
  • 아이디 (ID2) — INT — Foreign key → ANSWER.아이디 — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

LIKEMAPPING

  • Key (ID) — INT — Primary key — NOT NULL
  • Field (USERID) — INT — NOT NULL
  • Field2 (STOCKID) — INT — NOT NULL
  • Field3 (COINID) — INT — NOT NULL
  • Field4 (REALESTATE) — INT — NOT NULL
  • Field (MUSIC) — INT — NOT NULL
  • Field (RESELLID) — INT — NOT NULL
  • Field (ARTID) — INT — NOT NULL
  • Field (APP) — INT — NOT NULL
  • Field (HOBBY) — INT — NOT NULL
  • Field (SNSID) — INT — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

Member (user)

  • 회원ID (userID) — INT(20) — Primary key — NOT NULL — Comment
  • 이름 (username) — varchar — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 이메일 (email) — text — NOT NULL
  • 소셜타입 (provider) — varchar — NOT NULL
  • 이메일인증여부 (emailVerified) — Boolean — NOT NULL
  • 닉네임 (nickname) — varchar — NOT NULL
  • 유저유형 (role) — varchar — NOT NULL
  • 생성일 (createDate) — DATETIME — NOT NULL
  • 수정일 (modifyDate) — DATETIME

QUESTION_VOTE (question_vote)

  • 추천인id (QUESTION_ID) — INT — Primary key — NOT NULL
  • 답변ID (VOTER_ID) — BIGINT — Primary key — NOT NULL
  • 아이디 (ID2) — INT — Foreign key → question.아이디 — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

app (APP)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME — VARCHAR — NOT NULL
  • TYPE (PRICE) — VARCHAR — NOT NULL
  • PRICE (INFO) — INT — NOT NULL
  • DESCRIPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

art (ART)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (PAINTER) — VARCHAR — NOT NULL
  • PAINTER (PRICE) — VARCHAR — NOT NULL
  • PRICE (INFO) — INT — NOT NULL
  • DECSRIPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

category (CATEGORY)

  • 추천인id (ID) — INT — Primary key — NOT NULL
  • 답변ID (CATEGORY_NAME) — VARCHAR — Primary key — NOT NULL

chat (CHAT)

  • CHATID (ID) — INT — Primary key — NOT NULL
  • FROMID (CREATEDATE) — VARCHAR — NOT NULL
  • TOID (AUTHORNAME) — VARCHAR — NOT NULL
  • CHATCONTENT (CONTENT) — VARCHAR — NOT NULL
  • CHATTIME (ISREAD) — DATETIME — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

coin (COIN)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (PREVIOUSCLOSE) — VARCHAR — NOT NULL
  • PRICE (OPEN) — INT — NOT NULL
  • OPTION (DIVIDENRATE) — VARCHAR — NOT NULL
  • DESCRIPTION (DIVIDEND_YIELD) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

comment (COMMENT)

  • 아이디 (ID) — INT — Primary key — NOT NULL
  • Field (CONTENT) — TEXT — NOT NULL
  • Field2 (CREATE_DATE) — DATETIME — NOT NULL
  • Field (MODIFY_DATE) — DATETIME
  • Field (ANSWER_ID) — INT — NOT NULL
  • Field (AUTHOR_ID) — BIGINT — NOT NULL
  • Field (QUESTION_ID) — INT — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

hobby (HOBBY)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (PAINTER) — VARCHAR — NOT NULL
  • TYPE (PRICE) — VARCHAR — NOT NULL
  • PRICE (INFO) — INT — NOT NULL
  • DESCRIPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

music (MUSIC)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (SINGER) — VARCHAR — NOT NULL
  • SINGER (PRICE) — VARCHAR — NOT NULL
  • PRICE (INFO) — INT — NOT NULL
  • DESCRIPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

question (QUESTION)

  • 아이디 (ID) — INT — Primary key — NOT NULL
  • Field (CONTENT) — TEXT — NOT NULL
  • Field2 (CREATE_DATE) — DATETIME — NOT NULL
  • Field (MODIFY_DATE) — DATETIME
  • Field (SUBJECT) — VARCHAR — NOT NULL
  • 추천인id (ID2) — INT — Foreign key → category.추천인id — NOT NULL
  • 답변ID (CATEGORY_NAME) — VARCHAR — Foreign key → category.답변ID — NOT NULL
  • 회원ID (userID) — INT(20) — Foreign key → Member.회원ID — NOT NULL — Comment

realestate (REALESTATE)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (LOCATE) — VARCHAR — NOT NULL
  • PRICE — INT — NOT NULL
  • LOCATE (INFO) — VARCHAR — NOT NULL
  • OPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL
  • DESCRIPTION (Field)

resell (RESELL)

  • Key (ID) — INT — Primary key — NOT NULL
  • NAME (PRODUCT_NAME) — VARCHAR — NOT NULL
  • OPTION (PRICE) — VARCHAR — NOT NULL
  • PRICE (INFO) — INT — NOT NULL
  • DESCRIPTION (CATEGORY) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL

stock (STOCK)

  • ID — BIGINT — Primary key — NOT NULL
  • CREATEDATE (PREVIOUSCLOSE) — DATETIME — NOT NULL
  • SYMBOL (OPEN) — VARCHAR — NOT NULL
  • PREVIOUSCLOSE (Field) — VARCHAR — NOT NULL
  • OPEN (Field2) — VARCHAR — NOT NULL
  • DIVIDENRATE — VARCHAR
  • DIVIDENYIELD (DIVIDEND_YIELD) — VARCHAR
  • EXDIVIDENDATE — VARCHAR
  • MARKETCAP — VARCHAR — NOT NULL
  • FORWARDPE — VARCHAR — NOT NULL
  • FIFTYTWOWEEKLOW (TRAILINGPE) — VARCHAR — NOT NULL
  • FIFTYWHOWEEKHIGH (Field3) — VARCHAR — NOT NULL
  • FIFTYDAYAVERAGE (Field4) — VARCHAR — NOT NULL
  • PRICETOSALETRAILING12MINTHS (Field5) — VARCHAR — NOT NULL
  • TWOHUNDREDDAYAVERAGE (Field6) — VARCHAR — NOT NULL
  • Key (ID2) — INT — Foreign key → LIKEMAPPING.Key — NOT NULL