ola-j_ra1n
Tables (7)
Bookmark
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- post_id — BIGINT — Foreign key → RecruitmentPost.post_id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Comment
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- post_id — BIGINT — Foreign key → RecruitmentPost.post_id — NOT NULL
- 내용 (content) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Interests
- interest_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- 관심분야 (interest) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Links
- interest_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- 링크 (link) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Notice
- notice_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- 알림내용 (content) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
RecruitmentPost
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- 제목 (title) — VARCHAR
- 내용 (content) — VARCHAR
- 조회수 (views) — BIGINT
- 모집구분(카테고리) (category) — ENUM('프로젝트', '스터디')
- 모집 인원 (number_of_people) — BIGINT
- 진행 방식 (progress_method) — ENUM('온라인', '오프라인', '온오프라인')
- 진행 기간 (duration) — VARCHAR
- 기술 스택 (tech_stack) — ENUM('Spring', 'React')
- 모집 포지션 (positions) — ENUM('백엔드','프론트엔드')
- 연락 방법 (contact_method) — VARCHAR
- 모집 마감일 (deadline) — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- user_id — BIGINT — Primary key — NOT NULL
- 닉네임 (nickname) — VARCHAR
- 직무 (job) — ENUM
- 소속 (group) — VARCHAR
- 경력 (experience) — BIGINT
- 소개 (introduction) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP