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