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)