팀오더 채팅

테이블 (7)

ChatType

  • CREATE_TEAM_ORDER — O
  • USER_JOIN_TEAMORDER — O
  • USER_EXIT
  • USER_MSG — O
  • USER_REVIEW
  • USER_ENTER_TEAM_ORDER_CHAT
  • TEAM_ORDER_COMPLETE — O
  • TEAM_ORDER_LEFT_ONE_USER — O
  • TEAM_ORDER_ONE_MINUTE_LEFT — O
  • SEND_INVITE_MSG

Review

  • reviewId — 기본 키 — NOT NULL

TeamOrderChat

  • teamOrderChatId — 기본 키 — NOT NULL
  • teamOrderChatRoom — 외래 키 → TeamOrderChatRoom.teamOrderChatRoom — NOT NULL
  • content
  • chatType — ENUM
  • isDeleted
  • createdAt
  • lastModifiedAt
  • userId
  • reviewId

TeamOrderChatRoom

  • teamOrderChatRoom — 기본 키 — NOT NULL
  • teamOrderId — 외래 키 → Teamorder.teamOrderId — NOT NULL
  • isOneMinuteMsgSaved
  • latestChatTime

TeamOrderChatUser

  • teamOrderChatUserId — 기본 키 — NOT NULL
  • userId — 외래 키 → User.userId — NOT NULL
  • teamOrderChatRoom — 외래 키 → TeamOrderChatRoom.teamOrderChatRoom — NOT NULL
  • isJoin
  • isNotiPermitted
  • lastLookUpTime
  • createdAt
  • lastModifiedAt

Teamorder (Untitled)

  • teamOrderId — 기본 키 — NOT NULL
  • teamOrderMsg — String | Null

User

  • userId — 기본 키 — NOT NULL