BeeSpace

Tables (23)

Alarm (알람)

  • alarm_id (알람아이디) — Long — Primary key — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • alarm_message (메시지) — String
  • read_status (읽음상태) — EnumString

Bookmark (북마크)

  • bookmark_id (북마크아이디) — Long — Primary key — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL

Comment (댓글)

  • comment_id (댓글아이디) — Long — Primary key — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • content (댓글) — String
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL

Community (커뮤니티)

  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • category (카테고리) — EnumString

FeedbackAnswer (피드백답변)

  • feedback_answer_id (피드백답변아이디) — Long — Primary key — NOT NULL
  • feedback_question_id (피드백질문아이디) — Long — Foreign key → FeedbackQuestion.feedback_question_id — NOT NULL
  • question_option_id (질문옵션아이디) — Long — Foreign key → QuestionOption.question_option_id — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • answer_text (주관식답변) — String

FeedbackQuestion (피드백질문)

  • feedback_question_id (피드백질문아이디) — Long — Primary key — NOT NULL
  • project_id (게시글아이디) — Long — Foreign key → Project.post_id — NOT NULL
  • question_text (질문) — String
  • question_type (질문타입) — EnumString

HashTag (해시태그)

  • hash_tag_id (해시태그아이디) — Long — Primary key — NOT NULL
  • community_id (게시글아이디) — Long — Foreign key → Community.post_id — NOT NULL
  • hash_tag (해시태그) — String

Image (이미지)

  • image_id (이미지아이디) — Long — Primary key — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • url (이미지URL) — String

InterestedStack (관심스택)

  • interest_tech_stack_id (관심스택아이디) — Long — Primary key — NOT NULL
  • tech_stack_id (기술스택아이디) — String — Foreign key → TechStack.tech_stack_id — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL

Like (좋아요)

  • like_id (좋아요아이디) — Long — Primary key — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL

Link (링크)

  • link_id (링크아이디) — Long — Primary key — NOT NULL
  • project_id (게시글아이디) — Long — Foreign key → Project.post_id — NOT NULL
  • link_type (링크타입) — String
  • url (주소) — String

Member (회원)

  • member_id (회원아이디) — String — Primary key — NOT NULL
  • provider (SNS아이디) — String
  • member_email (이메일) — String
  • member_nickname (닉네임) — String
  • profile_url (프로필URL) — String
  • role (권한) — EnumString
  • member_introduce (소개글) — String
  • member_position (포지션) — String
  • member_career (커리어) — Integer

Position (포지션)

  • position_id (포지션아이디) — Long — Primary key — NOT NULL
  • recruit_id (게시글아이디) — Long — Foreign key → Recruit.post_id — NOT NULL
  • position (포지션) — String
  • amount (모집할 인원수) — Integer
  • now (모집된 인원수) — Integer
  • status (상태) — EnumString

Post (게시글)

  • post_id (게시글아이디) — Long — Primary key — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • post_type (게시글타입) — EnumString
  • title (제목) — String
  • content (내용) — String
  • view_count (조회수) — Integer
  • thumbnail (썸네일) — String
  • banner_content (소개글) — String
  • status (상태) — EnumString

Project (프로젝트)

  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • field (분야) — String
  • category (카테고리) — EnumString
  • weekview_count (주간조회수) — Integer

ProjectMember (프로젝트맴버)

  • project_member_id (프로젝트 맴버 아이디) — Long — Primary key — NOT NULL
  • project_id (게시글아이디) — Long — Foreign key → Project.post_id — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • position (포지션) — String

ProjectTechStack (프로젝트 기술스택)

  • project_tech_stack_id (프로젝트 기술스택 아이디) — Long — Primary key — NOT NULL
  • project_id (게시글아이디) — Long — Foreign key → Project.post_id — NOT NULL
  • tech_stack_id (기술스택아이디) — String — Foreign key → TechStack.tech_stack_id — NOT NULL

QuestionOption (질문옵션)

  • question_option_id (질문옵션아이디) — Long — Primary key — NOT NULL
  • option_text (옵션명) — String
  • feedback_question_id (피드백질문아이디) — Long — Foreign key → FeedbackQuestion.feedback_question_id — NOT NULL

Recruit (모집)

  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • category (카테고리) — EnumString
  • amount (총모집인원) — Integer
  • proceed_way (진행방식) — EnumString
  • work_day (진행기간) — LocalDate
  • contact_way (연락방법) — EnumString
  • contact (연락처) — String
  • recruit_status (모집상태) — EnumString

RecruitTechStack (모집스택)

  • recruit_tech_stack_id (모집스택아이디) — Long — Primary key — NOT NULL
  • recruit_id (게시글아이디) — Long — Foreign key → Recruit.post_id — NOT NULL
  • tech_stack_id (기술스택아이디) — String — Foreign key → TechStack.tech_stack_id — NOT NULL

RefreshToken (리프레시토큰)

  • refresh_token_id (리프레시토큰아이디) — Long — Primary key — NOT NULL
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • refresh_token (리프레시토큰) — String
  • expired_time (만료기한) — LocalDateTime

Report (신고)

  • report_id (신고아이디) — Long — Primary key — NOT NULL
  • category (신고카테고리) — EnumString
  • content (신고내용) — String
  • status (처리상태) — EnumString
  • member_id (회원아이디) — String — Foreign key → Member.member_id — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → Post.post_id — NOT NULL

TechStack (기술스택)

  • tech_stack_id (기술스택아이디) — String — Primary key — NOT NULL
  • icon_url (기술스택 아이콘) — String