competition

205 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, region, created_at (date), updated_at (date)

Next page

CREATE TABLE competition (
	competition_id INTEGER NOT NULL, 
	name VARCHAR(128) NOT NULL, 
	slug VARCHAR(64) NOT NULL, 
	type VARCHAR(32) NOT NULL, 
	region VARCHAR(64), 
	tier INTEGER, 
	is_active BOOLEAN NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	created_by_run_id INTEGER, 
	updated_by_run_id INTEGER, 
	source_id INTEGER NOT NULL, 
	source_raw_key VARCHAR(512), 
	PRIMARY KEY (competition_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id)
);
CREATE UNIQUE INDEX ix_competition_name ON competition (name);
CREATE INDEX ix_competition_source_raw_key ON competition (source_raw_key);
CREATE UNIQUE INDEX ix_competition_slug ON competition (slug);
CREATE INDEX ix_competition_source_id ON competition (source_id);
CREATE INDEX ix_competition_created_by_run_id ON competition (created_by_run_id);
CREATE INDEX ix_competition_updated_by_run_id ON competition (updated_by_run_id);