마니또 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