OpenAlex ERD v2

Tables (7)

Author

  • author_id — string — Primary key — NOT NULL
  • author_name — string — NOT NULL — display_name
  • orcid — string
  • works_count — int
  • cited_by_count — int
  • institution_id — string — Foreign key → Institution.institution_id — 저자가 속한 기관ID (가장 최신 논문 기준)/last_known_institutions.id

Institution

  • institution_id — string — Primary key — NOT NULL
  • institution_name — string — NOT NULL — display_name
  • country_code — string
  • type — string
  • geo_lat — float — geo.latitude
  • geo_long (geo_lon) — float — geo.longitude
  • works_count — int
  • cited_by_count — int — 해당 기관에서 제출된 논문의 피인용수 총합
  • Field

Source

  • source_id — string — Primary key — NOT NULL
  • source_name — string — 저널, 책 등의 이름
  • type — string
  • works_count — int — 해당 source에 게재된 논문수

Topic

  • topic_id — string — Primary key — NOT NULL
  • topic — string — NOT NULL — display_name
  • domain — string — domain.display_name
  • field — string — field.display_name
  • Field (subfield) — string — subfield.display_name
  • works_count — int — 해당 토픽으로 태그된 논문의 총 개수
  • cited_by_count — int — 해당 토픽으로 태그된 모든 논문들이 받은 인용 수

Work

  • work_id — string — Primary key — NOT NULL
  • title — string — NOT NULL
  • doi — string
  • publication_date — date
  • type — string — article, book 등
  • is_oa — boolean
  • primary_topic_id — string — primary_topic.id
  • domain — string — primary_topic.domain.display_name / 수집할 데이터 스코프를 지정해서 현재는 "Physical Sciences"가 유일
  • field — string — primary_topic.field.display_name / "Computer Science"가 유일
  • Field (subfield) — string — primary_topic.subfield.display_name
  • citations_past_decade — int — counts_by_year의 모든 cited_by_count 값 sum
  • created_date — date
  • source_id — string — Foreign key → Source.source_id
  • Field (first_institution_id) — string
  • Field (keywords) — string — keywords 의 display_name CONCAT

WorkAuthor

  • work_id — string — Foreign key → Work.work_id — NOT NULL
  • author_id — string — Foreign key → Author.author_id — NOT NULL
  • author_position — string — 1저자:first, 2저자~N-1저자 : middle, N저자 : last/ work의 authorships.author_position

WorkTopic

  • work_id — string — Foreign key → Work.work_id — NOT NULL
  • topic_id — string — Foreign key → Topic.topic_id — NOT NULL
  • score — float — 연관도 점수
  • order — int — 1~3