FC-BACKEND

Tables (6)

Comment (댓글)

  • Key (comment_id) — Primary key — NOT NULL
  • PK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • Field (content)
  • Field (created_at)
  • Field (updated_at)

Meeting (모임)

  • Key (meeting_id) — Primary key — NOT NULL
  • 모임 이름 (name)
  • 모집 인원 (recruit_number)
  • 카테고리 (category)
  • 모집 시작 날짜 (recruit_start)
  • 모집 종료 날짜 (recruit_end)
  • 모집 상태 (status)
  • 내용 (content)

Meeting_member (모임 참여자)

  • Key (meeting_member_id) — Primary key — NOT NULL
  • 신청 시각 (register_date)
  • PK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • Key (meeting_id) — Foreign key → Meeting.Key — NOT NULL

Post (게시글)

  • Key (post_id) — Primary key — NOT NULL
  • PK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 제목 (title)
  • 내용 (content)
  • 파트 (part)
  • 학년 (grade)
  • 주제 (topic)
  • Field (created_at)
  • Field (updated_at)

User (사용자)

  • PK (user_id) — BIGINT — Primary key — NOT NULL
  • 이름 (name)
  • 이메일 (email) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 전화번호 (phone) — VARCHAR
  • 학번 (student_number) — VARCHAR
  • Field (created_at)
  • Field (updated_at)

post_scrap (스크랩한 게시물)

  • Key — Primary key — NOT NULL
  • Field (created_at)
  • Key (post_id) — Foreign key → Post.Key — NOT NULL
  • PK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL