SkhuRing

Tables (5)

ChatMessage (채팅메시지)

  • id — int — Primary key — NOT NULL
  • chat_room_id (채팅방아이디) — Long — Foreign key → ChatRoom.id — NOT NULL
  • user_id (보낸사람) — Long — Foreign key → User.id — NOT NULL
  • content (내용)
  • message_type (메시지 타입) — NOT NULL — 이미지인지 텍스트인지

ChatParticipant (Untitled)

  • id — Primary key — NOT NULL
  • user_id (회원ID) — LOng — Foreign key → User.id — NOT NULL
  • chat_room_id (채팅방ID) — Long — Foreign key → ChatRoom.id — NOT NULL

ChatRoom (채팅방)

  • id — int — Primary key — NOT NULL
  • title (방제목) — VarChar(255) — NOT NULL
  • catagory (카테고리)
  • anonymous (익명여부) — Boolean — NOT NULL
  • MAX_PARTICIPANTS (채팅방 인원제한) — int — NOT NULL
  • created_at (채팅방 생성 날짜) — TimeStamp — NOT NULL
  • mentor_status (멘토여부) — Boolean — NOT NULL
  • room_manager (방장) — VarChar(255) — NOT NULL — 방장이 방을 없앨수도, 방장만 만족도 조사있음

Memo (메모)

  • id — Primary key — NOT NULL
  • chat_room_id (채팅방아이디) — long — Foreign key → ChatRoom.id
  • content (메모내용)

User (회원)

  • id — Long — Primary key — NOT NULL
  • name (이름) — VarChar — NOT NULL
  • email (이메일) — NOT NULL
  • socialType (소셜로그인종류) — NOT NULL — 구글로그인이나 카카오로그인 무조건 있어야함
  • socialId (Field) — NOT NULL — 소셜로그인 고유 아이디