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 (회의채널이름)