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)