스마트상황실 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)