스마트상황실 erd
테이블 (4)
Call_Data (tb_ndm_data_measure)
- Phone NO (phone_no) — Bigint(20) — 기본 키 — NOT NULL
- Meastime (meastime) — Bigint(20) — 기본 키 — NOT NULL
- PhoneNumber (phoneNumber) — Bigint(20) — 기본 키 — NOT NULL
- Measure Type (MeasuringType) — varchar(100)
- Measure Mode (MeasuringMode) — varchar(100)
- network Mode (NetworkId) — varchar(100)
- CurrentCount (currentCount) — int(11)
- City (siDo) — varchar(100)
- City2 (guGun) — varchar(100)
- City3 (addressDetail) — varchar(100)
- Down Transfer (downloadTransfer) — int(11)
- Down Speed (downloadBandwidth) — double
- Down Error (downloadErrorCode) — varchar(100)
- Up Transfer (uploadTransfer) — int(11)
- Up Speed (uploadBandwidth) — double
- Up Error (uploadErrorCode) — varchar(100)
- SINR (sinr) — double
- RSRP (rsrp) — double
- WiFi (isWifi) — varchar(100)
- Latitude (latitude) — varchar(100)
- Longitude (longitude) — varchar(100)
- Pci (p_pci) — int(11)
- Earfcn (p_dl_earfcn) — int(11)
Call_Data_광역본부1 (tb_ndm_data_measure_area1)
- Phone NO (phone_no) — Bigint(20) — 기본 키 — NOT NULL
- Meastime (meastime) — Bigint(20) — 기본 키 — NOT NULL
- PhoneNumber (phoneNumber) — Bigint(20) — 기본 키 — NOT NULL
- Measure Type (MeasuringType) — varchar(100)
- Measure Mode (MeasuringMode) — varchar(100)
- network Mode (NetworkId) — varchar(100)
- CurrentCount (currentCount) — int(11)
- City (siDo) — varchar(100)
- City2 (guGun) — varchar(100)
- City3 (addressDetail) — varchar(100)
- Down Transfer (downloadTransfer) — int(11)
- Down Speed (downloadBandwidth) — double
- Down Error (downloadErrorCode) — varchar(100)
- Up Transfer (uploadTransfer) — int(11)
- Up Speed (uploadBandwidth) — double
- Up Error (uploadErrorCode) — varchar(100)
- SINR (sinr) — double
- RSRP (rsrp) — double
- WiFi (isWifi) — varchar(100)
- Latitude (latitude) — varchar(100)
- Longitude (longitude) — varchar(100)
- Pci (p_pci) — int(11)
- Earfcn (p_dl_earfcn) — int(11)
- Area (areaName) — varchar(100)
- Team (TeamName) — varachar(100)
관리자 리스트 (admin_list)
- Team (teamName) — varachar(100)
- Area (sido) — varchar(100)
- Administrator (adminName) — varchar(100)
주소 매핑 데이터 (address_data)
- City2 (guGun) — varchar(100) — 기본 키 — NOT NULL
- City (sido) — varchar(100)
- Team (teamName) — varchar(100)
- Area (areaName) — varchar(100)
- Channel (channelName) — varchar(100)