_memory
| type | name | tbl_name | rootpage | sql |
|---|---|---|---|---|
| table | medimach_codes | medimach_codes | 2 | CREATE TABLE medimach_codes ( id INTEGER NOT NULL, study_code VARCHAR(100), PRIMARY KEY (id), UNIQUE (id) ) |
| table | nielsen_medias | nielsen_medias | 5 | 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) ) |
| table | nielsen_media_details | nielsen_media_details | 49 | CREATE TABLE "nielsen_media_details" ( "id" INTEGER, "media_detail_code" INTEGER, "code" INTEGER, "name" TEXT, "time" INTEGER, "gattung" TEXT, "id_tb" INTEGER, "kbz" TEXT, "start_block_time" INTEGER, "end_block_time" INTEGER, "gewicht" INTEGER, "no_tables_gesamt" INTEGER, "zeit" TEXT, "factor_vorgabe" REAL, "costpergrp" INTEGER ) |