ChangeDevice

Tables (5)

REAL_DATA (Untitled)

  • 날짜 (ARRIVE_DTM) — datetime
  • Serial NO (DEVICE_SCODE) — varchar(20)
  • AS의뢰내역 (REASON) — int
  • 처리 (FIX) — mediumtext
  • 기타 (DESCRIPTION) — TEXT
  • 고객발송일자 (DEPATURE_DTM) — datetime

SME_CHANGE_DEVICE

  • CHANGE_SEQ — int — Primary key — NOT NULL
  • OLD_DEVICE — varchar(32)
  • DEVICE_ORGANIZATION — int
  • DEVICE_LOCALE — char(10)
  • DEVICE_AREA — bigint
  • DEVICE_SCODE — varchar(20)
  • DEVICE_KIND — char(1)
  • REASON — int
  • DESCRIPTION — TEXT
  • NEW_DEVICE — varchar(32)
  • ARRIVE_DTM — datetime
  • DEPATURE_DTM — datetime
  • FIX — mediumtext
  • DEVICE_REPLACEMENT — int
  • OLD_DEVICE_LTE_CNUM — varchar(20)
  • NEW_DEVICE_LTE_CNUM — varchar(20)
  • OLD_DEVICE_IMEI — char(15)
  • NEW_DEVICE_IMEI — char(15)
  • INVOICE — varchar(20)

SME_DEVICE

  • DEVICE_SERIAL — varchar(200) — Primary key — NOT NULL
  • DEVICE_ORGANIZATION — int — Foreign key → SME_ORGANIZATION.ORG_SEQ
  • DEVICE_SEQ — int
  • DEVICE_MODEL — varchar(100) — NOT NULL
  • DEVICE_FIRMWARE — varchar(20) — NOT NULL
  • DEVICE_TYPE — char — NOT NULL
  • DEVICE_ORDER — int(3)
  • DEVICE_COUNTRY — char(3) — NOT NULL
  • DEVICE_WAN — varchar(20) — NOT NULL
  • DEVICE_LOCAL — varchar(20) — NOT NULL
  • DEVICE_CHECK_CODE — varchar(20) — NOT NULL
  • DEVICE_CHECK_SUM — varchar(20) — NOT NULL
  • DEVICE_LINKER — varchar(20) — NOT NULL
  • DEVICE_ACTIVE — char — NOT NULL
  • DEVICE_TURN_DTM — datetime
  • DEVICE_REG_DTM — datetime — NOT NULL
  • DEVICE_CHNG_DTM — datetime — NOT NULL
  • DEVICE_SCODE — varchar(100)
  • DEVICE_SGROUP — varchar(100)
  • DEVICE_SSMS — varchar(100)
  • DEVICE_SMAIL1 — varchar(200)
  • DEVICE_SMAIL2 — varchar(200)
  • DEVICE_SMAIL3 — varchar(200)
  • DEVICE_LTE_CNUM — varchar(20)
  • DEVICE_CRC32 — varchar(8)
  • DEVICE_MANAGE_SEQ_NO — int
  • DEVICE_LOCALE — char(10)
  • DEVICE_AREA — bigint
  • DEVICE_IMEI — char(15)

SME_ORGANIZATION

  • ORG_SEQ — int — Primary key
  • ORG_TYPE — char(3) — NOT NULL
  • ORG_DEPTH — int
  • ORG_LAN — char(3) — NOT NULL
  • ORG_VIEW — varchar(20) — NOT NULL
  • ORG_NM — varchar(100) — NOT NULL
  • ORG_CD — varchar(100) — NOT NULL
  • STA_RN_MGT_CD — char(10)
  • USE_YN — char
  • ORG_REG_DTM — datetime

SME_STATUTE_CODE

  • STA_SD_NM — varchar(100) — 시도
  • STA_SGG_NM — varchar(100) — 시군구
  • STA_ADM_NM — varchar(100) — 행정구역명
  • STA_ADM_STAT_NM — varchar(100) — 행정동(행정기관명)
  • STA_RN_MGT_NM — varchar(100) — 법정동
  • STA_ADM_CD — char(7) — 행정구역코드
  • STA_ADM_STAT_CD — char(10) — 행정기관코드
  • STA_ADM_STAT_DTM — char(8) — 행정기관 생성일
  • STA_RN_MGT_CD — char(10) — 법정동코드
  • STA_JURISDICTION — char(10) — 관할지역
  • STA_ADM_STAT_ENG — varchar(100) — 행정동 영문명칭
  • STA_REMARKS — varchar(200) — 비고