Paassible
Tables (20)
Application (지원 현황)
- 지원ID (id) — BIGINT — Primary key — NOT NULL
- 상태 (status) — VARCHAR — NOT NULL
- 메시지 (message) — VARCHAR
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
- 모집공고ID (recruit_id) — BIGINT — Foreign key → RecruitPost.모집공고ID — NOT NULL
Board (보드)
- 보드ID (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR — NOT NULL
- 내용 (content) — VARCHAR
- 활동유형 (activity_type) — VARCHAR — NOT NULL
- 세부유형 (detail_type) — VARCHAR — NOT NULL
- 진행상태 (status) — VARCHAR — NOT NULL
BoardMember (보드 보유 현황)
- 보드 보유ID (id) — BIGINT — Primary key — NOT NULL
- 역할 (role) — VARCHAR — NOT NULL
- 활성화 상태 (status) — VARCHAR — NOT NULL
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
- 보드ID (board_id) — BIGINT — Foreign key → Board.보드ID — NOT NULL
- 포지션ID (position_id) — BIGINT — Foreign key → Position.포지션ID — NOT NULL
ChatRoom (채팅방)
- 채팅룸 ID (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR — NOT NULL
- 그룹채팅여부 (is_group) — BOOLEAN — NOT NULL
- 종료 여부 (is_deleted) — BOOLEAN — NOT NULL
- 보드ID (board_id) — BIGINT — Foreign key → Board.보드ID — NOT NULL
ChatRoomUser (채팅룸유저)
- 채팅룸유저ID (id) — BIGINT — Primary key — NOT NULL
- 채팅룸 ID (chat_room_id) — BIGINT — Foreign key → ChatRoom.채팅룸 ID — NOT NULL
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
Interest (관심 분야)
- 관심분야ID (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR — NOT NULL
Meeting (회의)
- 회의ID (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — VARCHAR — NOT NULL
- 내용 (content) — VARCHAR — NOT NULL
- 보드ID (board_id) — BIGINT — Foreign key → Board.보드ID — NOT NULL
Message (메시지)
- 메시지ID (id) — BIGINT — Primary key — NOT NULL
- 내용 (content) — VARCHAR — NOT NULL
- 파일 (file_url) — VARCHAR
- 타입 (type) — VARCHAR — NOT NULL
- 채팅룸 ID (chat_room_id) — BIGINT — Foreign key → ChatRoom.채팅룸 ID — NOT NULL
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
MessageRead (메시지읽음)
- 메시지읽음ID (id) — BIGINT — Primary key — NOT NULL
- 메시지ID (message_id) — BIGINT — Foreign key → Message.메시지ID — NOT NULL
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
Portfolio (포트폴리오)
- 포트폴리오ID (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — VARCHAR
- 설명 (description) — VARCHAR
- 파일 (file) — VARCHAR
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
Position (포지션)
- 포지션ID (id) — BIGINT — Primary key — NOT NULL
- 역할 (name) — VARCHAR — NOT NULL
RecruitComment (모집공고 댓글)
- 모집공고댓글ID (id) — BIGINT — Primary key — NOT NULL
- 내용 (content) — VARCHAR
- 부모 댓글ID (parent_id) — BIGINT
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
- 모집공고ID (recruit_id) — BIGINT — Foreign key → RecruitPost.모집공고ID — NOT NULL
RecruitPost (모집공고)
- 모집공고ID (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — VARCHAR — NOT NULL
- 내용 (content) — VARCHAR
- 마감기한 (deadline) — TIMESTAMP
- 진행기간 (duration) — INT
- 활동유형 (activty_type) — VARCHAR
- 세부유형 (detail_type) — VARCHAR
Shortcut (바로가기)
- 링크ID (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR — NOT NULL
- 링크 (url) — VARCHAR — NOT NULL
- 보드ID (board_id) — BIGINT — Foreign key → Board.보드ID — NOT NULL
Stack (기술 스택)
- 기술스택ID (id) — BIGINT — Primary key — NOT NULL
- 기술스택 이름 (name) — VARCHAT — NOT NULL
Task (업무)
- 업무ID (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — VARCHAR — NOT NULL
- 설명 (description) — VARCHAR
- 마감일 (dueDate) — TIMESTAMP — NOT NULL
- 상태 (status) — VARCHAR — NOT NULL
- 보드ID (board_id) — BIGINT — Foreign key → Board.보드ID — NOT NULL
TaskAssignee (업무 담당자)
- 업무 담당자ID (id) — BIGINT — Primary key — NOT NULL
- 업무ID (task_id) — BIGINT — Foreign key → Task.업무ID — NOT NULL
- 담당자ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
User (회원)
- 회원ID (id) — BIGINT — Primary key — NOT NULL
- 소셜로그인ID (social_id) — VARCHAR — NOT NULL
- 닉네임 (nickname) — VARCHAR
- 전공 (major) — VARCHAR
- 프로필 이미지 (profileImageUrl) — VARCHAR
- 이메일 (email) — VARCHAR — NOT NULL
recruitPostStack (모집공고-기술스택)
- 기술스택ID (stack_id) — BIGINT — Foreign key → Stack.기술스택ID — NOT NULL
- 모집공고ID (recurit_id) — BIGINT — Foreign key → RecruitPost.모집공고ID — NOT NULL
- 포지션ID (position_id) — BIGINT — Foreign key → Position.포지션ID — NOT NULL
userInterest (유저-관심분야)
- 유저관심ID (id) — BIGINT — Primary key — NOT NULL
- 회원ID (user_id) — BIGINT — Foreign key → User.회원ID — NOT NULL
- 관심분야ID (interest_id) — BIGINT — Foreign key → Interest.관심분야ID — NOT NULL