nielsen_medias
1 row where medimach_code = 8
This data as json, CSV (advanced)
| id ▼ | code | title | medimach_code |
|---|---|---|---|
| 8 | 974192 | 321KOCHEN.TV | AGOF_321koch 8 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE nielsen_medias ( id INTEGER NOT NULL, code VARCHAR(100), title VARCHAR(250), medimach_code INTEGER, PRIMARY KEY (id), UNIQUE (id), FOREIGN KEY(medimach_code) REFERENCES medimach_codes (id) ); CREATE UNIQUE INDEX ix_nielsen_medias_code ON nielsen_medias (code); CREATE INDEX ix_nielsen_medias_medimach_code ON nielsen_medias (medimach_code);