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)