network

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE network (
	id INTEGER NOT NULL, 
	parent VARCHAR, 
	name VARCHAR(250), 
	venue_id VARCHAR, 
	publisher INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(parent) REFERENCES network (id), 
	FOREIGN KEY(venue_id) REFERENCES venue_taxonomy (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_network_publisher ON network (publisher);
CREATE INDEX ix_network_parent ON network (parent);
CREATE UNIQUE INDEX ix_network_name ON network (name);
CREATE INDEX ix_network_venue_id ON network (venue_id);