spotset

8 rows where publisher = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: extern

id ▼ name publisher extern
1 Brand Community Network (BCN) Brand Community Network (BCN) 1 1
2 Brand Community Network (BCN) (1) Brand Community Network (BCN) 1 1
3 Brand Community Network (BCN) (2) Brand Community Network (BCN) 1 1
4 Brand Community Network (BCN) (3) Brand Community Network (BCN) 1 1
36 Brand Community Network (BCN) (4) Brand Community Network (BCN) 1 0
37 Brand Community Network (BCN) (5) Brand Community Network (BCN) 1 0
38 Brand Community Network (BCN) (6) Brand Community Network (BCN) 1 0
39 Brand Community Network (BCN) (7) Brand Community Network (BCN) 1 0

Advanced export

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

CSV options: 

CREATE TABLE spotset (
	id INTEGER NOT NULL, 
	name VARCHAR(250), 
	publisher INTEGER, 
	extern BOOLEAN, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE UNIQUE INDEX ix_spotset_name ON spotset (name);
CREATE INDEX ix_spotset_extern ON spotset (extern);
CREATE INDEX ix_spotset_publisher ON spotset (publisher);