문해프 최종보고서

테이블 (8)

1on1 matching (3)

  • user_Nickname — varchar — 외래 키 → logged-in user.user_Nickname
  • other_user_Nickname — varchar — 외래 키 → other_user.other_user_Nickname
  • user_StudentId — int
  • user_Gendet — varcahr
  • user_MBTI — varcahr
  • user_Selfintroduce — varchar
  • user_MyheartCount — int
  • other_user_StudentId — int
  • other_user_Gender — varchar
  • other_user_MBTI — varcahr
  • other_user_Selfintroduce — varchar
  • other_user_MyheartCount — int

Registered_user (DataBase)

  • user_Email — varchar — 기본 키
  • user_Password — varchar
  • user_Nickname — varchar
  • user_StudentId — int
  • user_Gender — varchar
  • user_MBTI — varchar
  • user_Selfintroduce — varchar
  • user_MyheartCount — int

logged-in user (2)

  • user_Nickname — varchar — 기본 키
  • user_Email — varchar — 외래 키 → login.user_Email
  • user_StuendtId — int
  • user_Gender — varchar
  • user_MBTI — varchar
  • user_SelfIntroduce — varchar
  • user_MyheartCount — int

login (1)

  • user_Email — varchar — 외래 키 → Registered_user.user_Email
  • user_Password — varchar

manager_login (7)

  • manager_Password — varchar — 기본 키
  • user_Email — varchar — 외래 키 → Registered_user.user_Email

open_chat (5)

  • user_Nickname — varchar — 외래 키 → logged-in user.user_Nickname
  • other_user_Nickname — varchar — 외래 키 → other_user.other_user_Nickname

other_user (4)

  • other_user_Nickname — varchar — 기본 키
  • other_user_StudentId — int
  • other_user_Gender — varchar
  • other_user_MBTI — varchar
  • other_user_Selfintroduce — varchar
  • other_user_MyheartCount — int

registered_user (dataBase)

  • user_Email — varchar — 기본 키
  • user_Password — varchar
  • user_Nickname — varchar
  • user_StudentId — int
  • user_Gender — varchar
  • user_MBTI — varchar
  • user_Selfintroduce — varchar
  • user_MyheartCount — int