NLP
Tables (8)
article (article table)
- article_Index (PK) — VARCHAR(768) — Primary key — NOT NULL
- date (INDEX) — DATETIME — Primary key — NOT NULL
- title (Field1) — VARCHAR(100)
- comp (Field2) — VARCHAR(20)
- editor (Field3) — VARCHAR(20)
- body (Field4) — TEXT
- special_deleted (Field5) — TEXT
- Okt_pos (Field6) — TEXT
- stopwords_deleted (Field7) — TEXT
- noun (Field8) — TEXT
- n_v_adj_ad (Field9) — TEXT
emot (emot table)
- article_Index (PK) — VARCHAR(768) — Primary key — NOT NULL
- article_Index (FK) — VARCHAR(768) — Foreign key → article.article_Index — NOT NULL
- likes (Field1) — INT
- warm (Field2) — INT
- sad (Field3) — INT
- mad (Field4) — INT
- want (Field5) — INT
keyword_naver (keyword_naver table)
- article_Index (PK) — VARCHAR(768) — Primary key — NOT NULL
- article_Index (FK) — VARCHAR(768) — Foreign key → article.date — NOT NULL
- MJI (Field1) — Boolean
- YSY (Field2) — Boolean
- LNY (Field3) — Boolean
- LJM (Field4) — Boolean
- HJP (Field5) — Boolean
- HKA (Field6) — Boolean
keyword_naver_reply (keyword_naver_reply table)
- reply_Index (PK) — INT — Primary key — NOT NULL
- reply_Index (FK1) — INT — Foreign key → reply.reply_Index — NOT NULL
- article_Index (FK2) — VARCHAR(768) — Foreign key → reply.article_Index — NOT NULL
- MJI (Field1) — Boolean
- YSY (Field2) — Boolean
- LNY (Field3) — Boolean
- LJM (Field4) — Boolean
- HJP (Field5) — Boolean
- HKA (Field6) — Boolean
keyword_twit (keyword_twit table)
- twit_Index (PK) — VARCHAR(20) — Primary key — NOT NULL
- twit_Index (FK) — VARCHAR(20) — Foreign key → twit.twit_Index — NOT NULL
- MJI (Field1) — Boolean
- YSY (Field2) — Boolean
- LNY (Field3) — Boolean
- LJM (Field4) — Boolean
- HJP (Field5) — Boolean
- HKA (Field6) — Boolean
reply (reply table)
- reply_Index (PK) — INT — Primary key — NOT NULL
- date (INDEX) — DATETIME — Primary key — NOT NULL
- article_Index (FK) — VARCHAR(768) — Foreign key → article.article_Index — NOT NULL
- body (Field4) — TEXT
- special_deleted (Field5) — TEXT
- Okt_pos (Field6) — TEXT
- stopwords_deleted (Field7) — TEXT
- noun (Field8) — TEXT
- n_v_adj_ad (Field9) — TEXT
retwit (retwit table)
- origin_id (PK) — VARCHAR(20) — Primary key
- body (Field1) — TEXT
- special_deleted (Field5) — TEXT
- Okt_pos (Field6) — TEXT
- stopwords_deleted (Field7) — TEXT
- noun (Field8) — TEXT
- n_v_adj_ad (Field9) — TEXT
twit (twit table)
- twit_Index (PK) — VARCHAR(20) — Primary key — NOT NULL
- date (INDEX1) — DATETIME — Primary key — NOT NULL
- origin_id (INDEX2) — VARCHAR(20) — Foreign key → retwit.origin_id
- body (Field1) — TEXT
- hashtag (Field2) — varchar(1000)
- is_retwitted (Field3) — Boolean
- special_deleted (Field4) — TEXT
- Okt_pos (Field5) — TEXT
- stopwords_deleted (Field6) — TEXT
- noun (Field7) — TEXT
- n_v_adj_ad (Field8) — TEXT