nielsen_medias

5 rows where gattung = 15

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
2804   980472 FACEBOOK MOBILE SOCIAL 15 1          
2805   980474 X (TWITTER) MOBILE SOCIAL 15 1          
2806   980800 FACEBOOK DESKTOP SOCIAL 15 1          
2807   980892 INSTAGRAM MOBILE SOCIAL 15 1          
2808   980801 X (TWITTER) DESKTOP SOCIAL 15 1          

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE nielsen_medias (
	id INTEGER NOT NULL, 
	"mediaDetailCodeId" INTEGER, 
	code INTEGER, 
	title VARCHAR, 
	gattung INTEGER, 
	"idTb" INTEGER, 
	"studyCode" VARCHAR, 
	"noTablesGesamt" INTEGER, 
	time VARCHAR, 
	"factorDefault" FLOAT, 
	"costPerGroup" INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(gattung) REFERENCES media_gattung (id)
);
CREATE INDEX "ix_nielsen_medias_studyCode" ON nielsen_medias ("studyCode");
CREATE INDEX ix_nielsen_medias_time ON nielsen_medias (time);
CREATE INDEX ix_nielsen_medias_title ON nielsen_medias (title);