Synchrome_DB

Tables (19)

BLOCK (블록)

  • id — BIGINT — Primary key — NOT NULL — autoincrement
  • canvas_id (캔버스 id) — BIGINT — Foreign key → CANVAS.id — NOT NULL
  • parent_id (내용) — varchar(255) — NOT NULL
  • content (삭제여부) — ENUM — NOT NULL — Y/N
  • indent (들여쓰기 수준) — ENUM — NOT NULL

CALENDAR (캘린더)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • workspace_id (워크스페이스id) — BIGINT — Foreign key → WORKSPACE.ID — NOT NULL
  • name (이름) — varchar(255)
  • userId (유저id)
  • Field3
  • Field4

CALL (통화)

  • call_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • channel_id (관련채널id) — BIGINT — NOT NULL — workspace service
  • started_time (시작시간) — timestamp — NOT NULL
  • ended_time (종료시간) — timestamp — NOT NULL
  • session_id (세션 이름) — varchat(255) — NOT NULL

CANVAS (캔버스)

  • id — BIGINT — Primary key — NOT NULL — autoincrement
  • channel_id (채널 id) — BIGINT — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • isDeleted (삭제여부) — ENUM — NOT NULL — Y/N

CHANNEL (채널)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoIncrement
  • Section_Id (section_id) — BIGINT — Foreign key → SECTION.ID — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • createdTime (생성일자) — dateTime — NOT NULL
  • updatedTime (수정일자) — dateTime — NOT NULL
  • isDeleted (삭제여부) — ENUM — NOT NULL — Y/N
  • userId (소유 회원) — BIGINT — NOT NULL

Channel Participant (채널 참여자)

  • id — BIGINT — Primary key — NOT NULL — autoIncrement
  • channel_id (채널 id) — BIGINT — Foreign key → CHANNEL.ID — NOT NULL
  • member_id (멤버 id) — BIGINT — NOT NULL
  • isDeleted (삭제여부) — ENUM — NOT NULL
  • createdTIme (생성시간) — dateTime — NOT NULL
  • updatedTime (수정일자) — dateTime — NOT NULL

Chat Message (채팅 글)

  • id — BIGINT — Primary key — NOT NULL — autoincrement
  • chat_room_id (채팅방 id) — BIGINT — Foreign key → Chat Room.id — NOT NULL
  • parent_id (부모 메시지 id) — BIGINT — Foreign key → Chat Message.id
  • member_id (보낸이 id) — BIGINT — NOT NULL
  • content (메시지내용) — varchar — NOT NULL
  • created_time (생성시간) — timestamp — NOT NULL — currentimestamp
  • updated_time (수정시간) — timestamp

Chat Room (채팅방 목록)

  • id — BIGINT — Primary key — NOT NULL — autoincrement
  • channel_id (채널 id) — BIGINT — NOT NULL
  • is_group_chat (그룹 채팅방 여부) — ENUM — NOT NULL — Y/N

Event (일정)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • calendar_id (캘린더id) — BIGINT — Foreign key → CALENDAR.ID — NOT NULL
  • title (제목) — varchar(255)
  • content (내용) — varchar(255)
  • color (색상)
  • colorLabel (색상이름)
  • groupId (그룹id)
  • startTime (시작시간)
  • endTime (종료시간)
  • repeatType (반복주기)
  • repeatUntil (반복종료일)
  • exceptions (예외일정)

MEMBER (유저)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • name (이름) — varchar(255) — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • createdTime (생성일자) — dateTime — NOT NULL
  • updatedTime (수정일자) — dateTime — NOT NULL
  • profile (프로필사진) — varchar(255)
  • masterYN (마스터여부) — enum — NOT NULL
  • channelManagerYN (채널매니저여부) — enum — NOT NULL
  • socialId (소셜로그인ID) — varchar(255) — NOT NULL
  • delYN (삭제여부) — enum — NOT NULL
  • isActive (활성화상태) — tyniInt — NOT NULL

PARTICIPANTS (통화 참가자)

  • participant_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • call_id (연결된통화id) — BIGINT — Foreign key → CALL.call_id — NOT NULL
  • participant_id (통화에 참가한 유저 id) — BIGINT — NOT NULL — user service

Read Status (읽음 여부)

  • id (Key) — BIGINT — Primary key — NOT NULL — autoincrement
  • chat_message_id (id) — BIGINT — Foreign key → Chat Message.id — NOT NULL
  • chat_room_id (채팅방 id) — BIGINT — Foreign key → Chat Message.chat_room_id — NOT NULL
  • member_id (Field3) — BIGINT — NOT NULL
  • is_read (Field4) — ENUM — NOT NULL — Y/N

SECTION (섹션)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • WorkSpaceId (workspaceId) — BIGINT — Foreign key → WORKSPACE.ID — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • createdTime (생성일자) — dateTime — NOT NULL
  • updatedTime (수정일자) — dateTime — NOT NULL
  • isDeleted (삭제여부) — enum — NOT NULL — Y/N
  • userId (소유 회원) — BIGINT — NOT NULL

WORKSPACE (워크스페이스)

  • ID (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • title (제목) — varchar(255) — NOT NULL
  • logo (로고사진) — varchar(255) — NOT NULL
  • isDeleted (삭제여부) — ENUM — NOT NULL — Y/N
  • invite_url (초대링크) — varchar(255) — NOT NULL
  • userId (마스터 유저) — BIGINT — NOT NULL

Workspace Participant (워크스페이스 참여자)

  • id — BIGINT — Primary key — NOT NULL — autoincrement
  • workspace_id (워크스페이스 id) — BIGINT — Foreign key → WORKSPACE.ID — NOT NULL
  • member_id (멤버 id) — BIGINT — NOT NULL
  • isDeleted (삭제여부) — ENUM — NOT NULL
  • createdTime (생성시간) — dateTime — NOT NULL
  • updatedTime (수정일자) — dateTime — NOT NULL

document (문서/파일)

  • doc_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • title (문서제목) — varchar(255) — NOT NULL
  • content (문서내용) — varchar(255) — NOT NULL
  • owner_id (작성자id) — BIGINT — NOT NULL — user service
  • created_time (생성시간) — timestamp — NOT NULL
  • doc_url (저장위치(s3)) — varchar(255) — NOT NULL — 문서,파일 s3연결
  • doc_type (확장자) — varchar(255) — NOT NULL — enum으로할지 논의

documentandchannel (문서와채널연결)

  • dnc_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • doc_id (연결된문서id) — BIGINT — Foreign key → document.doc_id — NOT NULL — autoincrement
  • channel_id (채널id) — BIGINT — NOT NULL — workspace service
  • shared_time (공유된 시각) — timstammp — NOT NULL

tag (스마트폴더방식사용시 필요한 태그)

  • tag_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • tag_name (태그이름) — varchar(255) — NOT NULL

taganddoc (문서랑태그정션)

  • taganddoc_id (id) — BIGINT — Primary key — NOT NULL — autoincrement
  • tag_id (연결된태그id) — BIGINT — Foreign key → tag.tag_id — NOT NULL
  • doc_id (연결된 문서id) — BIGINT — Foreign key → document.doc_id — NOT NULL