Roomy 2-2
Tables (7)
ChattingList (채팅리스트)
- ChattingList_ID (Key) — Int — Primary key — NOT NULL
- UIDD (Key2) — VarChar — Foreign key → User.UIDD — NOT NULL
- ChattingMessage_ID (Key3) — Int — Foreign key → ChattingMessage.ChattingMessage_ID — NOT NULL
- ChattingRoom_ID (Key4) — Int — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL
ChattingMessage (채팅메세지)
- ChattingMessage_ID (Key) — Int — Primary key — NOT NULL
- ChattingRoom_ID (채팅방아이디) — Int — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL
- Content (메세지 내용) — VarChar
- Date (보낸 시간) — LocalDateTime
- Check (확인 여부)
ChattingRoom (채팅방)
- ChattingRoom_ID (Key) — Int — Primary key — NOT NULL
- ChattingMessage_ID (채팅메세지아이디) — Int — Foreign key → ChattingMessage.ChattingMessage_ID — NOT NULL
- ChattingName (채팅방 이름) — VarChar
Comment (댓글관리)
- Comment_ID (Key) — Int — Primary key — NOT NULL
- UIDD (Key2) — VarChar — Foreign key → User.UIDD — NOT NULL
- Community_ID (Key3) — Int — Foreign key → Community.Community_ID — NOT NULL
- Content (댓글 내용) — VarChar
- Created_at (작성 날짜) — LocalDateTime
- Updated_at (수정 날짜) — LocalDateTime
Community (커뮤니티관리)
- Community_ID (Key) — Int — Primary key — NOT NULL
- author (작성자) — VarChar — Foreign key → User.UIDD — NOT NULL
- Title (제목) — VarChar
- Content (내용) — VarChar
- Created_at (작성 날짜) — LocalDateTime
- Updated_at (수정 날짜) — LocalDateTime
- Type (커뮤니티 타입) — VarChar
- Like (좋아요) — VarChar
- Report (신고)
Report (신고관리)
- Report_Key (신고아이디) — int — Primary key — NOT NULL
- Community_ID (신고받은 커뮤니티 아이디) — Int — Foreign key → Community.Community_ID — NOT NULL
- UIDD (신고자) — VarChar — Foreign key → User.UIDD — NOT NULL
- UIDD (신고 받은 사람) — VarChar — Foreign key → User.UIDD — NOT NULL
- Content (신고 내용) — VarChar
- Date (신고 받은 날짜) — LocalDateTime
User (유저관리)
- UIDD (Key) — VarChar — Primary key — NOT NULL
- Name (이름) — VarChar
- Profile (프로필사진) — VarChar
- Age (나이) — int
- Gender (성별) — VarChar
- Area (지역) — VarChar