NGO
테이블 (11)
dimension_date (Untitled3)
- Date키 (Key) — 기본 키 — NOT NULL
- 연 (Field)
- 월 (Field2)
- 일 (Field3)
- 요일 (Field4)
- 주중/주말 (Field5)
- 주차 (Field6)
- 연월 (Field7)
dimension_daypart (Untitled4)
- Daypart (Key) — 기본 키 — NOT NULL
- 시간대 (Field)
dimension_film (Untitled5)
- Film (Key) — 기본 키 — NOT NULL
- 대표소재명 (Field)
- 구분 (Field2)
- 장르 (Field3)
- Asklevel (Field4)
- 소재등록일 (Field5)
dimension_station (Untitled)
- Station (Key) — 기본 키 — NOT NULL
- 대표채널 (Field)
- 매체구분 (Field2)
- 장르 (Field3)
dimension_연월 (Untitled2)
- 연월 (Key) — 기본 키 — NOT NULL
- 연도 (Field)
- 분기 (Field2)
- 월 (Field3)
fact_송출내역 (Untitled8)
- station (Key) — 기본 키 — NOT NULL
- Date (Field)
- Time (Field2)
- Secs (Field3)
- Film (Field4)
- Programme (Field5)
- Genre (Field6)
- Net Price (Field7)
- Cost (Field8)
- Audience (Field9)
- Salehouse (Field10)
- promocode (Field11)
- pib (Field12)
- pip (Field13)
- origin (Field14)
- telno (Field15)
- SPOT (Field16)
- Daypart (Field17)
- 연월 (Field18)
fact_집행실적_ml분석 (Untitled9)
- Date (Key) — 기본 키 — NOT NULL
- Copyline (Field9) — 기본 키
- Stataion (Field)
- Reach (Field5)
- Reach 3+ (Field6)
- Reach 5+ (Field7)
- SPOT (Field8)
- Audience (Field2)
- 30M_Audience (Field3)
- 40M_Audience (Field4)
- 50M_Audience (Field10)
- 60M_Audience (Field11)
- 30F_Audience (Field12)
- 40F_Audience (Field13)
- 50F_Audience (Field14)
- 60F_Audience (Field15)
- 30M_Reach (Field16)
- 40M_Reach (Field17)
- 50M_Reach (Field18)
- 60M_Reach (Field19)
- 30F_Reach (Field20)
- 40F_Reach (Field21)
- 50F_Reach (Field22)
- 60F_Reach (Field23)
- 30M_Reach3+ (Field24)
- 40M_Reach3+ (Field25)
- 50M_Reach3+ (Field26)
- 60M_Reach3+ (Field27)
- 30F_Reach3+ (Field28)
- 40F_Reach3+ (Field29)
- 50F_Reach3+ (Field30)
- 60F_Reach3+ (Field31)
- 30M_Reach5+ (Field32)
- 40M_Reach5+ (Field33)
- 50M_Reach5+ (Field34)
- 60M_Reach5+ (Field35)
- 30F_Reach5+ (Field36)
- 40F_Reach5+ (Field37)
- 50F_Reach5+ (Field38)
- 60F_Reach5+ (Field39)
- Net Cost (Field40)
- Cost (Field41)
- CPM (Field42)
fact_채널별CPM (Untitled11)
- station (Key) — 기본 키 — NOT NULL
- ch_group (Field)
- CPM (Field2)
fact_최그1개월샘플_ROI시뮬레이션 (Untitled10)
- Date (Key) — 기본 키 — NOT NULL
- Advertiser (Field)
- Product (Field2)
- Feature_1 (Field3)
- Feature_2 (Field4)
- Feature_3 (Field5)
- Feature_4 (Field6)
- Feautre_5 (Field7)
- Ch1_Audience (Field8)
- ChN_Audience (Field9)
- Cost (Field10)
- Predict_call (Field11)
- Predict_donour (Field12)
- Predict_donouramount (Field13)
- ROI (Field14)
fact_큐시트 (Untitled7)
- Station (Key) — 기본 키 — NOT NULL
- Programme (Field)
- Time (Field2)
- Daypart (Field3)
- Class (Field4)
- Sec (Field5)
- Kind (Field6)
- Unit price (Field7)
- Bonus Rate (Field8)
- Net price (Field9)
- Insertion (Field10)
- Ad value (Field11)
- Cost (Field12)
- Date (Field13)
- Film (Field14)
- 연월 (Field15)
- Field16
fact_후원내역 (Untitled6)
- Date (Key) — 기본 키 — NOT NULL
- Time
- 시간대 (Field)
- Dnis (Field2)
- Station (Field3)
- I/B콜수 (Field4)
- 응대호 (Field5)
- 정기후원 (Field6)
- 후원금액 (Field7)
- Film (Field8)