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