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