NewsSummarizing

Tables (3)

Category (tb_category)

  • id (Key) — int(20) — Primary key — NOT NULL
  • platform (Field) — varchar(255)
  • main_category (Field2) — varchar(255)
  • sub_category (Field3) — varchar(255)

Comment (tb_comment)

  • id (Key) — int(20) — Primary key — NOT NULL
  • news_id (Key2) — varchar(255) — Foreign key → News.id — NOT NULL
  • user_nickname (Field) — varchar(255)
  • comment (Field2) — text

News (tb_news)

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • platform (Field) — varchar(255)
  • main_category (Field2) — varchar(255)
  • sub_category (Field3) — varchar(255)
  • category_id (Key2) — int(20) — Foreign key → Category.id — NOT NULL
  • title (Field4) — varchar(255)
  • content (Field5) — longtext
  • writer (Field6) — varchar(255)
  • writed_at (Field7) — datetime
  • medianame (Field8) — varchar(255)
  • sticker_1 (Field9) — int(10)
  • sticker_2 (Field10) — int(10)
  • sticker_3 (Field11) — int(10)
  • sticker_4 (Field12) — int(10)
  • sticker_5 (Field13) — int(10)