chatApp

Tables (6)

chat (채팅)

  • id (아이디) — Long — Primary key — NOT NULL
  • send_user (유저아이디) — Long — Foreign key → user.id — NOT NULL
  • room_id (채팅방 아이디) — Long — Foreign key → chat_room.id — NOT NULL
  • content (내용) — String
  • created_at (생성시간) — time

chat_room (채팅방)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (채팅방이름) — String
  • created_at (생성일자) — time

chat_room_users (채팅방 유저등록)

  • user_id (유저) — Long — Foreign key → user.id — NOT NULL
  • chat_room_id (채팅방 아이디) — Long — Foreign key → chat_room.id — NOT NULL
  • joined_at (가입일자) — time

friend (친구등록)

  • id (친구등록 아이디) — Long — Primary key — NOT NULL
  • user_id (유저 아이디) — Long — Foreign key → user.id — NOT NULL
  • friend_id (친구 아이디) — Long
  • status (상태(요청,수락,거절)) — enum
  • createdAt (생성시간) — time

offline_chat (미전송 채팅)

  • Key (아이디) — Long — Primary key — NOT NULL
  • sender_id (송신자아이디) — Long — Foreign key → user.id — NOT NULL
  • recieverId (수신자아이디) — Long
  • content (내용) — String
  • created_at (생성일시) — time

user (유저)

  • id (아이디) — Long — Primary key — NOT NULL
  • email (이메일) — String — NOT NULL
  • password (비밀번호) — String — NOT NULL
  • nick_name (닉네임) — String
  • profile_image (프로필사진) — MultiFile
  • role (역할) — String — NOT NULL