Auto_DB

Tables (12)

Dim_Brand (Untitled3)

  • Model (PK) — Primary key — NOT NULL
  • Brand (제조사)
  • Country (제조사국적)
  • 연비 (Field)
  • 세그1 (경쟁구도)
  • 세그2 (세단/SUV)
  • 세그3 (크기기준)
  • 배기량 (Field2)
  • 연료체계 (대표차량)
  • 가격 (Field3)

Dim_Channel (Untitled7)

  • Channel (PK) — Primary key — NOT NULL
  • 채널그룹 (Field)
  • 채널장르 (Field2)

Dim_Date (Untitled6)

  • Date (PK) — Primary key — NOT NULL
  • YM (FK) — Foreign key → Dim_YM.YM — NOT NULL
  • Year (Field)
  • Month (Field2)
  • Week (Field3)
  • Day (Field4)
  • Quarter (Field5)
  • Dayofweek (Field6)
  • 휴일/주말 (Field7)

Dim_Daypart (Untitled9)

  • 시간 (PK) — Primary key — NOT NULL
  • Daypart (Field)
  • 시간대그룹 (Field2)

Dim_Program (Untitled8)

  • PR (PK) — Primary key — NOT NULL
  • 프로그램장르 (Field)

Dim_TA (Untitled4)

  • Target_Audience (PK) — Primary key — NOT NULL
  • 성별 (Field2)
  • 연령별 (Field)
  • 연령대그룹 (Field3)

Dim_YM (Untitled2)

  • YM (PK) — Primary key — NOT NULL
  • Year (연)
  • Month (월)
  • Quater (분기)

Fact_Kaida (Untitled)

  • Target_Audience (FK1) — Foreign key → Dim_TA.Target_Audience — NOT NULL
  • YM (FK2) — Foreign key → Dim_YM.YM — NOT NULL
  • Model_key (FK3) — Foreign key → Dim_Brand.Model — NOT NULL
  • 신규등록대수 (Field5)

Fact_Naver (Untitled5)

  • Target_Audience (FK1) — Foreign key → Dim_TA.Target_Audience — NOT NULL
  • Model (FK3) — Foreign key → Dim_Brand.Model — NOT NULL
  • Date (FK2) — Foreign key → Dim_Date.Date — NOT NULL
  • 시간 (FK6) — Foreign key → Dim_Daypart.시간 — NOT NULL
  • Naver_Query (Field)

Fact_TV_Daily (Un)

  • Date (FK2) — Foreign key → Dim_Date.Date — NOT NULL
  • Target_Audience (FK1) — Foreign key → Dim_TA.Target_Audience — NOT NULL
  • Product (FK3) — Foreign key → Dim_Brand.Model — NOT NULL
  • Channel (FK4) — Foreign key → Dim_Channel.Channel — NOT NULL
  • PR (FK5) — Foreign key → Dim_Program.PR — NOT NULL
  • 시간 (FK6) — Foreign key → Dim_Daypart.시간 — NOT NULL
  • CM_Position — text
  • Population — bigint(20)
  • Samples — bigint(20)
  • SPOT (Spot) — bigint(20)
  • Audience (Adience) — bigint(20)
  • GRP — double

Fact_TV_ch_Monthly(Reach) (Un3)

  • YM (FK2) — Foreign key → Dim_YM.YM — NOT NULL
  • Target_Audience (FK1) — Foreign key → Dim_TA.Target_Audience — NOT NULL
  • Product (FK3) — Foreign key → Dim_Brand.Model — NOT NULL
  • Channel (FK4) — Foreign key → Dim_Channel.Channel — NOT NULL
  • Year — int(11)
  • Month — text
  • Reach1 (Reach1+) — double
  • Reach3 (Reach3+) — double
  • Reach5 (Reach5+) — double
  • Reach7 (Reach7+) — double
  • Reach9 (Reach9+) — double
  • Reach12 (Reach12+) — double
  • Reach15 (Reach15+) — double

Fact_TV_monthly(Reach) (Un1)

  • YM (FK2) — Foreign key → Dim_YM.YM — NOT NULL
  • Target_Audience (FK1) — Foreign key → Dim_TA.Target_Audience — NOT NULL
  • Product (FK3) — Foreign key → Dim_Brand.Model — NOT NULL
  • Year — int(11)
  • Month — text
  • Reach1 (Reach1+) — double
  • Reach3 (Reach3+) — double
  • Reach5 (Reach5+) — double
  • Reach7 (Reach7+) — double
  • Reach9 (Reach9+) — double
  • Reach12 (Reach12+) — double
  • Reach15 (Reach15+) — double