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)