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