데이타베이스

테이블 (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)