기말고사
테이블 (7)
INSTITUTIONS
- institution_id — INT
- institution_name — VARCHAR(200) — NOT NULL
- country_code — VARCHAR(10) — NOT NULL
- library_site_url — VARCHAR(500)
RECOMMENDATIONS
- recommendation_id — INT
- search_id — INT — NOT NULL
- site_id — INT — NOT NULL
- rank_no — INT — NOT NULL
- reason — VARCHAR(300
SEARCHES
- search_id — INT
- user_id — INT — NOT NULL
- searched_at — DATETIME — NOT NULL
- input_title — VARCHAR(500)
- input_author_name — VARCHAR(200)
- input_author_name_en — VARCHAR(200)
- input_language_code — VARCHAR(10)
- input_institution_name — VARCHAR(200)
- input_degree_level — VARCHAR(20)
- input_keywords — TEXT
SITES
- site_id — INT
- site_name — VARCHAR(200) — NOT NULL
- site_url — VARCHAR(500) — NOT NULL
- site_type — VARCHAR(50) — NOT NULL
- country_code — VARCHAR(10)
- description — TEXT
SITE_COVERAGE_RULE
- rule_id — INT
- site_id — INT — NOT NULL
- language_code — VARCHAR(10)
- country_code — VARCHAR(10)
- institution_id — INT
- access_level — VARCHAR(30) — NOT NULL
- priority_score — INT — NOT NULL
THESES
- thesis_id — INT
- title — VARCHAR(500) — NOT NULL
- author_name — VARCHAR(200) — NOT NULL
- author_name_en — VARCHAR(200)
- language_code — VARCHAR(10) — NOT NULL
- degree_level — VARCHAR(20) — NOT NULL
- major — VARCHAR(200)
- publish_year — INT
- institution_id — INT
- keywords — TEXT
USERS
- user_id — INT
- user_name — VARCHAR(100) — NOT NULL
- email — VARCHAR(200) — NOT NULL