맞춤형 연구홍보 DB

테이블 (15)

ASJC_UniqueID_Final_dataset

  • ASJC_Code — int — NOT NULL
  • UniqueIDs — nvarchar(max)
  • CreatedDate — datetime2(3) — NOT NULL
  • IDCount — int

asjc_code

  • code — int — 기본 키 — NOT NULL
  • description — nvarchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

crawl_result

  • EID2 — nvarchar(max) — 기본 키 — NOT NULL
  • EID — nvarchar(max)
  • Authors — varchar(max)
  • Author_Full_Names — varchar(max)
  • Author_IDs — varchar(max)
  • Title — varchar(max)
  • Publication_Year — nvarchar(4)
  • Source_Title — varchar(max)
  • Volume — nvarchar(max)
  • Issue — nvarchar(max)
  • Article_Number — nvarchar(max)
  • Page_Start — nvarchar(max)
  • Page_End — nvarchar(max)
  • Page_Count — int
  • Cited_By — bigint
  • DOI — varchar(max)
  • Link — varchar(max)
  • Affiliations — varchar(max)
  • Authors_With_Affiliations — varchar(max)
  • Abstract — text
  • Author_Keywords — varchar(max)
  • Index_Keywords — varchar(max)
  • Molecular_Sequence_Numbers — varchar(max)
  • Chemicals_CAS — varchar(max)
  • Tradenames — varchar(max)
  • Manufacturers — varchar(max)
  • Funding_Details — varchar(max)
  • Funding_Texts — text
  • References — text
  • Correspondence_Address — varchar(max)
  • Editors — varchar(max)
  • Publisher — varchar(max)
  • Sponsors — varchar(max)
  • Conference_Name — varchar(max)
  • Conference_Date — text
  • Conference_Location — varchar(max)
  • Conference_Code — varchar(max)
  • ISSN — nvarchar(max)
  • ISBN — nvarchar(max)
  • CODEN — varchar(max)
  • PubMed_ID — varchar(max)
  • Language_Of_Original_Document — varchar(max)
  • Abbreviated_Source_Title — varchar(max)
  • Document_Type — varchar(max)
  • Publication_Stage — varchar(max)
  • Open_Access — varchar(max)
  • Source — varchar(max)
  • EID2 (EID22) — 외래 키 → crawl_target.EID2 — NOT NULL

crawl_result_correspondence_author_unique

  • Extracted_Email_Full — nvarchar(255) — 기본 키 — NOT NULL
  • ASJC_Count — int — NOT NULL
  • processed_date — date — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

crawl_result_normalized

  • Authors — varchar(max)
  • Author_Full_Names — varchar(max)
  • Author_IDs — varchar(max)
  • Title — varchar(max)
  • Publication_Year — nvarchar(4)
  • Source_Title — varchar(max)
  • Volume — nvarchar(max)
  • Issue — nvarchar(max)
  • Article_Number — nvarchar(max)
  • Page_Start — nvarchar(max)
  • Page_End — nvarchar(max)
  • Page_Count — int
  • Cited_By — bigint
  • DOI — varchar(max)
  • Link — varchar(max)
  • Affiliations — varchar(max)
  • Authors_With_Affiliations — varchar(max)
  • Abstract — text
  • Author_Keywords — varchar(max)
  • Index_Keywords — varchar(max)
  • Molecular_Sequence_Numbers — varchar(max)
  • Chemicals_CAS — varchar(max)
  • Tradenames — varchar(max)
  • Manufacturers — varchar(max)
  • Funding_Details — varchar(max)
  • Funding_Texts — text
  • References — text
  • Correspondence_Address — varchar(max)
  • Editors — varchar(max)
  • Publisher — varchar(max)
  • Sponsors — varchar(max)
  • Conference_Name — varchar(max)
  • Conference_Date — text
  • Conference_Location — varchar(max)
  • Conference_Code — varchar(max)
  • ISSN — nvarchar(max)
  • ISBN — nvarchar(max)
  • CODEN — varchar(max)
  • PubMed_ID — varchar(max)
  • Language_Of_Original_Document — varchar(max)
  • Abbreviated_Source_Title — varchar(max)
  • Document_Type — varchar(max)
  • Publication_Stage — varchar(max)
  • Open_Access — varchar(max)
  • Source — varchar(max)
  • EID — nvarchar(max)

