msa example
Tables (24)
access_group
- id — VARCHAR(255) — Primary key — NOT NULL
- id2 — CHAR(36) — NOT NULL
- name — VARCHAR(255)
- user_invited — BOOLEAN — NOT NULL
- extra1 — BOOLEAN
- extra2 — BOOLEAN
- extra3 — BOOLEAN
- extra4 — BOOLEAN
- extra5 — BOOLEAN
- extra6 — BOOLEAN
alarm_category
- id — CHAR(36) — Primary key — NOT NULL
- title — VARCHAR(255)
- contents — VARCHAR(255)
- type — ENUM('workspace','stone','etc')
- extra — ENUM('system','custom')
call_participant
- id — BIGINT — Primary key — NOT NULL
- call_session_id — BIGINT — NOT NULL
- workspace_participant_id — VARCHAR(255) — NOT NULL
- role — ENUM('host','participant') — NOT NULL
- joined_at — DATETIME
- left_at — DATETIME
call_session
- id — BIGINT — Primary key — NOT NULL
- chat_room_id — BIGINT — NOT NULL
- workspace_participant_id — VARCHAR(255) — NOT NULL
- call_type — ENUM('voice','video') — NOT NULL
- status — ENUM('ongoing','ended') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
chat_media
- chat_media_id — BIGINT — Primary key — NOT NULL
- message_id — BIGINT — NOT NULL
- id2 — VARCHAR(255) — NOT NULL
- chat_room_id — BIGINT — NOT NULL
- url — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chat_participant
- chat_participant_id — BIGINT — Primary key — NOT NULL
- chat_room_id — BIGINT — NOT NULL
- workspace_participant_id — VARCHAR(255) — NOT NULL
- last_read_message_id — BIGINT
chat_room
- chat_room_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
child_stone_list
- id — CHAR(36) — Primary key — NOT NULL
- stone_id — CHAR(36) — NOT NULL
- child_stone_id — CHAR(36) — NOT NULL
document
- id — CHAR(36) — Primary key — NOT NULL
- folder_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
- extra_field1 — VARCHAR(255)
- extra_field2 — VARCHAR(255)
file
- id — CHAR(36) — Primary key — NOT NULL
- folder_id — VARCHAR(255) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- file_type — ENUM('image', 'pdf', 'doc', 'etc') — NOT NULL — 파일 유형
- file_size — VARCHAR(255) — NOT NULL — 파일 크기
- file_url — VARCHAR(255) — NOT NULL — S3 경로
- extra_field — VARCHAR(255) — 추후 확장용
folder
- id — VARCHAR(255) — Primary key — NOT NULL
- work_space_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- parent_id — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- extra_field1 — VARCHAR(255)
- extra_field2 — VARCHAR(255)
individual_calendar
- id — CHAR(36) — Primary key — NOT NULL
- id2 — CHAR(36) — NOT NULL
- id3 — CHAR(36) — NOT NULL
- type — ENUM('todo', 'personal') — NOT NULL
- description — VARCHAR(255) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- book_mark — BOOLEAN — NOT NULL — ToDo 즐겨찾기
- share — BOOLEAN — NOT NULL — 일정 공유 여부
message
- message_id — BIGINT — Primary key — NOT NULL
- chat_room_id — BIGINT — NOT NULL
- workspace_participant_id — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — CHAR(36) — Primary key — NOT NULL
- id2 — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- state — ENUM('READ','UNREAD','REMOVE') — NOT NULL
- extra1 — VARCHAR(255)
- extra2 — VARCHAR(255)
- extra3 — VARCHAR(255)
- extra4 — VARCHAR(255)
project
- id — CHAR(36) — Primary key — NOT NULL
- id2 — CHAR(36) — NOT NULL
- project_name — VARCHAR(255) — NOT NULL
- milestone — DECIMAL(3,1)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- project_admin — VARCHAR(255)
project_calendar
- id — CHAR(36) — Primary key — NOT NULL
- stone_id — CHAR(36) — NOT NULL
- id2 — CHAR(36) — NOT NULL
- field1 — BOOLEAN — NOT NULL
- field2 — BOOLEAN — NOT NULL
stone
- id — CHAR(36) — Primary key — NOT NULL
- project_id — CHAR(36) — NOT NULL
- parent_stone_id — CHAR(36)
- stone_name — VARCHAR(255) — NOT NULL
- stone_manager — VARCHAR(255)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- milestone — DECIMAL(3,1) — NOT NULL
- chat_creation — BOOLEAN — NOT NULL
- task_creation — BOOLEAN — NOT NULL
- status — ENUM('planned','in_progress','done')
stone_participant
- key_id — VARCHAR(255) — Primary key — NOT NULL
- id — CHAR(36) — NOT NULL
- name — VARCHAR(255) — ID 값이 있을 시 이름 표시
subscriber_list
- id — CHAR(36) — Primary key — NOT NULL
- key1 — VARCHAR(255) — NOT NULL
- key2 — VARCHAR(255) — NOT NULL
task
- id — CHAR(36) — Primary key — NOT NULL
- stone_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- task_name — VARCHAR(255) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- done — BOOLEAN — NOT NULL
user
- id — CHAR(36) — Primary key — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(30)
- profile_image — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_delete — BOOLEAN — NOT NULL
user_group
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(30) — NOT NULL
work_space
- id — VARCHAR(255) — Primary key — NOT NULL
- templates — ENUM('personal','pro','enterprise') — NOT NULL
- workspace_name — VARCHAR(255) — NOT NULL
- subscribe — VARCHAR(255) — NOT NULL
- storage — VARCHAR(255) — NOT NULL
- created_time — DATETIME — NOT NULL
- updated_time — DATETIME
- extra_field — VARCHAR(255)
workspace_participant
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- access_group_id — VARCHAR(255) — NOT NULL
- user_group_id — VARCHAR(255) — NOT NULL
- role — ENUM('admin','common') — NOT NULL