데이타베이스
테이블 (8)
career_path
- direction — varchar(30)
- student_id (Key) — varchar(15) — 외래 키 → user_info.student_id — NOT NULL
eating_style
- nickname — varchar(30) — NOT NULL
- source — varchar(30)
- mint — varchar(30)
- student_id (Key) — varchar(15) — 외래 키 → user_info.student_id — NOT NULL
favorite_course
- nickname — char(100)
- course — char(100)
- student_id (Key) — varchar(15) — 외래 키 → user_info.student_id — NOT NULL
favorite_food
- nickname — varchar(30)
- food — varchar(30)
- student_id (Key) — varchar(15) — 외래 키 → user_info.student_id — NOT NULL
friend_info
- nickname — varchar(30)
- friend_nickname — varchar(30)
mbti
- nickname — char(100) — NOT NULL
- gender — char(10)
- mbti_type — char(4)
preferred_pl
- nickname — varchar(30)
- lang — varchar(30)
user_info
- student_id (Key) — varchar(15) — 기본 키 — NOT NULL
- name — varchar(30)
- section — varchar(15)
- nickname — varchar(30)