swyp

Tables (15)

Category (카테고리)

  • category_id (Key2) — Primary key — NOT NULL
  • name (카테고리명)

Evaluation (평점)

  • evaluation_id (Key) — Primary key — NOT NULL
  • rating (평점)
  • to_id (평가받는사람) — Foreign key → User.user_id — NOT NULL
  • from_id (평가 하는 사람)

Favoite_Study (찜 스터디)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • study_id (Key2) — Foreign key → Study.study_id — NOT NULL

Quick_filter (Untitled)

  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • start_date (Field)
  • duration (Field2)
  • tendency (Field3)
  • Field4
  • category_id (Key2) — Foreign key → Category.category_id — NOT NULL

Search (검색어)

  • serach_id (Key) — Primary key — NOT NULL
  • keyword (검색어)
  • count (검색 횟수)

Study (스터디)

  • study_id (Key) — Primary key — NOT NULL
  • title (제목)
  • description (설명)
  • start_date (시작 날짜)
  • end_date (종료 날짜)
  • duration (기간)
  • max_participants_num (최대 참여 인원)
  • cur_participants_num (현재 참여 인원)
  • tendency (스터디 성향)
  • status (스터디 진행 상태)
  • recruit_status (스터디 모집 상태)
  • matching_type (빠른 매칭 사용 여부)
  • created_time (생성시간)
  • view_count (조회수)
  • category_id (Key2) — Foreign key → Category.category_id — NOT NULL

Todo_private (개인 공부 목표 체크리스트)

  • todo_id (Key) — Primary key — NOT NULL
  • content (체크리스트 내용)
  • date (날짜)
  • complete (체크 여부)
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • Parent_id (Key3) — Foreign key → Todo_public.todo_id — NOT NULL
  • study_id (Key4) — Foreign key → Study.study_id — NOT NULL

Todo_public (공부 목표 체크리스트)

  • todo_id (Key) — Primary key — NOT NULL
  • content (체크리스트 내용)
  • date (날짜)
  • study_id (Key2) — Foreign key → Study.study_id — NOT NULL

User (회원)

  • user_id (Key) — Primary key — NOT NULL
  • role (권한)
  • email (이메일)
  • validate (Field)
  • nickname (닉네임)
  • join_date (가입 시기)
  • profile_image (프로필 이미지)
  • withdrawal_date (탈되 시기)

User_Study (회원별 참여 스터디 목록)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • study_id (Key2) — Foreign key → Study.study_id — NOT NULL
  • is_owner (방장 여부)
  • exit_status (이탈/강퇴 여부)
  • join_date (참여 날짜)

User_search (유저별 검색어)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • serach_id (Key2) — Foreign key → Search.serach_id — NOT NULL
  • count (검색 횟수)
  • update_time (검색 시간)

additional_info (추가 정보)

  • additional_info_id (추가정보ID) — Primary key — NOT NULL
  • name (추가정보명)
  • study_id (Key) — Foreign key → Study.study_id — NOT NULL

exit_reasons (이탈/강퇴 이유)

  • exit_reasons_id (Key) — Primary key — NOT NULL
  • reason (Field)

join_request (스터디 승인 대기목록)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • study_id (Key2) — Foreign key → Study.study_id — NOT NULL
  • request_date (승인 요청 날짜)
  • join_status (스터디 승인 여부)

user_study_exit (회원별 스터디 이탈/강퇴 이유)

  • user_id (Key) — Foreign key → User_Study.user_id — NOT NULL
  • study_id (Key2) — Foreign key → User_Study.study_id — NOT NULL
  • exit_reasons_id (Key3) — Foreign key → exit_reasons.exit_reasons_id — NOT NULL
  • exit_date (이탈/강퇴 날짜)