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 (자기소개)