crawl_result_normalized_final

  • Record_ID — int — 기본 키 — NOT NULL
  • Title — nvarchar(max)
  • Publication_Year — int
  • Correspondence_Address — nvarchar(max)
  • EID — nvarchar(max)
  • ASJC_Field_Name — nvarchar(max)
  • Extracted_Email_Full — nvarchar(max)
  • ASJC_Field_Name_Count — int
  • ASJC_Field_Name_Rank — int
  • Processing_Status — nvarchar(50)
  • Processing_Date — datetime
  • UniqueIDs — nvarchar(max)
  • IsProcessed — bit — NOT NULL
  • Unique_Extracted_Email_Full — int
  • NumAssignable — int
  • ASJC_Code — nvarchar(50)
  • Email_Seq — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

crawl_target

  • EID2 — 기본 키 — NOT NULL
  • EID — nvarchar(max)
  • Title — varchar(max)
  • Authors — varchar(max)
  • Number_of_Authors — nvarchar(max)
  • Scopus_Author_Ids — nvarchar(max)
  • Year — nvarchar(max)
  • Full_date — date
  • Scopus_Source_Title — nvarchar(max)
  • Volume — nvarchar(max)
  • Issue — nvarchar(max)
  • Pages — nvarchar(max)
  • Article_Number — nvarchar(max)
  • ISSN — nvarchar(max)
  • Source_ID — nvarchar(max)
  • Source_Type — nvarchar(max)
  • Language — nvarchar(max)
  • SNIP_Publication_Year — bigint
  • SNIP_Percentile_Publication_Year — bigint
  • CiteScore_Publication_Year — bigint
  • CiteScore_Percentile_Publication_Year — bigint
  • SJR_Publication_Year — bigint
  • SJR_Percentile_Publication_Year — bigint
  • Field_Weighted_View_Impact — bigint
  • Views — bigint
  • Citations — bigint
  • Field_Weighted_Citation_Impact — bigint
  • Field_Citation_Average — bigint
  • Outputs_Top_Citation_Percentiles_Per_Percentile — nvarchar(max)
  • Field_Weighted_Outputs_Top_Citation_Percentiles_Per_Percentile — bigint
  • Patent_Citations — bigint
  • Media_Citations — bigint
  • Reference — nvarchar(max)
  • Abstract — nvarchar(max)
  • DOI — nvarchar(max)
  • Publication_Type — nvarchar(max)
  • Open_Access — nvarchar(max)
  • PubMed_ID — nvarchar(max)
  • Institutions — nvarchar(max)
  • Number_of_Institutions — bigint
  • Scopus_Affiliation_IDs — nvarchar(max)
  • Scopus_Affiliation_Names — varchar(max)
  • Scopus_Author_ID_First_Author — nvarchar(max)
  • Scopus_Author_ID_Last_Author — nvarchar(max)
  • Scopus_Author_ID_Corresponding_Author — varchar(max)
  • Scopus_Author_ID_Single_Author — nvarchar(max)
  • Country_Region — varchar(max)
  • Number_of_Countries_Regions — int
  • ASJC_Code — varchar(max)
  • ASJC_Field_Name — varchar(max)
  • QS_Subject_Area_Code — nvarchar(max)
  • QS_Subject_Area_Field_Name — nvarchar(max)
  • QS_Subject_Code — nvarchar(max)
  • QS_Subject_Field_Name — nvarchar(max)
  • THE_Code — nvarchar(max)
  • THE_Field_Name — nvarchar(max)
  • ANZSRC_FoR_Parent_Code — nvarchar(max)
  • ANZSRC_FoR_Parent_Name — nvarchar(max)
  • ANZSRC_FoR_Code — nvarchar(max)
  • ANZSRC_FoR_Name — nvarchar(max)
  • … +8

email_asjc_ranked

  • Email — nvarchar(255) — 기본 키 — NOT NULL
  • Rank — int — 기본 키 — NOT NULL
  • ASJC_Field_Name — nvarchar(255)
  • ASJC_Count — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

globalbranding_eDM_history

  • ISSUE — nvarchar(max)
  • Description — nvarchar(max)
  • EID — nvarchar(max)
  • Title — nvarchar(max)
  • FWCI_Percentiles — nvarchar(max)
  • FWCI — float
  • Unqualified_ASJC — nvarchar(max)
  • Unqualified_Rationale — nvarchar(max)
  • 참여역할_수정 — nvarchar(max)
  • DOI — nvarchar(max)
  • 발송여부 — nvarchar(max)
  • CreatedAt — datetime

globalbranding_eDM_history_alt_2

  • ISSUE — nvarchar(max)
  • Description — nvarchar(max)
  • EID — nvarchar(max)
  • Title — nvarchar(max)
  • FWCI_Percentiles — nvarchar(max)
  • FWCI — float
  • Unqualified_ASJC — nvarchar(max)
  • Unqualified_Rationale — nvarchar(max)
  • 참여역할_수정 — nvarchar(max)
  • DOI — nvarchar(max)
  • 발송여부 — nvarchar(max)
  • CreatedAt — datetime
  • Extracted_Email_Full — nvarchar(255)

