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