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)