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