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