기말고사

테이블 (6)

Untitled (SITE_TYPE)

  • Key (type_id) — 기본 키 — NOT NULL
  • Field (type_code)
  • Field (type_name)

recommendations (REECOMMENDATION)

  • recommendation_id — INT — 기본 키
  • request_id — INT — 외래 키 → search_requests.request_id
  • site_id — INT — 외래 키 → sites.site_id
  • rank_order — INT — NOT NULL
  • score — INT — NOT NULL

search_requests (SEARCH_REQUEST)

  • request_id — INT — 기본 키
  • user_id — INT — 외래 키 → users.user_id
  • university_id — INT — 외래 키 → universities.university_id
  • title — VARCHAR(500)
  • author_name — VARCHAR(200)
  • author_name_en — VARCHAR(200)
  • language_code (language) — VARCHAR(10)
  • degree_level (degree) — VARCHAR(20)
  • region_code (region) — VARCHAR(20)
  • issued_year (pub_year) — VARCHAR(50)

sites (SITE)

  • site_id — INT — 기본 키
  • university_id — INT — 외래 키 → universities.university_id
  • Key (type_id) — 외래 키 → Untitled.Key — NOT NULL
  • site_name — VARCHAR(200) — NOT NULL
  • site_url — VARCHAR(500) — NOT NULL
  • priority_rank — INT — NOT NULL
  • created_at — DATE — NOT NULL

universities (UNIVERSITY)

  • university_id — INT — 기본 키
  • uni_name_ko — VARCHAR(200) — NOT NULL
  • uni_name_en — VARCHAR(200)
  • country_code — VARCHAR(10) — NOT NULL
  • korea_univ_code — VARCHAR(10)
  • library_url — VARCHAR(500)

users (USER)

  • user_id — INT — 기본 키
  • user_name (name) — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL