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