기말고사
테이블 (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