CopyCord

Tables (5)

channel (채널)

  • channel_object_id (채널 기본키) — String — Primary key — NOT NULL
  • server_object_id (서버 기본키) — String — Foreign key → server.server_object_id — NOT NULL
  • channel_name (채널 이름) — String
  • channel_type (채널 타입) — String
  • Field

channel_message (채널 메시지)

  • 메세지 기본키 (message_obejct_id) — String — Primary key — NOT NULL
  • channel_object_id (채널 기본키) — String — Foreign key → channel.channel_object_id — NOT NULL
  • server_object_id (서버 기본키) — String — Foreign key → channel.server_object_id — NOT NULL
  • user_object_id (유저 기본키) — String — Foreign key → user.user_object_id — NOT NULL
  • 메세지 타입 (message_type) — String
  • 메세지 내용 (message_content) — String
  • 메세지 Url (message_url) — String
  • 메세지 등록시간 (created_at) — timenow
  • 메세지 읽음숫자 (message_read) — INT

server (서버)

  • server_object_id (서버 기본키) — String — Primary key — NOT NULL
  • server_name (서버 이름) — String
  • server_profile_url (서버 프로필 이미지) — String
  • createdAt (생성시간) — Date
  • Field

server_entrance_user (서버 참여 유저)

  • server_object_id (서버 기본키) — String — Foreign key → server.server_object_id — NOT NULL
  • user_object_id (유저 기본키) — String — Foreign key → user.user_object_id — NOT NULL
  • server_power (서버 권한) — String
  • createdAt (생성시간) — Date
  • Field

user

  • user_object_id (유저 기본키) — String — Primary key — NOT NULL
  • user_id (유저 아이디) — String
  • password (비밀번호) — String
  • user_nick_name (유저 닉네임) — String
  • user_profile_url (유저 프로필) — String
  • createdAt (생성시간) — Date
  • Field