building

27,365 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Next page

CREATE TABLE building (
	id VARCHAR(100) NOT NULL, 
	name_publisher VARCHAR(250), 
	previous_id VARCHAR(100), 
	poc_present BOOLEAN, 
	venue_id VARCHAR, 
	count_screens INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	UNIQUE (previous_id), 
	FOREIGN KEY(venue_id) REFERENCES venue_taxonomy (id)
);
CREATE INDEX ix_building_count_screens ON building (count_screens);
CREATE INDEX ix_building_name_publisher ON building (name_publisher);
CREATE INDEX ix_building_venue_id ON building (venue_id);