NaverNews
Tables (5)
Article (tb_article)
- Article_ID — VARCHAR(64) — Primary key — NOT NULL
- Title — VARCHAR(64)
- Date — DATE
- Content — VARCHAR(64)
- Category_id — VARCHAR(64) — Foreign key → Category.Category_id — NOT NULL
- Comment_ID — VARCHAR(64) — Foreign key → Comment.Comment_ID — NOT NULL
- Author_ID — VARCHAR(64) — Foreign key → Author.Author_ID — NOT NULL
- Sticker_ID — VARCHAR(64) — Foreign key → Sticker.Sticker_ID — NOT NULL
Author (tb_author)
- Author_ID — VARCHAR(64) — Primary key — NOT NULL
- Name — VARCHAR(64)
- Email — VARCHAR(64)
- Affiliation — VARCHAR(64)
Category (tb_category)
- Category_id — VARCHAR(64) — Primary key — NOT NULL
- Category_Name — VARCHAR(64)
Comment (tb_comment)
- Comment_ID — VARCHAR(64) — Primary key — NOT NULL
- User_ID — VARCHAR(64)
- Comment_Date — Date
- Content — VARCHAR(64)
Sticker (tb_sticker)
- Sticker_ID — VARCHAR(64) — Primary key — NOT NULL
- Name — VARCHAR(64)