powerfly

Tables (4)

User (유저)

  • ID (id) — Primary key — NOT NULL
  • userid (아이디)
  • password (패스워드)
  • authority (권한)

dronePort_Section (Untitled)

  • id (Key) — Primary key — NOT NULL
  • Id (Key2) — Foreign key → support.Id — NOT NULL
  • dronpotid (드론팟id) — Foreign key → dronePot.dronpotid — NOT NULL

dronePot (드론포트)

  • dronpotid (드론팟id) — Primary key — NOT NULL
  • Facility/Disaster (설비재난여부)
  • Coordinate Number (좌표번호)
  • Address (주소)
  • Vehicle Travel Time (차량이동시간)
  • Vehicle Distance (차량거리)
  • Transmission Section (송전선로)

support (지지물)

  • Id (Key) — Primary key — NOT NULL
  • name (선로명)
  • line (경간)
  • totalline (누계경간)
  • terrain (지세)
  • supportshape (지지물 형)
  • support heightdown (지지물 높이하단)
  • support heightup (지지물 높이 전장)
  • insulator rule (애자 규격)
  • insulator num1form (애자 #1TL형)
  • insulator num1quantity (애자 #1TL 수량)
  • insulator num2form (애자 #2TL형)
  • insulator num2quantity (애자 #2TL수량)
  • insulator inside (애자 내무)
  • Spacer_Main Line (스페이서_본선)
  • Spacer_Damper Branch (스페이서_잠파)
  • SB Damper_Overhead (Right) (sb댐퍼_가공(우))
  • SB Damper_OPGW (Left) (sb댐퍼_opgw(좌))
  • Indicator Light (표시등)
  • Marker_Overhead (Right) (표시구_가공(우))
  • Marker_OPGW (Left) (표시구_opgw(좌))
  • Aviation Marking (항공도장)
  • Installation Year (설치년도)
  • Latitude (위도)
  • Longitude (경도)
  • supportname (철탑번호)