research_lab

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

0 rows where institution_id = "I102134673"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE research_lab (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  kind TEXT NOT NULL CHECK(kind IN ('laboratory','research_group','research_program','research_project','research_collaboration')),
  institution_id TEXT NOT NULL REFERENCES institution(id),
  website TEXT NOT NULL,
  description TEXT NOT NULL,
  status TEXT NOT NULL CHECK(status IN ('reported','forming','historical')),
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL
);
CREATE INDEX research_lab_institution ON research_lab(institution_id);