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