erd-ver1

Tables (6)

admin_dong

  • DONG_ID — VARCHAR — Primary key — NOT NULL
  • STD_YYMM — VARCHAR — Primary key — NOT NULL
  • DONG_NM — VARCHAR — NOT NULL
  • PNT_LAT — NUMBER
  • PNT_LON — NUMBER
  • AREA_SIZE — NUMBER
  • RESIDENT_POP — NUMBER
  • WORKER_POP — NUMBER
  • FLOATING_POP — NUMBER
  • STORE_CNT — NUMBER
  • OPEN_RATE — NUMBER
  • CLOSE_RATE — NUMBER
  • POI_FACILITY_CNT — NUMBER
  • INCOME_AVG — NUMBER
  • SPEND_FOOD — NUMBER
  • SPEND_LEISURE — NUMBER
  • APT_HOUSEHOLD — NUMBER
  • APT_PRICE_AVG — NUMBER
  • SALES_AMT — NUMBER
  • SALES_CNT — NUMBER
  • AREA_CHANGE_IDX — VARCHAR

biz_area

  • AREA_ID — VARCHAR(32) — Primary key — NOT NULL
  • STD_YYMM — VARCHAR(6) — Primary key — NOT NULL
  • AREA_NM — VARCHAR(120) — NOT NULL
  • BIZ_AREA_TYPE — VARCHAR(20)
  • PNT_LAT — NUMBER
  • PNT_LON — NUMBER
  • AREA_SIZE — NUMBER
  • RESIDENT_POP — NUMBER
  • WORKER_POP — NUMBER
  • FLOATING_POP — NUMBER
  • STORE_CNT — NUMBER
  • OPEN_RATE — NUMBER
  • CLOSE_RATE — NUMBER
  • FRAN_STORE_CNT — NUMBER
  • POI_FACILITY_CNT — NUMBER
  • INCOME_AVG — NUMBER
  • SPEND_FOOD — NUMBER
  • SPEND_LEISURE — NUMBER
  • APT_HOUSEHOLD — NUMBER
  • APT_PRICE_AVG — NUMBER
  • SALES_AMT — NUMBER
  • SALES_CNT — NUMBER
  • AREA_CHANGE_IDX — VARCHAR(20)

customer_monthly_usage (customer_monthly_usage2)

  • ENCODED_MCT — VARCHAR — Primary key — NOT NULL
  • TA_YM — VARCHAR — Primary key — NOT NULL
  • ENCODED_MCT (ENCODED_MCT2) — VARCHAR(64) — Foreign key → franchise_info.ENCODED_MCT — NOT NULL
  • M12_MAL_1020_RAT — NUMBER — NOT NULL
  • M12_MAL_30_RAT — NUMBER — NOT NULL
  • M12_MAL_40_RAT — NUMBER — NOT NULL
  • M12_MAL_50_RAT — NUMBER — NOT NULL
  • M12_MAL_60_RAT — NUMBER — NOT NULL
  • M12_FME_1020_RAT — NUMBER — NOT NULL
  • M12_FME_30_RAT — NUMBER — NOT NULL
  • M12_FME_40_RAT — NUMBER — NOT NULL
  • M12_FME_50_RAT — NUMBER — NOT NULL
  • M12_FME_60_RAT — NUMBER — NOT NULL
  • MCT_UE_CLN_REU_RAT — NUMBER — NOT NULL
  • MCT_UE_CLN_NEW_RAT — NUMBER — NOT NULL
  • RC_M1_SHC_RSD_UE_CLN_RAT — NUMBER — NOT NULL
  • RC_M1_SHC_WP_UE_CLN_RAT — NUMBER — NOT NULL
  • RC_M1_SHC_FLP_UE_CLN_RAT — NUMBER — NOT NULL

franchise_data

  • 가맹점_구분번호 — VARCHAR — Primary key — NOT NULL
  • 기준년월 — VARCHAR — Primary key — NOT NULL
  • 가맹점_구분번호 (가맹점_구분번호2) — VARCHAR — Foreign key — NOT NULL
  • 가맹점_구분번호 (가맹점_구분번호3) — VARCHAR(64) — Foreign key → franchise_info.ENCODED_MCT — NOT NULL
  • 가맹점_운영개월_수_구간 — VARCHAR — NOT NULL
  • 매출금액_구간 — VARCHAR — NOT NULL
  • 매출건수_구간 — VARCHAR — NOT NULL
  • 유니크_고객_수_구간 — VARCHAR — NOT NULL
  • 객단가_구간 — VARCHAR — NOT NULL
  • 취소율_구간 — VARCHAR
  • 배달매출금액_비율 — NUMBER — NOT NULL
  • 동일_업종_매출금액_비율 — NUMBER — NOT NULL
  • 동일_업종_매출건수_비율 — NUMBER — NOT NULL
  • 동일_업종_내_매출_순위_비율 — NUMBER — NOT NULL
  • 동일_상권_내_매출_순위_비율 — NUMBER — NOT NULL
  • 동일_업종_내_해지_가맹점_비중 — NUMBER — NOT NULL
  • 동일_상권_내_해지_가맹점_비중 — NUMBER — NOT NULL
  • 가맹점_주소 — VARCHAR — NOT NULL
  • 가맹점명 — VARCHAR — NOT NULL
  • 브랜드구분코드 — VARCHAR
  • 가맹점_지역 — VARCHAR — NOT NULL
  • 업종 — VARCHAR — NOT NULL
  • 상권 — VARCHAR
  • 개설일 — DATE — NOT NULL
  • 폐업일 — DATE
  • 위도 — NUMBER — NOT NULL
  • 경도 — NUMBER — NOT NULL
  • 상권_지리 — VARCHAR — NOT NULL
  • 상권유형_지리 — VARCHAR — NOT NULL
  • 행정동 — VARCHAR — NOT NULL
  • 남성_20대이하_고객_비중 — NUMBER — NOT NULL
  • 남성_30대_고객_비중 — NUMBER — NOT NULL
  • 남성_40대_고객_비중 — NUMBER — NOT NULL
  • 남성_50대_고객_비중 — NUMBER — NOT NULL
  • 남성_60대이상_고객_비중 — NUMBER — NOT NULL
  • 여성_20대이하_고객_비중 — NUMBER — NOT NULL
  • 여성_30대_고객_비중 — NUMBER — NOT NULL
  • 여성_40대_고객_비중 — NUMBER
  • 여성_50대_고객_비중 — NUMBER
  • 여성_60대이상_고객_비중 — NUMBER
  • 재방문_고객_비중 — NUMBER
  • 신규_고객_비중 — NUMBER
  • 거주_이용_고객_비중 — NUMBER
  • 직장_이용_고객_비중 — NUMBER
  • 유동인구_이용_고객_비중 — NUMBER
  • 개인사업자여부 — BOOLEAN
  • 폐업여부 — BOOLEAN

franchise_info

  • ENCODED_MCT — VARCHAR(64) — Primary key — NOT NULL
  • MCT_BSE_AR — VARCHAR(255) — NOT NULL
  • MCT_NM — VARCHAR(120) — NOT NULL
  • MCT_BRD_NUM — VARCHAR(32)
  • MCT_SIGUNGU_NM — VARCHAR(50) — NOT NULL
  • HPSN_MCT_ZCD_NM — VARCHAR(80) — NOT NULL
  • HPSN_MCT_BZN_CD_NM — VARCHAR(80)
  • ARE_D — VARCHAR(8) — NOT NULL
  • MCT_ME_D — VARCHAR(8)

franchise_monthly_usage

  • ENCODED_MCT — VARCHAR — Primary key — NOT NULL
  • TA_YM — VARCHAR — Primary key — NOT NULL
  • ENCODED_MCT (ENCODED_MCT2) — VARCHAR — Foreign key — NOT NULL
  • ENCODED_MCT (ENCODED_MCT3) — VARCHAR(64) — Foreign key → franchise_info.ENCODED_MCT — NOT NULL
  • MCT_OPE_MS_CN — VARCHAR — NOT NULL
  • RC_M1_SAA — VARCHAR — NOT NULL
  • RC_M1_TO_UE_CT — VARCHAR — NOT NULL
  • RC_M1_UE_CUS_CN — VARCHAR — NOT NULL
  • RC_M1_AV_NP_AT — VARCHAR — NOT NULL
  • APV_CE_RAT — VARCHAR
  • DLV_SAA_RAT — NUMBER — NOT NULL
  • M1_SME_RY_SAA_RAT — NUMBER — NOT NULL
  • M1_SME_RY_CNT_RAT — NUMBER — NOT NULL
  • M12_SME_RY_SAA_PCE_RT — NUMBER — NOT NULL
  • M12_SME_BZN_SAA_PCE_RT — NUMBER — NOT NULL
  • M12_SME_RY_ME_MCT_RAT — NUMBER — NOT NULL
  • M12_SME_BZN_ME_MCT_RAT — NUMBER — NOT NULL