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