MateMatching

Tables (13)

ActivityType (활동종류)

  • id (활동유형번호) — Primary key — NOT NULL
  • name (활동명)

Availability (공강)

  • id (공강번호) — Primary key — NOT NULL
  • user_id (유저번호) — Foreign key → User.id — NOT NULL
  • day_of_week (요일)
  • start_time (공강시작)
  • end_time (공강종료)

Course (강좌)

  • id (과목번호) — Primary key — NOT NULL
  • course_code (교과목번호)
  • course_name (과목명)
  • department (개설학과)

CourseSection (강좌정보)

  • id (분반번호) — Primary key — NOT NULL
  • course_id (과목번호) — Foreign key → Course.id — NOT NULL
  • semester (학기)
  • professor (교수명)
  • section_number (분반)
  • day_of_week (요일)
  • start_time (시작시간)
  • end_time (종료시간)

Enrollment (수강신청)

  • id (수강등록번호) — Primary key — NOT NULL
  • course_section_id (분반번호) — Foreign key → CourseSection.id — NOT NULL
  • user_id (유저번호) — Foreign key → User.id — NOT NULL
  • created_at (등록일)

GroupMember (그룹멤버)

  • id (그룹멤버번호) — Primary key — NOT NULL
  • user_id (유저번호) — Foreign key → User.id — NOT NULL
  • group_id (그룹번호) — Foreign key → MatchGroup.id — NOT NULL
  • role (역할)
  • joined_at (참여일)

MatchGroup (그룹매칭)

  • id (그룹번호) — Primary key — NOT NULL
  • post_id (모집글번호(unique)) — Foreign key → MatchPost.id — NOT NULL
  • name (그룹명)
  • status (그룹상태)
  • created_at (생성일)

MatchPost (모집글)

  • id (모집글번호) — Primary key — NOT NULL
  • author_id (작성자번호) — Foreign key → User.id — NOT NULL
  • course_section_id (분반번호) — Foreign key → CourseSection.id — NOT NULL
  • activity_type_id (활동유형번호) — Foreign key → ActivityType.id — NOT NULL
  • place_id (장소번호) — Foreign key → Place.id — NOT NULL
  • title (제목)
  • content (내용)
  • match_basis (매칭기준)
  • is_online (온라인여부)
  • online_link (온라인링크)
  • start_at (시작일시)
  • end_at (종료일시)
  • max_members (모집인원)
  • status (모집상태)
  • created_at (작성일)

MatchRequest (참여신청)

  • id (신청번호) — Primary key — NOT NULL
  • post_id (모집글번호) — Foreign key → MatchPost.id — NOT NULL
  • requester_id (신청자번호) — Foreign key → User.id — NOT NULL
  • message (신청메세지)
  • status (신청상태)
  • created_at (신청일)

MeetingSchedule (만남일정)

  • id (일정번호) — Primary key — NOT NULL
  • group_id (그룹번호) — Foreign key → MatchGroup.id — NOT NULL
  • place_id (장소번호) — Foreign key → Place.id — NOT NULL
  • start_at (시작일시)
  • end_at (종료일시)
  • is_online (온라인여부)
  • oneline_link (온라인링크)
  • note (메모)

Place (장소)

  • id (장소번호) — Primary key — NOT NULL
  • name (장소명)
  • building (건물명)
  • detail (Field3)

User (사용자)

  • id (유저번호) — Primary key — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • nickname (닉네임)
  • created_at (가입일)

profile (프로필)

  • id (프로필번호) — Primary key — NOT NULL
  • user_id (유저번호) — Foreign key → User.id — NOT NULL
  • department (학과)
  • student_year (학번)
  • is_double_major (복수전공여부)
  • is_returning_student (복학생여부)
  • preferred_mode (선호방식)
  • intro (자기소개)