맞춤형 연구홍보 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)