blogProject

Tables (6)

comment

  • comment_id — Primary key — NOT NULL
  • post_id — Primary key — NOT NULL
  • content (nickname)
  • author

likes

  • like_id — Primary key — NOT NULL
  • post_id — Foreign key → posts.post_id — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • liked — boolean — NOT NULL

posts

  • post_id — Primary key — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • title — NOT NULL
  • content — NOT NULL
  • author — NOT NULL

roles

  • role_id — Primary key — NOT NULL
  • name — Primary key — NOT NULL

user

  • user_id — Long — Primary key — NOT NULL
  • email — Varchar — NOT NULL — Unique
  • password — Varchar — NOT NULL

user_role (User_role)

  • user_role_id — Primary key — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • role_id — Foreign key → roles.role_id — NOT NULL