문해프 최종보고서
테이블 (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