UAS_TEST
Tables (14)
BcaMissionInfo (Bca_Mission)
- BCA_Mission_key (bca_mission_key) — INT(11) — Primary key — NOT NULL
- bcaAction (bcaaction) — INT(11)
- bcaActionStatus (bcaactionstatus) — BYTE(1)
BcaMissionPlanInfo (BCA_Plan)
- BCA_Plan_Key (bca_plan_key) — INT(11) — Primary key — NOT NULL
- missionAlgoNum (missionalgonum) — BYTE(1)
- missionIndex (missionindex) — BYTE(1)
- missionGoal (missiongoal) — BYTE(1)
- bcaLPLat (bcalplat) — DOUBLE(10)
- bcaLPLon (bcalplon) — DOUBLE(10)
- pcaLPLat (pcalplat) — DOUBLE(10)
- pcaLPLon (pcalplon) — DOUBLE(10)
- numWPs — INT(11)
- surveyWPs (numwps) — DOUBLE
BcaNaviInfo (Bca_navi)
- Bca_Navi_Key (bca_avi_key) — INT(11) — Primary key — NOT NULL
- bcaRoll (bcaroll) — DOUBLE(11)
- bcaPitch (bcapitch) — DOUBLE(11)
- bcaHeading (bcaheading) — DOUBLE(11)
- bcaLat (bcalat) — DOUBLE(11)
- bcalon — DOUBLE(11)
- bcaGoalLat (bcagoallat) — DOUBLE(11)
- bcaGoalLon (bcagoallon) — DOUBLE(11)
- bcaGoalDist (bcagoaldist) — DOUBLE(11)
- bcaGoalBearing (bcagoalbearing) — DOUBLE(11)
- bcaMeanVel (bcameanvel) — DOUBLE(11)
- bcaMeanDist (bcameandist) — DOUBLE(11)
BcaStatusInfo (Bca_Status)
- BCA_Status_key (bca_status_key) — INT(11) — Primary key — NOT NULL
- bcaState (bcastate) — BYTE(1)
- bcaDiagRst (bcadiagrst) — BYTE(1)
- bcaBattery (bcabattery) — BYTE(1)
- bcaVoltage (bcavoltage) — BYTE(1)
- bcaCurrent (bcacurrent) — BYTE(1)
- TBD1 (tbd1) — BYTE(1)
- TBD2 (tbd2) — BYTE(1)
MissionPlanInfo (Mission_Plan)
- Mission_Plan_Key (mission_plan_key) — INT(11) — Primary key — NOT NULL
- DBKey (Field) — Primary key
- moduleInfo (moduleinfo) — BYTE(1)
- missionAlgoNum (missionalgonum) — BYTE(1)
- missionIndex (missionindex) — BYTE(1)
- missionGoal (missiongoal) — BYTE(1)
- bcaLPLat (bcalplat) — DOUBLE(10)
- bcaLPLon (bcalplon) — DOUBLE(10)
- pcaLPLat (pcalplat) — DOUBLE(10)
- pcaLPLon (pcalplon) — DOUBLE(10)
- numWPs — INT(11)
- surveyWPs (numwps) — DOUBLE
- sendTime (sendtime) — DATETIME
PcaMissionPlanInfo (PCA_Plan)
- PCA_Plan_Key (pca_plan_key) — INT(11) — Primary key — NOT NULL
- missionAlgoNum (missionalgonum) — BYTE(1)
- missionIndex (missionindex) — BYTE(1)
- missionGoal (missiongoal) — BYTE(1)
- bcaLPLat (bcalplat) — DOUBLE(10)
- bcaLPLon (bcalplon) — DOUBLE(10)
- pcaLPLat (pcalplat) — DOUBLE(10)
- pcaLPLon (pcalplon) — DOUBLE(10)
- numWPs — INT(11)
- surveyWPs (numwps) — DOUBLE
PcaNaviInfo (Pca_navi)
- PCA_Navi_key (pca_navi_key) — INT(11) — Primary key — NOT NULL
- pcaIndex (pcaindex) — BYTE(1)
- emgcUp (emgcup) — BYTE(1)
- pcaRoll (pcaroll) — FLOAT(11)
- pcaPicth (pcapitch) — FLOAT(11)
- pcaHeading (pcaheading) — FLOAT(11)
- pcaLat (pcalat) — FLOAT(11)
- pcaLon (pcalon) — FLOAT(11)
- pcaDepth (pcadepth) — FLOAT(11)
- pcaXvel (pcaxvel) — FLOAT(11)
- pcaYvel (pcayvel) — FLOAT(11)
- pcaZvel (pcazvel) — FLOAT(11)
- pcap — FLOAT(11)
- pcaq — FLOAT(11)
- pcar — FLOAT(11)
PcaStatusInfo (Pca_Status)
- PCA_Status_Key (pca_status_key) — INT(11) — Primary key — NOT NULL
- pca1State (pca1state) — BYTE(1)
- pca1DiagRst (pca1diagrst) — BYTE(1)
- pca1MovHr (pca1movhr) — SMALLINT(11)
- pca1MovMin (pca1movmin) — SMALLINT(11)
- pca1MovSec (pca1movsec) — SMALLINT(11)
- pca1Battery (pca1battery) — SMALLINT(11)
- pca1Voltage (pca1voltage) — FLOAT(11)
- pca1Current (pca1current) — FLOAT(11)
- pca1Temp (pca1temp) — FLOAT(11)
- pca1Rpm (pca1rpm) — FLOAT(11)
- pca2State (pca2state) — BYTE(1)
- pca2DiagRst (pca2diagrst) — BYTE(1)
- pca2MovHr (pca2movhr) — SMALLINT(11)
- pca2MovMin (pca2movmin) — SMALLINT(11)
- pca2MovSec (pca2movsec) — SMALLINT(11)
- pca2Battery (pca2battery) — SMALLINT(11)
- pca2Voltage (pca2voltage) — FLOAT(11)
- pca2Current (pca2current) — FLOAT(11)
- pca2Temp (pca2temp) — FLOAT(11)
- pca2Rpm (pca2rpm) — FLOAT(11)
SeaAreaDataInfo (Sea_Info)
- Sea_AreaData_key (sea_areadata_key) — INT(11) — Primary key — NOT NULL
- pcaIndex (pcaindex)
- TBD1 (tbd1) — SMALLINT(11)
- TBD2 (tbd2)
- recvtime (Field)
UsvDetailMissionPlanInfo (Usv_DetailPlan)
- USV_DetailPlan_Key (usv_detailplan_key) — INT(11) — Primary key — NOT NULL
- usvAction (usvaction) — INT(11)
- usvDuration (usvduration) — DOUBLE(11)
- pca1Action (pac1action) — INT(11)
- pca1Duration (pca1duration) — DOUBLE(11)
- pca2Action (pca2action) — INT(11)
- pca2Duration (pca2duration) — DOUBLE(11)
- bcaAction (bcaaction) — INT(11)
- bcaDuration — DOUBLE(11)
- endTime (endtime) — DOUBLE(11)
UsvMissionInfo (Usv_Mission)
- USV_MissionInfo_Key (usv_missioninfo_key) — INT(11) — Primary key — NOT NULL
- usvAction (usvaction) — INT(11)
- usvActionStatus (usvactionstatus) — BYTE(1)
- pca1Action (pca1action) — INT(11)
- pca1ActionStatus (pca1actionstatus) — BYTE(1)
- pca2Action (pca2action) — INT(11)
- pca2ActionStatus (pca2actionstatus) — BYTE(1)
UsvMissionPlanInfo (USV_Plan)
- USV_Plan_Key (usv_plan_key) — INT(11) — Primary key — NOT NULL
- missionAlgoNum (missionalgonum) — BYTE(1)
- missionIndex (missionindex) — BYTE(1)
- missionGoal (missiongoal) — BYTE(1)
- bcaLPLat (bcalplat) — DOUBLE(10)
- bcaLPLon (bcalplon) — DOUBLE(10)
- pcaLPLat (pcalplat) — DOUBLE(10)
- pcaLPLon (pcalplon) — DOUBLE(10)
- numWPs — INT(11)
- surveyWPs (numwps) — DOUBLE
UsvNaviInfo (Usv_navi)
- USV_Navi_Key (usv_navi_key) — INT(11) — Primary key — NOT NULL
- usvRoll (usvroll) — DOUBLE
- usvPitch (usvpitch) — DOUBLE
- usvHeading (usvheading) — DOUBLE
- usvLat (usvlat) — DOUBLE
- usvLon (usvlon) — DOUBLE
- usvAlt (usvalt) — DOUBLE
- usvXvel (usvxvel) — DOUBLE
- usvYvel (usvyvel) — DOUBLE
- usvZvel (usvzvel) — DOUBLE
- TBD1 (tbd1) — DOUBLE
- TBD2 (tbd2) — DOUBLe
UsvStatusInfo (USV_Status)
- USV_Status_Key (usv_status_key) — INT(11) — Primary key — NOT NULL
- usvState (usvstate) — SMALLINT(11)
- usvDiagRst (usvdiagrst) — SMALLINT(11)
- TBD (tbd) — SMALLINT(11)
- TBD2 (tdb2) — SMALLINT(11)
- TBD3 (tbd3) — INT(11)
- usvLight (usvlight) — SMALLINT(11)
- TBD4 (tbd4) — SMALLINT(11)
- TBD5 (tbd5) — SMALLINT(11)
- usv12Voltage (usv12voltage) — FLOAT(11)
- usv12vGenVol (usv12vgenvol) — FLOAT(11)
- usv24Voltage (usv24voltage) — FLOAT(11)
- usv24vGenVol (usv24vgenvol) — FLOAT(11)
- stateLThrust (statelthrust) — SMALLINT(11)
- dorLThrust (dorlthrust) — SMALLINT(11)
- rpmLThrust (rpmlthrust) — FLOAT(11)
- stateRThrust (staterthrust) — SMALLINT(11)
- dorRThrust (dorrthrust) — SMALLINT(11)
- rpmRThrust (rpmrthrust) — FLOAT(11)
- stateLMotor (statelmotor) — SMALLINT(11)
- stateLClutch (statelcutch) — SMALLINT(11)
- dorLMotor (dorlmotor) — SMALLINT(11)
- rpmLMotor (rpmlmotor) — FLOAT(11)
- angleLMotor (anglelmotor) — FOLAT(11)
- stateRMotor (statermotor) — SMALLINT(11)
- stateRClutch (staterclutch) — SMALLINT(11)
- dorRMotor (dorrmotor) — SMALLINT(11)
- angleRMotor (anglermotor) — FLOAT(11)
- TBD6 (tbd6) — FLOAT(11)
- TBD7 (tbd7) — FLOAT(11)
- TBD8 (tbd8) — FLOAT(11)
- petDiagRst (petdiagrst) — SMALLINT(11)