마니또 ERD

테이블 (19)

개인 권한 (Person Previlage)

  • id (previlage_id) — NOT NULL — 기본 키 — NOT NULL
  • member_id — NOT NULL
  • type (prevliage_type) — NOT NULL
  • room (room_id)

게시판 (Board)

  • id (board_id) — NOT NULL — 기본 키 — NOT NULL
  • category (category_id) — NOT NULL
  • memberId (member_id) — NOT NULL
  • title (board_title) — NOT NULL
  • content (board_content) — NULL
  • view (board_view) — 0
  • isPrivate (board_isPrivate) — False
  • createdDate (board_createdDate) — NOT NULL

댓글 (Reply)

  • id (reply_id) — NOT NULL — 기본 키 — NOT NULL
  • member_id — NOT NULL
  • content (reply_content) — NOT NULL
  • createdDate (reply_createdDate) — NOT NULL

마니또 매칭 (Manitto Matching)

  • id (manitto_id) — NOT NULL — 기본 키 — NOT NULL
  • room_id — NOT NULL
  • grantee (manitto_grantee) — NOT NULL
  • transferee (manito_transferee) — NOT NULL
  • predictResult (manito_predict_result) — NOT NULL

미션 (Mission)

  • id (mission_id) — NOT NULL — 기본 키 — NOT NULL
  • name (mission_name) — NOT NULL
  • type (mission_type) — NOT NULL
  • roomId (misssion_room_id) — NOT NULL
  • describe (mission_describe) — NOT NULL

미션리스트 (MissionList)

  • id (missionList_id) — NOT NULL — 기본 키
  • roomId (room_id) — NOT NULL
  • missionId (misssion_id) — NOT NULL

미션배정 (Mission Assignment)

  • id (missionAssignment_id) — NOT NULL — 기본 키 — NOT NULL
  • memberId (member_id) — NOT NULL
  • misssionId (mission_id) — NOT NULL
  • deployTime (missionAssginment_deploy_time) — NOT NULL
  • ord (misssionAssigment_ord) — NOT NULL

미션패스 (Misssion Pass)

  • id (MissionPass_id) — NOT NULL — 기본 키 — NOT NULL
  • RoomId (room_id) — NOT NULL
  • memberId (member_id) — NOT NULL
  • missionId (misssion_id) — NOT NULL
  • misssioonAssignmentId (misssionAssignment_id) — NOT NULL

방 (ROOM)

  • id (room_id) — NOT NULL — 기본 키 — NOT NULL
  • inviteCode (room_inviteCode) — NOT NULL
  • name (room_name) — NOT NULL

방 북마크 (ROOM BookMark)

  • id (roomBookMark_id) — NOT NULL — 기본 키 — NOT NULL
  • memberId (member_id) — NOT NULL
  • roomId (room_id) — NOT NULL

방 세팅 (ROOM SETTING)

  • id (roomSetting_id) — NOT NULL — 기본 키 — NOT NULL
  • roomId (room_id) — NOT NULL
  • misstionType (room_mission_type) — NOT NULL
  • beginDateTime (room_begin_date_time) — NOT NULL
  • endDateTime (room_end_date_time) — NOT NULL
  • period (room_period) — NOT NULL

워드 클라우드 (WordCloud)

  • id (wordCloud_id) — NOT NULL — 기본 키 — NOT NULL
  • roomId (room_id) — NOT NULL
  • memberId (member_id) — NOT NULL
  • comment (wordCloud_comment) — NULL
  • createdDate (wordCloud_createdDate) — NOT NULL

좋아요 (Like)

  • id (Like_id) — NOT NULL — 기본 키 — NOT NULL
  • member_id — NOT NULL
  • board_id — NOT NULL

채팅 메시지 (ChattingMessage)

  • id (chattingMessage_id) — NOT NULL — 기본 키 — NOT NULL
  • chattingRoomId (chattingRoom_id) — NOT NULL
  • memberId (member_id) — NOT NULL
  • content (chattingMessage_content) — NULL
  • sentTime (chattingMessage_sentTime) — NOT NULL

채팅방 (ChattingRoom)

  • id (chattingRoom_id) — NOT NULL — 기본 키 — NOT NULL
  • memberList (memberList_id) — NOT NULL
  • name (chattingRoom_name) — NOT NULL

채팅방 맴버 리스트 (Untitled)

  • id (chattingRoomMemberList_id) — NOT NULL — 기본 키 — NOT NULL
  • memberId (member_id) — NOT NULL

카테고리 (Category)

  • id (category_id) — NOT NULL — 기본 키 — NOT NULL
  • name (category_name) — NOT NULL

파일 업로드 (File Upload)

  • id (upload_id) — NOT NULL — 기본 키 — NOT NULL
  • url (upload_url) — NOT NULL
  • memberId (member_id) — NOT NULL

회원 (Member)

  • id (member_id) — NOT NULL — 기본 키
  • email (member_email) — NOT NULL
  • password (member_password) — NOT NULL
  • name (member_name) — NOT NULL
  • provider (member_provider) — NOT NULL
  • isLeave (member_isLeave) — NOT NULL
  • profile (upload_url) — NOT NULL
  • createdTime (member_createdTime) — NOT NULL