myblog
Tables (6)
Article (게시글)
- id (PK) — Long — Primary key — NOT NULL
- user_id (FK) — Long — Foreign key → User.id — NOT NULL
- title (Field1) — String
- content (Field2) — String
- likeCount (Field3) — int
- Created_At (Field4) — Date
- Modified_At (Field5) — Date
Comment (댓글)
- id (PK) — Long — Primary key — NOT NULL
- article_id (FK) — Long — Foreign key → Article.id — NOT NULL
- user_id (FK2) — Long — Foreign key → User.id — NOT NULL
- content (Field1) — String
- likeCount (Field2) — int
- Created_At (Field3) — Date
- Modified_At (Field4) — Date
Likes (좋아요)
- id (PK) — Long — Primary key — NOT NULL
- comment_id (FK) — Long — Primary key — NOT NULL
- article_id (FK1) — Long — Foreign key → Comment.article_id — NOT NULL
- user_id (FK2) — Long — Foreign key → Comment.user_id — NOT NULL
- content (Field1) — String
- likeCount (Field2) — int
RefreshToken (리프레시토큰)
- id (PK) — Long — Primary key — NOT NULL
- content (Field2) — String
- likeCount (Field3) — int
Reply (대댓글)
- id (PK) — Long — Primary key — NOT NULL
- comment_id (FK) — Long — Foreign key → Comment.id — NOT NULL
- content (Field1) — String
- likeCount (Field2) — int
- Created_At (Field3) — Date
- Modified_At (Field4) — Date
User (유저)
- id (PK) — Long — Primary key — NOT NULL
- usernmae (Field1) — String
- password (Field2) — String
- userRole (Field3) — enum
- Created_At (Field4) — Date
- Modified_At (Field5) — Date