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 (이탈/강퇴 날짜)