barcode

Tables (7)

ChannelGroup (여러개의 채널을 가진 그룹)

  • id (그룹ID) — Primary key — NOT NULL
  • id (서버ID) — Foreign key → Server.id — NOT NULL
  • name (그룹이름)
  • type (채널종류) — Enum

Server (Untitled2)

  • id (서버ID) — Primary key — NOT NULL
  • adminId (서버를만든사람Id) — ID — Foreign key → User.id — NOT NULL
  • name (서버이름)
  • imgUrl (이미지Url)
  • inviteCode (초대코드)

Team (서버에 포함되어 있는 유저들)

  • id (팀ID) — Primary key — NOT NULL
  • userId (유저ID) — ID — Foreign key → User.id — NOT NULL
  • serverId (서버ID) — Foreign key → Server.id — NOT NULL

Text_Channel (Untitled3)

  • id (채팅채널ID) — ID — Primary key — NOT NULL
  • id (그룹ID) — Foreign key → ChannelGroup.id — NOT NULL
  • name (채팅채널이름)

Text_Channel_Message (Untitled4)

  • id (메시지ID) — Primary key — NOT NULL
  • id (채팅채널ID) — ID — Foreign key → Text_Channel.id — NOT NULL
  • content (메시지내용)
  • createdAt (메시지 생성날짜)
  • updatedAt (메시지 수정날짜)
  • deletedAt (메시지 삭제날짜)
  • id (유저ID) — ID — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (유저ID) — ID — Primary key — NOT NULL
  • email (이메일) — varchar(255)
  • password (비밀번호) — varchar(255)
  • nickname (닉네임) — VARCHAR(30)
  • role (접근권한역할)
  • accessYn (유저활성화여부) — boolean
  • isConnected (현재접속여부) — boolean
  • createAt (유저생성날짜) — DATETIME(6)
  • updatedAt (유저수정날짜) — DATETIME(6)
  • deletedAt (유저삭제날짜) — DATETIME(6)

Voice_Channel (Untitled5)

  • id (회의채널ID) — Primary key — NOT NULL
  • id (그룹ID) — Foreign key → ChannelGroup.id — NOT NULL
  • name (회의채널이름)