building

31 rows where publisher = 16

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

CREATE TABLE building (
	id VARCHAR(100) NOT NULL, 
	name_publisher VARCHAR(250), 
	publisher INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_building_publisher ON building (publisher);
CREATE INDEX ix_building_name_publisher ON building (name_publisher);