team

1,299 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_code, team_type, created_by_run_id, source_id, created_at (date), updated_at (date)

Next page

CREATE TABLE team (
	team_id INTEGER NOT NULL, 
	name VARCHAR(128) NOT NULL, 
	short_name VARCHAR(64), 
	country_code VARCHAR(3), 
	continent VARCHAR(64), 
	team_type VARCHAR(16) NOT NULL, 
	founded_year 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 (team_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 INDEX ix_team_updated_by_run_id ON team (updated_by_run_id);
CREATE INDEX ix_team_source_id ON team (source_id);
CREATE UNIQUE INDEX ix_team_name ON team (name);
CREATE INDEX ix_team_source_raw_key ON team (source_raw_key);
CREATE INDEX ix_team_created_by_run_id ON team (created_by_run_id);