pnl2
pnl
테이블 (10)
USER_INFO
- NO_BIZ (Key) — char(10) — 기본 키 — NOT NULL
- NM_DONG (Field77) — varchar(255) — 동이름
- NO_4326 (Field78) — varchar(255) — 4326좌표
- NO_NEMO_FLOAT (Field79) — varchar(255) — NOT NULL — 네모_유동코드
- NO_COMM (Field80) — varchar(255) — NOT NULL — 소상_상권코드
- NM_INDUSTRY (Field27) — varchar(200)
- DC_ADDR (Field30) — varchar(200)
- NM_BIZ_IMG (Field) — varchar(200)
- NM_COMP (Field2) — varchar(200)
- NM_BOSS (Field3) — varchar(100)
- NO_HP (Field4) — varchar(20)
- NO_TEL (Field5) — varchar(20)
- NM_EMAIL (Field6) — varchar(50)
- ID_HOMETAX (Field7) — varchar(20)
- PW_HOMETAX (Field8) — varchar(400)
- ID_CREFIA (Field9) — varchar(20)
- PW_CREFIA (Field10) — varchar(400)
- ID_BAEMIN (Field11) — varchar(20)
- PW_BAEMIN (Field12) — varchar(20)
- ID_YOGIYO (Field13) — varchar(20)
- PW_YOGIYO (Field14) — varchar(400)
- ID_BAETONG (Field15) — varchar(20)
- PW_BAETONG (Field16) — varchar(400)
- NM_SCRTY_IMG (Field17) — varchar(200)
- CD_SIGNROOT (Field18) — char(2)
- DT_INS (Field19) — varchar(8)
- TM_INS (Field20) — varchar(6)
- DT_DEL (Field21) — varchar(8)
- DT_OPEN (Field22) — varchar(8)
- DT_CLOSE (Field23) — varchar(8)
- CD_CLOSE_REASON (Field24) — varchar(2)
- TP_BIZ (Field25) — char(2)
- CD_INDUSTRY (Field26) — char(6)
- NM_INDUSTRY_SUB (Field28) — varchar(200)
- NO_POST (Field29) — varchar(6)
- DC_ADDR_DETAIL (Field31) — varchar(200)
- NO_CORPORATE (Field32) — char(13)
- NO_BOSS_JUMIN (Field33) — varchar(13)
- AM_SALES_BF (Field34) — int(12)
- NO_FAX (Field35) — varchar(20)
- CD_TAX_OFC (Field36) — varchar(3)
- NM_TAX_OFC (Field37) — varchar(10)
- PW_USER (Field38) — varchar(400)
- TP_USER (Field39) — char(2)
- YN_HAPPYCALL (Field40) — char(1)
- NO_FAX_B1 (Field41) — varchar(20)
- NO_FAX_B2 (Field42) — varchar(20)
- NO_FAX_B3 (Field43) — varchar(20)
- NO_FAX_B4 (Field44) — varchar(20)
- CD_AUTHKEY (Field45) — varchar(100)
- NO_BIZ_PROXY (Field46) — varchar(10)
- ID_REG_USER (Field47) — varchar(12)
- DT_REG (Field48) — timestamp
- ID_MOD_USER (Field49) — varchar(12)
- DT_MOD (Field50) — timestamp
- NM_AD_USER (Field51) — varchar(15)
- CD_FACE (Field52) — char(1)
- LGUPLUS_CP_NO (Field53) — varchar(12)
- LGUPLUS_CP_USE_YN (Field54) — varchar(1)
- LGUPLUS_CP_DT_REG (Field55) — varchar(8)
- … +21
vworld_건물 (VWORLD_BLD)
- ADDRESS (Key2) — varchar(255) — 기본 키 — NOT NULL
- NO_BIZ (Field2) — varchar(255) — 기본 키 — NOT NULL
- NM_BLD (Field) — varchar(255)
- NM_DONG (Field8) — varchar(255)
- USABILITY (Field9) — varchar(255)
- STRCT_DB (Field6) — varchar(255)
- GRND_FLR (Field10) — varchar(255)
- UGRND_FLR (Field11) — varchar(255)
- ARCHAREA (Field12) — varchar(255)
- HEIGHT (Field13) — varchar(255)
- VL_RAT (Field14) — varchar(255)
- BC_RAT (Field15) — varchar(255)
- TOTALAREA (Field16) — varchar(255)
- PLATAREA (Field17) — varchar(255)
- USEAPR_DAY (Field18) — varchar(255)
- INSERT_DATE (Field19) — varchar(255)
vworld_도로 (VWORLD_RD)
- DC_ADDR (Key2) — varchar(255) — 기본 키 — NOT NULL
- NO_POINT (Field) — varchar(255) — 기본 키 — NOT NULL
- NO_BIZ (Key) — varchar(255) — 기본 키 — NOT NULL
- WIDTH (Field2) — varchar(255)
- DT_REG (Field3) — timestamp
- DT_COR (Field4) — timestamp
내부DATA (PNL)
- NO_BIZ (Key) — varchar(100) — 기본 키 — NOT NULL
- CD_ACCOUNT (Key2) — varchar(100) — 기본 키 — NOT NULL
- DC_ADDR (Key3) — varchar(255) — 기본 키 — NOT NULL
- CD_TOP_ACCOUNT (Field) — varchar(100)
- NM_TOP_ACCOUNT (Field2) — varchar(100)
- NM_ACCOUNT (Field3) — varchar(100)
- THIS_PERIOD (Field4) — varchar(100)
- PRE_PERIOD (Field5) — varchar(100)
- THIS_HOME1IN (Field6) — varchar(100)
- THIS_HOME2IN (Field7) — varchar(100)
- THIS_HOME3IN (Field8) — varchar(100)
- THIS_HOME4IN (Field9) — varchar(100)
- THIS_OUT (Field10) — varchar(100)
- THIS_ETC (Field11) — varchar(100)
- PRE_HOME1IN (Field12) — varchar(100)
- PRE_HOME2IN (Field13) — varchar(100)
- PRE_HOME3IN (Field14) — varchar(100)
- PRE_HOME4IN (Field15) — varchar(100)
- PRE_OUT (Field16) — varchar(100)
- PRE_ETC (Field17) — varchar(100)
네모_금액 (NEMO_PAY)
- INSERT_DATE (Key) — varchar(50) — 기본 키 — NOT NULL
- NM_GU (Field) — varchar(50) — 기본 키 — NOT NULL
- CCDate (Field5) — varchar(50) — 기본 키 — NOT NULL
- SECTOR_1 (Field7) — varchar(50) — 기본 키 — NOT NULL
- SECTOR_2 (Field8) — varchar(50) — 기본 키 — NOT NULL
- editedDate (Field4) — varchar(50) — 기본 키 — NOT NULL
- PRICE_TYPE (Field2) — varchar(50) — 기본 키 — NOT NULL
- NM_PRO (Key2) — varchar(50) — 기본 키 — NOT NULL
- NO_NEMO_PAY (Key3) — varchar(255) — 기본 키 — NOT NULL
- AM_MON (Field6) — varchar(255)
- AM_DEPOSIT (Field9) — varchar(255)
- AM_ENTI (Field10) — varchar(255)
- SIZE (Field11) — varchar(255)
네모_유동 (NEMO_FLOAT)
- DT_REG (Key) — timestamp — 기본 키 — NOT NULL
- NM_NAME (key3) — varchar(255) — 기본 키 — NOT NULL
- NO_NEMO_FLOAT (Key2) — varchar(255) — 기본 키 — NOT NULL
- AM_POP (Field3) — varchar(255)
- AM_FPOP (Field4) — varchar(255)
- FPOP_RATIO (Field5) — varchar(255)
- CD_TYPE (Field6) — varchar(255)
- CN_LAT (Field7) — varchar(255)
- CN_LNG (Field8) — varchar(255)
- POLYGON (Field9) — varchar(255)
소상_경쟁 (SECTOR_INFO)
- CD_SERVICE (key2) — varchar(255) — 기본 키 — NOT NULL
- DT_QUARTER (key4) — char(1) — 기본 키 — NOT NULL
- DT_Y (Key) — char(10) — 기본 키 — NOT NULL
- CD_COMM (Key2) — varchar(255) — 기본 키 — NOT NULL
- CD_COMM_GUBUN (Field) — varchar(255)
- NM_COMM_GUBUN (Field2) — varchar(255)
- NM_COMM (Field3) — varchar(255)
- NM_SERVICE (Field4) — varchar(255)
- NB_STORE (Field5) — int
- NB_SIMILAR (Field6) — int
- RT_OPEN (Field7) — int
- NB_OP_STORE (Field8) — int
- RT_CLOSE (Field9) — int
- NB_CS_STORE (Field10) — int
- NB_FC (Field11) — int
소상_상권 (REGION_INFO)
- NO_COMM (Key) — varchar(255) — 기본 키 — NOT NULL
- DT_YMD (Key2) — varchar(20) — 기본 키 — NOT NULL
- NM_COMM (Field2) — varchar(255)
- CD_CITYDO (Field3) — varchar(255)
- NM_CITYDO (Field4) — varchar(255)
- CD_CITYGU (Field5) — varchar(255)
- NM_CITYGU (Field6) — varchar(255)
- NB_XY (Field7) — int
- XY (Field) — varchar(255)
소상_영역 (SECTOR_XY)
- DT_YM (Key) — char(10) — 기본 키 — NOT NULL
- CD_COMM (Key2) — varchar(255) — 기본 키 — NOT NULL
- CD_COMM_GUBUN (Field) — char(1)
- NM_COMM_GUBUN (Field2) — varchar(255)
- NM_CD_COMM (Field3) — varchar(255)
- X (Field4) — varchar(255) — 5181좌표
- Y (Field5) — varchar(255) — 5181좌표
- CD_CITYGU (Field6) — varchar(255)
- CD_DONG (Field7) — varchar(255)
- X_4326 (Field8)
- Y_4326 (Field9)
- POLY (Field11) — text
행정동/법정동 (HANG_BUB)
- NO_HANG (Field8) — varchar(255) — 기본 키
- NO_BUB (Field10) — varchar(255) — 기본 키
- NM_SI (Field) — varchar(255)
- NM_GU (Field2) — varchar(255)
- NM_MYUNG (Field3) — varchar(255)
- NM_HANG (Field4) — varchar(255)
- NM_BUB (Field5) — varchar(255)
- NO_HANG_8 (Field6) — varchar(255)
- NO_HANG_7 (Field7) — varchar(255)
- DT_HANG (Field9) — varchar(255)
- BUB_BUNHAL (Field11) — varchar(255)
- HANG_ENG (Field12) — varchar(255)