NaverNews
Tables (5)
Article (tb_article)
- Article_ID (Key) — VARCHAR(64) — Primary key — NOT NULL
- Title (Field) — VARCHAR(64)
- Date (Field2) — DATE
- Content (Field4) — VARCHAR(64)
- comment (Field6) — VARCHAR(64)
- Author_ID (Key2) — VARCHAR(64) — Foreign key → Author.Author_ID — NOT NULL
- Comment_ID (Key3) — VARCHAR(64) — Foreign key → Comment.Comment_ID — NOT NULL
- Sticker_ID (Key4) — VARCHAR(64) — Foreign key → Sticker.Sticker_ID — NOT NULL
- Category_ID (Key5) — VARCHAR(64) — Foreign key → Category.Category_ID — NOT NULL
Author (tb_author)
- Author_ID (Key) — VARCHAR(64) — Primary key — NOT NULL
- Author_Name (Field) — VARCHAR(64)
- Email (Field2) — VARCHAR(64)
- Affiliation (Field3) — VARCHAR(64)
Category (tb_category)
- Category_ID (Key) — VARCHAR(64) — Primary key — NOT NULL
- Category_Name (Field) — VARCHAR(64)
Comment (tb_comment)
- Comment_ID (Key) — VARCHAR(64) — Primary key — NOT NULL
- User_ID (Field) — VARCHAR(64)
- Comment_Date (Field2) — VARCHAR(64)
- Content (Field3) — VARCHAR(64)
Sticker (tb_sticker)
- Sticker_ID (Key) — VARCHAR(64) — Primary key — NOT NULL
- sticker_img (Field) — MEDIUMBLOB