research_affiliation

Data license: Space charter; records cite primary sources · Data source: TeamScience Space repository

1 row where institution_id = "I103193709"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: checked_ts (date)

CREATE TABLE research_affiliation (
  lom_id TEXT NOT NULL,
  author_id TEXT NOT NULL,
  institution_id TEXT NOT NULL REFERENCES institution(id),
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL,
  PRIMARY KEY (lom_id, author_id, institution_id),
  FOREIGN KEY (lom_id, author_id) REFERENCES paper_author(lom_id, author_id)
);
CREATE INDEX research_affiliation_author ON research_affiliation(author_id);
CREATE INDEX research_affiliation_institution ON research_affiliation(institution_id);