Tooliv
Tables (9)
channel_members (채널 멤버)
- id — varchar(36) — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- logged_at — datetime(6)
- channel_member_code — varchar(255)
- user_id — varchar(36) — Foreign key → users.id — NOT NULL
- channel_id — varchar(36) — Foreign key → channels.id — NOT NULL
channels (채널)
- id — varchar(36) — Primary key — NOT NULL
- name — varchar(255)
- private_yn — tinyint(1)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- wrote_at — datetime(6)
- channel_code — varchar(255) — NOT NULL
- workspace_id — varchar(36) — Foreign key → workspaces.id — NOT NULL
chat_file (채팅 파일)
- id — varchar(36) — Primary key — NOT NULL
- file_name — varchar(255)
chat_message (채팅 메세지)
- channel_id — varchar(36) — Primary key — NOT NULL
- chat_id — varchar(36) — Primary key — NOT NULL
- content — varchar(255)
- deleted — tinyint(1)
- updated — tinyint(1)
- created_at — datetime(6)
direct_chat_room (다이렉트 채팅방)
- id — varchar(36) — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- wrote_at — datetime(6)
- user_id1 — varchar(36) — Foreign key → users.id — NOT NULL
- user_id2 — varchar(36) — Foreign key → users.id — NOT NULL
direct_chat_room_members (다이렉트 채팅 멤버)
- id — varchar(36) — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- logged_at — datetime(6)
- user_id — varchar(36) — Foreign key → users.id — NOT NULL
- direct_chat_room_id — varchar(36) — Foreign key → direct_chat_room.id — NOT NULL
users (회원)
- id — varchar(36) — Primary key — NOT NULL
- email — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- user_code — varchar(255)
- status_code — varchar(255)
- profile_image — varchar(255)
workspace_members (워크스페이스 멤버)
- id — varchar(36) — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- workspace_member_code — varchar(255)
- workspace_id — varchar(36) — Foreign key → workspaces.id — NOT NULL
- user_id — varchar(36) — Foreign key → users.id — NOT NULL
workspaces (워크스페이스)
- id — varchar(36) — Primary key — NOT NULL
- name — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- thumbnail_image — varchar(255)