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