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