lab_membership

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

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_id, role, status, note, checked_ts (date)

CREATE TABLE lab_membership (
  id TEXT PRIMARY KEY,
  lab_id TEXT NOT NULL REFERENCES research_lab(id),
  author_id TEXT NOT NULL REFERENCES author(author_id),
  role TEXT NOT NULL,
  status TEXT NOT NULL CHECK(status IN ('reported','historical','forming')),
  period TEXT,
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL,
  note TEXT,
  UNIQUE(lab_id,author_id,source_url)
);
CREATE INDEX lab_membership_author ON lab_membership(author_id);