TeamKrews

Tables (6)

ChatRoom (chat_room)

  • id — BIGINT(20) — Primary key — NOT NULL — ef

Message (message)

  • id — BIGINT(20) — Primary key — NOT NULL — ef
  • Field

User

  • id — BIGINT(20) — Primary key — NOT NULL — ef
  • email — VARCAHR
  • loginId — VARCAHR
  • password — VARCAHR
  • nickName (nick_name) — VARCAHR
  • profileImageUrl (profile_image_url) — VARCAHR
  • userUUID (Field3) — VARCHAR

UserChatRoom (user_chat_room)

  • id — BIGINT(20) — Primary key — NOT NULL — ef
  • chatRoomId (chat_room_id) — BIGINT(20) — Foreign key → ChatRoom.id — NOT NULL — ef
  • workspaceId (workspace_Id) — BIGINT(20) — Foreign key → Workspace.id — NOT NULL — ef
  • userId (user_id) — BIGINT(20) — Foreign key → User.id — NOT NULL — ef

UserWorkspace (user_workspace)

  • id — BIGINT(20) — Primary key — NOT NULL — ef
  • userId (user_id) — BIGINT(20) — Foreign key → User.id — NOT NULL — ef
  • workspaceId (workspace_id) — BIGINT(20) — Foreign key → Workspace.id — NOT NULL — ef

Workspace (workspace)

  • id — BIGINT(20) — Primary key — NOT NULL — ef
  • teamName (team_name) — VARCAHR
  • explanation — VARCAHR
  • password — VARCAHR
  • nickName (workspace_uuid) — VARCAHR