home / media

actress_aliases

3 rows where a_uid = "a_qpqf6"

This data as json, CSV (advanced)

Link a_uid aliasKey alias
erikakitagawa,a_qpqf6 Erika Kitagawa a_qpqf6 erikakitagawa Erika Kitagawa
きたがわえりか,a_qpqf6 Erika Kitagawa a_qpqf6 きたがわえりか きたがわえりか
北川エリカ,a_qpqf6 Erika Kitagawa a_qpqf6 北川エリカ 北川エリカ

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE actress_aliases (
  a_uid    TEXT NOT NULL REFERENCES actresses(uid) ON DELETE CASCADE,
  aliasKey TEXT NOT NULL,
  alias    TEXT NOT NULL,
  PRIMARY KEY (aliasKey, a_uid)
);
CREATE INDEX idx_actress_aliases_uid ON actress_aliases(a_uid);
Powered by Datasette · Queries took 3.589ms