NEWS_ERD

Tables (6)

Comment (comment)

  • comment_id — INT — Primary key
  • comment — VARCHAR(255)
  • news_id — INT — Foreign key → News.news_id — NOT NULL

MainCategory (main_category)

  • main_id — INT — Primary key — NOT NULL
  • name — VARCHAR(64)

News (news)

  • news_id — INT — Primary key — NOT NULL
  • main_id — INT — Foreign key → MainCategory.main_id — NOT NULL
  • sub_id — INT — Foreign key → SubCategory.sub_id — NOT NULL
  • platform_id — INT — Foreign key → PlatformInfo.platform_id — NOT NULL
  • title — VARCHAR(255)
  • writer — VARCHAR(255)
  • content — VARCHAR(255)
  • writed_at — DATETIME
  • url — VARCHAR(255)

PlatformInfo (platform_info)

  • platform_id — INT — Primary key — NOT NULL
  • name — VARCHAR(64)

Sticker (sticker)

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

SubCategory (sub_cateogory)

  • sub_id — INT — Primary key — NOT NULL
  • name — VARCHAR(64)