ㅏ

Tables (5)

Copy Of chatroom_user (user)

  • PK (id) — bigint — Primary key — NOT NULL
  • Field (unread_chat_count) — bigint

Untitled

  • Field

chat

  • PK (id) — bigint — Primary key — NOT NULL
  • PK (chatroom_user_id) — bigint — Foreign key → chatroom_user.PK — NOT NULL
  • FK (content) — text — NOT NULL
  • 생성일 (created_at) — timestamp

chatroom

  • PK (id) — bigint — Primary key — NOT NULL
  • 생성일 (created_at) — timestamp — NOT NULL
  • 수정일 (deleted_at) — timestamp

chatroom_user

  • PK (id) — bigint — Primary key — NOT NULL
  • PK (user_id) — bigint — Foreign key → Copy Of chatroom_user.PK — NOT NULL
  • PK (chatroom_id) — bigint — Foreign key → chatroom.PK — NOT NULL
  • FK (joined_at) — timestamp — NOT NULL
  • 생성일 (quit_at) — timestamp
  • 수정일 (last_read_at) — timestamp
  • Field (unread_chat_count) — tinyint