솔리드 커넥션 베타 최종

테이블 (10)

application

  • id — int
  • first_choice_univ_id — int — NOT NULL
  • second_choice_univ_id — int — NOT NULL
  • site_user_id — int — NOT NULL
  • language_test_type — varchar(10) — NOT NULL
  • language_test_score — float — NOT NULL
  • language_test_report_url — varchar(500) — NOT NULL
  • grade — float — NOT NULL
  • grade_report_url — varchar(500) — NOT NULL
  • verify_status — varchar(50) — NOT NULL

country

  • id — char(2)
  • region_id — varchar(10)
  • name — varchar(100) — NOT NULL

grade_requirement

  • id — int
  • university_id — int
  • scale — varchar(5) — NOT NULL
  • min_grade — float — NOT NULL

interested_country

  • id — int
  • site_user_id — int
  • country_id — char(2)

interested_region

  • id — int
  • site_user_id — int
  • region_id — varchar(10)

language_requirement

  • id — int
  • university_id — int
  • test_type — varchar(10) — NOT NULL
  • min_score — float

region

  • id — varchar(10)

site_user

  • id — int
  • email — varchar(100) — NOT NULL
  • nickname — varchar(100) — NOT NULL
  • preparation_stage — varchar(50) — NOT NULL
  • profile_image_url — varchar(500)
  • nickname_last_modified_time — timestamp — NOT NULL

university

  • id — int
  • country_id — char(2)
  • region_id — varchar(10)
  • korean_name — varchar(100) — NOT NULL
  • english_name — varchar(100) — NOT NULL
  • recruit_number — int — NOT NULL
  • payment_type — varchar(50) — NOT NULL
  • exchange_semester — varchar(50) — NOT NULL
  • details_for_language — varchar(1000)
  • details_for_apply — varchar(1000)
  • details_for_major — varchar(1000)
  • details_for_accommodation — varchar(1000)
  • homepage_url — varchar(500)
  • emglish_course_url — varchar(500)
  • accommodation_url — varchar(500)
  • details — varchar(500)
  • logo_image_url — varchar(500) — NOT NULL
  • background_image_url — varchar(500) — NOT NULL

wish_university

  • id — int
  • site_user_id — int — NOT NULL
  • univresity_id — int — NOT NULL