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)