people

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

109 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, wiki, sort_actor, sort_artist, sort_author, sort_designer, sort_mathematician, sort_philosopher, sort_poet

Next page

CREATE TABLE "people" (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  slug TEXT UNIQUE NOT NULL,
  name TEXT NOT NULL,
  type TEXT NOT NULL,
  image TEXT,
  wiki TEXT,
  sort_actor INTEGER DEFAULT 999,
  sort_artist INTEGER DEFAULT 999,
  sort_author INTEGER DEFAULT 999,
  sort_designer INTEGER DEFAULT 999,
  sort_mathematician INTEGER DEFAULT 999,
  sort_musician INTEGER DEFAULT 999
, sort_philosopher INTEGER DEFAULT 999, sort_poet INTEGER DEFAULT 999);
CREATE INDEX idx_people_type ON people(type);
CREATE INDEX idx_people_slug ON people(slug);