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