actress_aliases

4 rows where a_uid = "a_bupsr"

This data as json, CSV (advanced)

Suggested facets: alias

Link a_uid aliasKey alias
aliceotsu,a_bupsr Alice Otsu a_bupsr aliceotsu Alice Otsu
ariceotu,a_bupsr Alice Otsu a_bupsr ariceotu Alice Otsu
おつありす,a_bupsr Alice Otsu a_bupsr おつありす おつありす
乙アリス,a_bupsr Alice Otsu a_bupsr 乙アリス 乙アリス

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);