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) — 비고