discodeit - old

Tables (7)

binary_contents

  • bcId (id) — uuid — Primary key — NOT NULL
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 파일이름 (file_name) — varchar(255) — NOT NULL
  • 크기 (size) — bigint — NOT NULL
  • 타입 (content_type) — varchar(100) — NOT NULL
  • bytes — bytea — NOT NULL

channels

  • uuid (id) — uuid — Primary key — NOT NULL
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 업데이트일 (updated_at) — timestamptz
  • 채널이름 (name) — varchar(100)
  • 설명 (description) — varchar(500)
  • 타입 (type) — varchar(10) — NOT NULL

message

  • uuid (id) — uuid — Primary key — NOT NULL
  • userId (author_id) — uuid — Foreign key → users.userId
  • uuid (channel_id) — uuid — Foreign key → channels.uuid — NOT NULL
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 업데이트일 (updated_at) — timestamptz
  • 내용 (content) — text
  • Field

message_attachments

  • attachment_id — uuid — Foreign key → binary_contents.bcId
  • message_id — uuid — Foreign key → message.uuid
  • Field

read_statuses

  • rsId (id) — uuid — Primary key — NOT NULL
  • userId (user_id) — uuid — Foreign key → users.userId — NOT NULL
  • uuid (channel_id) — uuid — Foreign key → channels.uuid — NOT NULL
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 업데이트일 (updated_at) — timestamptz
  • 마지막읽은시간 (last_read_at) — timestamptz — NOT NULL

user_statuses

  • usId (id) — uuid — Primary key — NOT NULL
  • userId (user_id) — uuid — Foreign key → users.userId — NOT NULL
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 업데이트일 (updated_at) — timestamptz
  • 마지막활동시간 (last_active_at) — timestamptz — NOT NULL

users

  • userId (id) — uuid — Primary key — NOT NULL
  • profileId (profile_id) — uuid — Foreign key → binary_contents.bcId
  • 생성일 (created_at) — timestamptz — NOT NULL
  • 업데이트일 (updated_at) — instant
  • 로그인아이디 (username) — varcahr(50) — NOT NULL
  • 이메일 (email) — varchar(100) — NOT NULL
  • 비밀번호 (password) — varchar(60) — NOT NULL