Sideproject

Tables (8)

Copy Of Copy Of Untitled (TV_weekly_ch)

  • Key (Product) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (Advertiser) — text
  • Field (Year) — int(11)
  • Field (Month) — text
  • Field (Target_Audience) — text
  • Field (Reach1+) — double
  • Field (Reach3+) — double
  • Field (Reach5+) — double
  • Field (Reach7+) — double
  • Field (Reach9+) — double
  • Field (Reach12+) — double
  • Field (Channel) — text
  • Field (Week) — text

Copy Of Untitled (TV_monthly_ch)

  • Key (Product) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (Advertiser) — text
  • Field (Year) — int(11)
  • Field (Month) — text
  • Field (Target_Audience) — text
  • Field (Reach1+) — double
  • Field (Reach3+) — double
  • Field (Reach5+) — double
  • Field (Reach7+) — double
  • Field (Reach9+) — double
  • Field (Reach12+) — double
  • Field (Channel) — text

Copy Of Untitled2 (TV_weekly)

  • Key (Product) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (Advertiser) — text
  • Field (Year) — int(11)
  • Field (Month) — text
  • Field (Target_Audience) — text
  • Field (Reach1+) — double
  • Field (Reach3+) — double
  • Field (Reach5+) — double
  • Field (Reach7+) — double
  • Field (Reach9+) — double
  • Field (Reach12+) — double
  • Field (Reach15+) — double
  • Field (Week) — text

Fact_Kaida (kaida)

  • Key (model) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (brand) — text
  • Field (value) — text
  • Field (sales_type) — text
  • Field (age) — text
  • Field (month) — text
  • Field (year) — bigint(20)

Untitled (demension_upload)

  • Key (model_pk) — text — Primary key — NOT NULL
  • Field (MyUnknownColumn) — text
  • Field (Model) — text
  • Field (Brand) — text
  • Field (car_country) — text
  • Field (car_fuel) — text
  • Field (car_seg) — text
  • Field (car_seg_size) — text
  • Field (car_seg_com) — text

Untitled (naver_query)

  • Key (Model) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (index) — bigint(20)
  • Field (Date) — text
  • Field (Count_query) — double
  • Field (Brand) — text
  • Field (YM) — bigint(20)
  • Field (Year) — bigint(20)
  • Field (Month) — bigint(20)
  • Field (Day) — bigint(20)
  • Field (Target_Audience) — text

Untitled (TV_daily)

  • Key (Product) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (Year) — bigint(20)
  • Field (Month) — text
  • Field (Day) — bigint(20)
  • Field (Date) — text
  • Field (Advertiser) — text
  • Field (Channel) — text
  • Field (Genre) — text
  • Field (Program) — text
  • Field (Daypart) — text
  • Field (CM_Position) — text
  • Field (Target_Audience) — text
  • Field (Population) — bigint(20)
  • Field (Samples) — bigint(20)
  • Field (Spot) — bigint(20)
  • Field (Adience) — bigint(20)
  • Field (GRP) — double

Untitled (TV_monthly)

  • Key (Product) — text — Foreign key → Untitled.Key — NOT NULL
  • Field (Advertiser) — text
  • Field (Year) — int(11)
  • Field (Month) — text
  • Field (Target_Audience) — text
  • Field (Reach1+) — double
  • Field (Reach3+) — double
  • Field (Reach5+) — double
  • Field (Reach7+) — double
  • Field (Reach9+) — double
  • Field (Reach12+) — double
  • Field (Reach15+) — double