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 (철탑번호)