인덕텔레콤

테이블 (7)

user_information (Untitled)

  • user_number — Number(10) — 기본 키 — NOT NULL
  • user_id — Character(20)
  • user_password — Character(20)

감시데이터 (Untitled5)

  • Communication_device_number (Communication_device_number2) — Number(10) — 외래 키 → 네트워크 데이터.Communication_device_number — NOT NULL
  • Communication_device_state — Character(15)

네트워크 데이터 (Untitled2)

  • Communication_device_number — Number(10) — 기본 키 — NOT NULL
  • Communication_device_state — Character(15)
  • Process_number — Number(10)
  • Process_state — Character(15)
  • Service_number — Number(10)
  • Service_state — Character(15)
  • user_number — Number(10) — 외래 키 → user_information.user_number — NOT NULL

네트워크 자산 정보 (Untitled6)

  • Communication_device_number — Number(10) — 외래 키 → 네트워크 자산관리.Communication_device_number — NOT NULL
  • Device_type — Character(20)
  • Device_name — Character(20)
  • Install_location — Character(20)
  • Install_time — Character(20)
  • Install_manager — Character(20)
  • Install_manager _contact — Character(20)
  • Device_operator — Character(20)
  • Operator_contact — Character(20)
  • Service_process — Character(20)
  • service_process_name — Character(20)
  • Service_developer — Character(20)
  • Develop_day — Character(20)
  • Install_day — Character(20)
  • Service_developer _contact — Character(20)

네트워크 자산관리 (CopyOfUntitled5)

  • Communication_device_number — Number(10) — 기본 키 — NOT NULL
  • Communication_device_state — Character(15)
  • Communication_device_number (Communication_device_number2) — Number(10) — 외래 키 → 네트워크 데이터.Communication_device_number — NOT NULL

데이터 분석 (Untitled3)

  • Communication_device_number (Communication_device_number2) — Number(10) — 외래 키 → 네트워크 데이터.Communication_device_number — NOT NULL
  • Communication_device_state — Character(15)

장비별 데이터 분석 (Untitled4)

  • Communication_device_number (Communication_device_number2) — Number(10) — 외래 키 → 데이터 분석.Communication_device_number — NOT NULL
  • Device_traffic — Number(5)
  • Device_time — Character(30)
  • Division_type — Character(15)