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