team_alias

5 rows where team_id = 343

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_name, source_id, confidence, created_at, updated_at, created_at (date), updated_at (date)

CREATE TABLE team_alias (
	alias_id INTEGER NOT NULL, 
	team_id INTEGER NOT NULL, 
	raw_name VARCHAR(128) NOT NULL, 
	source_id INTEGER NOT NULL, 
	confidence FLOAT NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	created_by_run_id INTEGER, 
	updated_by_run_id INTEGER, 
	source_raw_key VARCHAR(512), 
	PRIMARY KEY (alias_id), 
	CONSTRAINT uq_team_alias_raw_source UNIQUE (raw_name, source_id), 
	FOREIGN KEY(team_id) REFERENCES team (team_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
);
CREATE INDEX ix_team_alias_created_by_run_id ON team_alias (created_by_run_id);
CREATE INDEX ix_team_alias_team_id ON team_alias (team_id);
CREATE INDEX ix_team_alias_source_id ON team_alias (source_id);
CREATE INDEX ix_team_alias_source_raw_key ON team_alias (source_raw_key);
CREATE INDEX ix_team_alias_updated_by_run_id ON team_alias (updated_by_run_id);
CREATE INDEX ix_team_alias_raw_name ON team_alias (raw_name);