mentorverse
Tables (6)
Community (고민버스)
- id (식별자) — Varchar — Primary key — NOT NULL
- user_id (계정명) — Varchar — Foreign key → user.user_id — NOT NULL
- subject (제목) — Varchar — NOT NULL
- contents (내용) — Varchar — NOT NULL
- tag (태그) — Varchar[] — NOT NULL
- create_at (생성일) — datetime — NOT NULL
- update_at (수정일) — datetime
Community_coment (댓글세부)
- id (식별자) — Varchar — Foreign key → Community.id — NOT NULL
- user_id (계정명) — Varchar — Foreign key → Community.user_id — NOT NULL
- comment (댓글) — Varchar — NOT NULL
- Status (상태) — Varchar — NOT NULL — ['Alive, Removed, Chnaged']
- create_at (생성일) — Datetime — NOT NULL
- update_at (수정일) — Datetime
mentoring (생성된 멘토링)
- id (식별자) — Varchar — Primary key — NOT NULL
- user_id (계정명) — Varchar — Foreign key → user.user_id — NOT NULL
- subject (제목) — Varchar — NOT NULL
- user_max (최대 유저 수) — Number — NOT NULL
- create_at (생성일) — Datetime — NOT NULL
- update_at (수정일) — Datetime
mentoring_detail (멘토링 세부정보)
- id (식별자) — Varchar — Foreign key → mentoring.id — NOT NULL
- user_id (계정명) — Varchar — Foreign key → mentoring.user_id — NOT NULL
- client_list (멘티) — Varchar[] — NOT NULL
- url (게더타운 url) — Varchar — NOT NULL
- target (참가 대상) — Varchar[] — NOT NULL
- type (공개 여부) — Boolean — NOT NULL
user (사용자 정보)
- user_id (계정명) — Varchar — Primary key — NOT NULL
- user_name (사용자 이름) — Varchar — NOT NULL
- nickname (Field) — Varchar — NOT NULL
- email (Field2) — Varchar — NOT NULL
- password (비밀번호) — Varchar — NOT NULL
- login_type (소셜계졍여부) — Boolean — NOT NULL
- is_mentor (멘토가입여부) — Boolean — NOT NULL
- create_at (생성일) — Datetime — NOT NULL
- update_at (수정일) — Datetime
user_detail (사용자 세부정보)
- user_id (계정명) — Varchar — Foreign key → user.user_id — NOT NULL
- interest_univ (관심대학) — Varchar
- interest_type (관심분야) — Varchar
- course (진로) — Varchar — NOT NULL
- profile_image (프로필 이미지) — Varchar
- belong_to (소속 학교) — Varchar — NOT NULL
- favorite (즐겨찾기 게시글 목록) — Varchar[] — NOT NULL