graduation

Tables (4)

Article (기사)

  • artcile_index (PK) — INT — Primary key — NOT NULL
  • title (Field) — VARCAHR
  • comp (Field2) — VARCHAR
  • editor (Field3) — VARCHAR
  • date (Field4) — DATETIME

Emot (네이버 기사 감정표현)

  • artcile_index (FK) — INT — Foreign key → Article.artcile_index — NOT NULL
  • likes (Field) — INT
  • h_m (Field2) — INT
  • sad (Field3) — INT
  • mad (Field4) — INT
  • want (Field5) — INT

Reply (댓글)

  • reply_index (PK) — INT — Primary key — NOT NULL
  • artcile_index (FK) — INT — Foreign key → Article.artcile_index — NOT NULL
  • body (Field) — TEXT
  • dete (Field2) — DATETIME

Twit (트윗)

  • tweet_index (PK) — INT — Primary key — NOT NULL
  • body (Field) — TEXT
  • hashtag (Field2) — VARCHAR
  • date (Field3) — DATETIME
  • origin_id (Field4) — VARCHAR
  • is_retwit (Field5) — BOOL