팀오더 채팅
테이블 (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