labels

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

1 row where publisher_id = "PUB_23TJJE7R22TG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: aliases (array)

CREATE TABLE labels (
      id TEXT PRIMARY KEY,
      publisher_id TEXT NOT NULL,
      geoblock_id TEXT,
      name TEXT NOT NULL,
      aliases TEXT NOT NULL,
      FOREIGN KEY (publisher_id) REFERENCES publishers(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_labels_publisher ON labels(publisher_id);
CREATE INDEX idx_labels_geoblock ON labels(geoblock_id);