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