globalbranding_eDM_matching_stats

  • ISSUE — nvarchar(max)
  • Extracted_Email_Full — nvarchar(max)
  • NumAssignable — int
  • GroupLabel — nvarchar(max)
  • CreatedAt — datetime
  • ASJC_Field_Name — nvarchar(max)

globalbranding_eDM_scheduler_alt_2

  • ISSUE — nvarchar(max)
  • Description — nvarchar(max)
  • EID — nvarchar(max)
  • Title — nvarchar(max)
  • FWCI_Percentiles — nvarchar(max)
  • FWCI — float
  • Unqualified_ASJC — nvarchar(max)
  • Unqualified_Rationale — nvarchar(max)
  • 참여역할_수정 — nvarchar(max)
  • DOI — nvarchar(max)
  • CreatedAt — datetime
  • Extracted_Email_Full — nvarchar(255)
  • UniqueIDs — nvarchar(max)

publication_yonsei_faculty

  • ASJC_Code — smallint
  • Description — nvarchar(max)
  • RankInASJC_Narrow — smallint
  • RankInASJC_Broad — smallint
  • Field_Weighted_Citation_Impact — float
  • Field_Weighted_Outputs_in_Top_Citation_Percentiles_per_percentile — tinyint
  • Year — smallint
  • Open_Access — nvarchar(max)
  • Number_of_Authors — smallint
  • 참여역할 — nvarchar(max)
  • 성명 — nvarchar(max)
  • 학과 — nvarchar(max)
  • EID — nvarchar(max)
  • DOI — nvarchar(max)
  • Title — nvarchar(max)
  • 학술지명 — nvarchar(max)
  • 참여역할_수정 — nvarchar(max)
  • OAJ여부 — nvarchar(max)
  • FWCI_Percentiles — nvarchar(max)
  • ASJC_Code_Broad — tinyint
  • Mapped_ASJC — nvarchar(max)
  • Rationale — nvarchar(max)
  • Unqualified_ASJC — nvarchar(max)
  • Unqualified_Rationale — nvarchar(max)
  • Abstract — nvarchar(max)
  • Abstract_크롤링여부 — nvarchar(max)
  • UniqueID — int
  • UniqueID_Final — nvarchar(max)
  • 개인번호 — nvarchar(50)
  • 이메일 — nvarchar(200)

publication_yonsei_faculty_abstract

  • Authors — nvarchar(max)
  • Author_full_names — nvarchar(max)
  • Author_s_ID — nvarchar(max)
  • Title — nvarchar(max)
  • Year — nvarchar(max)
  • Source_title — nvarchar(max)
  • Volume — nvarchar(max)
  • Issue — nvarchar(max)
  • Art_No — nvarchar(max)
  • Page_start — nvarchar(max)
  • Page_end — nvarchar(max)
  • Page_count — nvarchar(max)
  • Cited_by — nvarchar(max)
  • DOI — nvarchar(max)
  • Link — nvarchar(max)
  • Affiliations — nvarchar(max)
  • Authors_with_affiliations — nvarchar(max)
  • Abstract — nvarchar(max)
  • Author_Keywords — nvarchar(max)
  • Index_Keywords — nvarchar(max)
  • Molecular_Sequence_Numbers — nvarchar(max)
  • Chemicals_CAS — nvarchar(max)
  • Tradenames — nvarchar(max)
  • Manufacturers — nvarchar(max)
  • Funding_Details — nvarchar(max)
  • Funding_Texts — nvarchar(max)
  • References — nvarchar(max)
  • Correspondence_Address — nvarchar(max)
  • Editors — nvarchar(max)
  • Publisher — nvarchar(max)
  • Sponsors — nvarchar(max)
  • Conference_name — nvarchar(max)
  • Conference_date — nvarchar(max)
  • Conference_location — nvarchar(max)
  • Conference_code — nvarchar(max)
  • ISSN — nvarchar(max)
  • ISBN — nvarchar(max)
  • CODEN — nvarchar(max)
  • PubMed_ID — nvarchar(max)
  • Language_of_Original_Document — nvarchar(max)
  • Abbreviated_Source_Title — nvarchar(max)
  • Document_Type — nvarchar(max)
  • Publication_Stage — nvarchar(max)
  • Open_Access — nvarchar(max)
  • Source — nvarchar(max)
  • EID — nvarchar(max) — NOT NULL

stage_faculty_info

  • ASJC_Code — smallint
  • Name — nvarchar(50)
  • Affiliation — nvarchar(50)
  • EID — nvarchar(50)
  • ID — nvarchar(50)
  • email — nvarchar(50)