Naver

Tables (3)

Comment (tb_comment)

  • id — INT — Primary key — NOT NULL
  • new_id (news_id) — INT — Foreign key → News.id — NOT NULL
  • user_id — VARCHAR(64)
  • writed_at — DATETIME
  • content — VARCHAR(64)

News (tb_news)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(64)
  • writed_at — DATETIME
  • content — VARCHAR(64)
  • writer (author) — VARCHAR(64)
  • flatform (flaform) — boolean
  • main_category — VARCHAR(64)
  • sub_category — VARCHAR(64)

Sticker (tb_sticker)

  • id — INT — Primary key — NOT NULL
  • news_id — INT — Foreign key → News.id — NOT NULL
  • name — VARCHAR(64)
  • count — INT