Sucat ERD

Tables (14)

Untitled (User)

  • Key (userId) — Long — Primary key — NOT NULL
  • Field (email) — String — NOT NULL
  • Field2 (password) — String — NOT NULL
  • Field3 (department) — String — NOT NULL
  • Field4 (nickName) — String
  • Field5 (role) — Enum
  • Field (userStatus) — Enum — NOT NULL
  • Field (mates) — List<User>
  • Key (chatRoomId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Like)

  • Key (likeId) — Long — Primary key — NOT NULL
  • Key (boardId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (commentId) — Long — Primary key — NOT NULL
  • Field (writer) — String — NOT NULL
  • Field (content) — String
  • Key (boardId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Game)

  • Key (gameId) — Long — Primary key — NOT NULL
  • Field (name) — String — NOT NULL

Untitled (GameScore)

  • Key (scoreId) — Long — Primary key — NOT NULL
  • Field (highScore) — int
  • Field (totalScore) — int
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (gameId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (ChatRoom)

  • Key (chatRoomId) — Long — Primary key — NOT NULL
  • Field (senderId) — Long — NOT NULL
  • Field2 (receiverId) — Long — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (ChatMessage)

  • Key (messageId) — Long — Primary key — NOT NULL
  • Field (content) — String
  • Field2 (senderId) — String — NOT NULL
  • Key (chatRoomId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Notice)

  • Key (noticeId) — Long — Primary key — NOT NULL
  • Field (title) — String — NOT NULL
  • Field2 (content) — String
  • Field3 (writer) — String
  • Field (views) — int
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Notify)

  • Key (notifyId) — Long — Primary key — NOT NULL
  • Field (url) — String
  • Field2 (isRead) — Bool — NOT NULL
  • Field3 (notifyType) — Enum
  • Field (receiverId) — Long — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Image)

  • Key (imageId) — Long — Primary key — NOT NULL
  • Field (imageUrl) — String — NOT NULL
  • Key (boardId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (BaseEntity)

  • Field (createAt) — Time — NOT NULL
  • Field (updateAt) — Time — NOT NULL

Untitled (Board)

  • Key (boardId) — Long — Primary key — NOT NULL
  • Field (writer) — String — NOT NULL
  • Field2 (title) — String
  • Field3 (content) — String
  • Field4 (likeCount) — int
  • Field5 (boardCategory) — Enum — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (RefreshToken)

  • Key (refreshTokenId) — Long — Primary key — NOT NULL
  • Field (refreshToken) — String — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (BlockedUser)

  • Key (blockedUserId) — Long — Primary key — NOT NULL
  • Key (userId) — Long — Foreign key → Untitled.Key — NOT NULL