솔리드 커넥션 베타 최종
테이블 (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
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