ERD연습

테이블 (8)

Employee

  • id — Long — 기본 키 — NOT NULL
  • createdAt
  • updatedAt

binary_contents

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • file_name — varcar(255) — NOT NULL
  • size — bigint — NOT NULL
  • content_type — varchar(100) — NOT NULL
  • bytes — bytea — NOT NULL

channels

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • name — varchar(100)
  • description — varchar(500)
  • type — varchar(10) — NOT NULL

message_attachments

  • message_id — uuid — 외래 키 → messages.id — NOT NULL
  • attachment_id — uuid — 외래 키 → binary_contents.id — NOT NULL

messages

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • content — text
  • channel_id — uuid — 외래 키 → channels.id — NOT NULL
  • author_id — uuid — 외래 키 → users.id — NOT NULL

read_statuses

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • user_id — uuid — 외래 키 → users.id — NOT NULL
  • channel_id — uuid — 외래 키 → channels.id — NOT NULL

user_statuses

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • user_id — uuid — 외래 키 → users.id — NOT NULL
  • last_active_at — timestamptz — NOT NULL

users

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestampts — NOT NULL
  • updated_at — timestampts
  • username — varchar(50) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(60) — NOT NULL
  • profile_id — uuid — 외래 키 → binary_contents.id — NOT NULL