id                              bigint
group_id              bigint -- 최초  메세지의 보낸 id가 group id
sender_id                 bigint
receiver_id          bigint
regdate                             datetime
message                          nvarchar(150)
media_id                      bigint
link_id          bigint                      링크
read                     bit - 0
sender_delete                     bit - 0
recever_delete              bit - 0
type                    int

여기서 대화형으로 불러올때

group_id = @group_id AND (receiver_id=@user_id OR sender_id=@user_id)

 

이렇게 쭉 불러와 내 아이디가 sender 랑 같으면 오른쪽 else 왼쪽 이렇게 정렬하고 뿌려주면 끝