final
Tables (6)
provider
- provider_id — INT
- provider_name — VARCHAR(200) — NOT NULL
- provider_type — VARCHAR(20) — NOT NULL
- base_url — VARCHAR(500)
- priority — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_date — DATE — NOT NULL
provider_url_template
- template_id — INT
- provider_id — INT — NOT NULL
- template_name — VARCHAR(200) — NOT NULL
- url_template — VARCHAR(2000) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_by — INT — NOT NULL
- created_date — DATE — NOT NULL
- updated_date — DATE
search_log
- log_id — INT
- query_id — INT — NOT NULL
- provider_id — INT — NOT NULL
- template_id — INT — NOT NULL
- generated_url — VARCHAR(2000) — NOT NULL
- result_status — VARCHAR(20) — NOT NULL
- fail_reason — VARCHAR(300)
- created_date — DATE — NOT NULL
search_query
- query_id — INT
- requested_by — INT — NOT NULL
- paper_title — VARCHAR(500)
- author_name — VARCHAR(200)
- degree_type — VARCHAR(20)
- publish_year — INT
- publish_univ — VARCHAR(200)
- query_note — VARCHAR(500)
- created_date — DATE — NOT NULL
user_account
- user_id — INT
- user_name — VARCHAR(100) — NOT NULL
- user_role — VARCHAR(20) — NOT NULL
- created_date — DATE — NOT NULL