-- EwE 6 Ecosim tables as SQLite: 27 tables. -- Source: "Anchovy Bay Spatial.ewemdb" in the Official EwE repository -- (github.com/Official-EwE/Eii.Ecopath, commit 9a52c24; saved by EwE 6.7.0.19005, -- database version 67019), read with mdb-tools 1.0.1: -- mdb-schema --no-not-null -T sqlite -- which is the command of EwE's Tools/mdb2sqlite bridge. CREATE TABLE `EcosimModel` ( `ModelID` INTEGER, `ForcePoints` INTEGER , PRIMARY KEY (`ModelID`) ); CREATE TABLE `EcosimScenario` ( `ScenarioID` INTEGER, `ScenarioName` varchar, `Description` TEXT, `Author` varchar, `Contact` varchar, `LastSaved` REAL, `NutForcingShapeID` INTEGER, `TotalTime` INTEGER, `StepSize` REAL, `EquilibriumStepSize` REAL, `EquilScaleMax` REAL, `sorwt` REAL, `SystemRecovery` REAL, `Discount` REAL, `NudgeStart` REAL, `NudgeEnd` REAL, `NudgeFactor` REAL, `DoInteg` INTEGER, `UseNudge` INTEGER, `NutBaseFreeProp` REAL, `NutPBmax` REAL, `UseVarPQ` INTEGER, `LastSavedVersion` varchar, `ForagingTimeLowerLimit` REAL , PRIMARY KEY (`ScenarioID`) ); CREATE INDEX `EcosimScenario_NutForceShapeID_idx` ON `EcosimScenario` (`NutForcingShapeID`); CREATE INDEX `EcosimScenario_ScenarioID_idx` ON `EcosimScenario` (`ScenarioID`); CREATE TABLE `EcosimScenarioArena` ( `ScenarioID` INTEGER, `PreyID` INTEGER, `PredID` INTEGER, `PredSharedID` INTEGER, `PeatArena` REAL, `Sequence` INTEGER , PRIMARY KEY (`ScenarioID`, `PreyID`, `PredID`, `PredSharedID`) ); CREATE TABLE `EcosimScenarioCapacityDrivers` ( `ScenarioID` INTEGER, `GroupID` INTEGER, `DriverID` INTEGER, `ResponseID` INTEGER, `Target` INTEGER , PRIMARY KEY (`ScenarioID`, `GroupID`, `DriverID`, `ResponseID`, `Target`) ); CREATE TABLE `EcosimScenarioFleet` ( `ScenarioID` INTEGER, `EcopathFleetID` INTEGER, `FishRateShapeID` INTEGER, `MaxEffort` REAL, `QuotaType` INTEGER, `Epower` REAL, `PCapBase` REAL, `CapDepreciate` REAL, `CapBaseGrowth` REAL, `CV` REAL, `QIncrease` REAL, `CatchRefLower` REAL, `CatchRefUpper` REAL, `EffortRefLower` REAL, `EffortRefUpper` REAL, `MSYEvaluateFleet` INTEGER, `FleetID` INTEGER, `EffortConversionFactor` REAL , PRIMARY KEY (`ScenarioID`, `EcopathFleetID`) ); CREATE INDEX `EcosimScenarioFleet_EcopathFleetID_idx` ON `EcosimScenarioFleet` (`EcopathFleetID`); CREATE UNIQUE INDEX `EcosimScenarioFleet_FleetID_idx` ON `EcosimScenarioFleet` (`FleetID`); CREATE INDEX `EcosimScenarioFleet_ScenarioID_idx` ON `EcosimScenarioFleet` (`ScenarioID`); CREATE TABLE `EcosimScenarioFleetYear` ( `ScenarioID` INTEGER, `FleetID` INTEGER, `TimeYear` INTEGER, `CV` REAL , PRIMARY KEY (`ScenarioID`, `FleetID`, `TimeYear`) ); CREATE INDEX `EcosimScenarioFleetYear_EcosimScenarioFleetTimeFleetID_idx` ON `EcosimScenarioFleetYear` (`FleetID`); CREATE TABLE `EcosimScenarioForcingMatrix` ( `ScenarioID` INTEGER, `PredID` INTEGER, `PreyID` INTEGER, `vulnerability` REAL , PRIMARY KEY (`ScenarioID`, `PreyID`, `PredID`) ); CREATE TABLE `EcosimScenarioGroup` ( `ScenarioID` INTEGER, `EcopathGroupID` INTEGER, `GroupID` INTEGER, `FishMortShapeID` INTEGER, `Pbmaxs` REAL, `FtimeMax` REAL, `FtimeAdjust` REAL, `MoPred` REAL, `FishRateMax` REAL, `Show` INTEGER, `RiskTime` REAL, `QmQo` REAL, `CmCo` REAL, `SwitchPower` REAL, `FishMortMax` REAL, `Blim` REAL, `Bbase` REAL, `Fopt` REAL, `Kalwt` REAL, `BiomassCV` REAL, `LowerRisk` REAL, `UpperRisk` REAL, `BiomassRefLower` REAL, `BiomassRefUpper` REAL, `CatchRefLower` REAL, `CatchRefUpper` REAL, `FixedEscapement` REAL, `RStockRatio` REAL, `RHalfB0Ratio` REAL, `RecruitmentCV` REAL, `FixedF` REAL, `AdditivePredMort` REAL , PRIMARY KEY (`ScenarioID`, `EcopathGroupID`) ); CREATE INDEX `EcosimScenarioGroup_EcopathGroupID_idx` ON `EcosimScenarioGroup` (`EcopathGroupID`); CREATE UNIQUE INDEX `EcosimScenarioGroup_GroupID_idx` ON `EcosimScenarioGroup` (`GroupID`); CREATE INDEX `EcosimScenarioGroup_ScenarioID_idx` ON `EcosimScenarioGroup` (`ScenarioID`); CREATE TABLE `EcosimScenarioGroupYear` ( `ScenarioID` INTEGER, `GroupID` INTEGER, `TimeYear` INTEGER, `CVBiom` REAL , PRIMARY KEY (`ScenarioID`, `GroupID`, `TimeYear`) ); CREATE INDEX `EcosimScenarioGroupYear_EcosimScenarioGroupTimeGroupID_idx` ON `EcosimScenarioGroupYear` (`GroupID`); CREATE TABLE `EcosimScenarioLandingsShape` ( `ScenarioID` INTEGER, `FleetID` INTEGER, `GroupID` INTEGER, `ShapeID` INTEGER, `FunctionType` INTEGER , PRIMARY KEY (`ScenarioID`, `FleetID`, `GroupID`, `ShapeID`) ); CREATE TABLE `EcosimScenarioMSE` ( `ScenarioID` INTEGER, `AssessMethod` INTEGER, `AssessPower` REAL, `NTrials` INTEGER, `StartIndex` INTEGER, `MaxEffort` REAL , PRIMARY KEY (`ScenarioID`) ); CREATE UNIQUE INDEX `EcosimScenarioMSE_ScenarioID_idx` ON `EcosimScenarioMSE` (`ScenarioID`); CREATE TABLE `EcosimScenarioPredPreyShape` ( `ScenarioID` INTEGER, `PredID` INTEGER, `PreyID` INTEGER, `ShapeID` INTEGER, `FunctionType` INTEGER , PRIMARY KEY (`ScenarioID`, `PredID`, `PreyID`, `ShapeID`) ); CREATE INDEX `EcosimScenarioPredPreyShape_ScenarioID_idx` ON `EcosimScenarioPredPreyShape` (`ScenarioID`); CREATE TABLE `EcosimScenarioQuota` ( `ScenarioID` INTEGER, `EcosimGroupID` INTEGER, `FleetID` INTEGER, `Quota` REAL, `Fweight` REAL, `QuotaShare` REAL , PRIMARY KEY (`ScenarioID`, `EcosimGroupID`, `FleetID`) ); CREATE INDEX `EcosimScenarioQuota_EcosimScenarioID_idx` ON `EcosimScenarioQuota` (`ScenarioID`); CREATE INDEX `EcosimScenarioQuota_FleetID_idx` ON `EcosimScenarioQuota` (`FleetID`); CREATE INDEX `EcosimScenarioQuota_GroupID_idx` ON `EcosimScenarioQuota` (`EcosimGroupID`); CREATE TABLE `EcosimScenarioShapeMedWeightsFleet` ( `ScenarioID` INTEGER, `ShapeID` INTEGER, `FleetID` INTEGER, `MedWeights` REAL , PRIMARY KEY (`ScenarioID`, `ShapeID`, `FleetID`) ); CREATE INDEX `EcosimScenarioShapeMedWeightsFleet_ScenarioID_idx` ON `EcosimScenarioShapeMedWeightsFleet` (`ScenarioID`); CREATE TABLE `EcosimScenarioshapeMedWeightsGroup` ( `ScenarioID` INTEGER, `ShapeID` INTEGER, `GroupID` INTEGER, `MedWeights` REAL , PRIMARY KEY (`ScenarioID`, `ShapeID`, `GroupID`) ); CREATE INDEX `EcosimScenarioshapeMedWeightsGroup_ScenarioID_idx` ON `EcosimScenarioshapeMedWeightsGroup` (`ScenarioID`); CREATE TABLE `EcosimScenarioshapeMedWeightsLandings` ( `ScenarioID` INTEGER, `GroupID` INTEGER, `FleetID` INTEGER, `ShapeID` INTEGER, `MedWeights` REAL , PRIMARY KEY (`ScenarioID`, `GroupID`, `FleetID`, `ShapeID`) ); CREATE TABLE `EcosimShape` ( `ShapeID` INTEGER, `ShapeType` INTEGER, `IsSeasonal` INTEGER , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShape_ShapeID_idx` ON `EcosimShape` (`ShapeID`); CREATE TABLE `EcosimShapeEggProd` ( `ShapeID` INTEGER, `zScale` TEXT, `Title` varchar, `zMaxScale` REAL, `FunctionType` INTEGER, `FunctionParams` TEXT , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShapeEggProd_ShapeID_idx` ON `EcosimShapeEggProd` (`ShapeID`); CREATE TABLE `EcosimShapeFishMort` ( `ShapeID` INTEGER, `zScale` TEXT, `Title` varchar , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShapeFishMort_ShapeID_idx` ON `EcosimShapeFishMort` (`ShapeID`); CREATE TABLE `EcosimShapeFishRate` ( `ShapeID` INTEGER, `zScale` TEXT, `Title` varchar , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShapeFishRate_ShapeID_idx` ON `EcosimShapeFishRate` (`ShapeID`); CREATE TABLE `EcosimShapeMediation` ( `ShapeID` INTEGER, `zScale` TEXT, `Title` varchar, `IMedBase` INTEGER, `FunctionType` INTEGER, `XAxisMin` REAL, `XAxisMax` REAL, `FunctionParams` TEXT, `Units` varchar , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShapeMediation_ShapeID_idx` ON `EcosimShapeMediation` (`ShapeID`); CREATE TABLE `EcosimShapeTime` ( `ShapeID` INTEGER, `zScale` TEXT, `Title` varchar, `zMaxScale` REAL, `FunctionType` INTEGER, `ApplicationType` INTEGER, `FunctionParams` TEXT , PRIMARY KEY (`ShapeID`) ); CREATE INDEX `EcosimShapeTime_ShapeID_idx` ON `EcosimShapeTime` (`ShapeID`); CREATE TABLE `EcosimStanzaShape` ( `StanzaID` INTEGER, `EggprodShapeID` INTEGER, `HatchCodeShapeID` INTEGER , PRIMARY KEY (`StanzaID`) ); CREATE INDEX `EcosimStanzaShape_EggprodShapeID_idx` ON `EcosimStanzaShape` (`EggprodShapeID`); CREATE INDEX `EcosimStanzaShape_HatchCodeShapeID_idx` ON `EcosimStanzaShape` (`HatchCodeShapeID`); CREATE INDEX `EcosimStanzaShape_StanzaID_idx` ON `EcosimStanzaShape` (`StanzaID`); CREATE TABLE `EcosimTimeSeries` ( `TimeSeriesID` INTEGER, `DatasetID` INTEGER, `Sequence` INTEGER, `DatType` INTEGER, `DatName` varchar, `TimeValues` TEXT, `WtType` REAL, `CV` REAL , PRIMARY KEY (`TimeSeriesID`) ); CREATE INDEX `EcosimTimeSeries_DatasetID_idx` ON `EcosimTimeSeries` (`DatasetID`); CREATE INDEX `EcosimTimeSeries_TimeSeriesID_idx` ON `EcosimTimeSeries` (`TimeSeriesID`); CREATE TABLE `EcosimTimeSeriesDataset` ( `DatasetID` INTEGER, `DatasetName` varchar, `Description` TEXT, `Author` varchar, `Contact` varchar, `FirstYear` INTEGER, `DataInterval` INTEGER, `NumPoints` INTEGER , PRIMARY KEY (`DatasetID`) ); CREATE UNIQUE INDEX `EcosimTimeSeriesDataset_DatasetID_idx` ON `EcosimTimeSeriesDataset` (`DatasetID`); CREATE TABLE `EcosimTimeSeriesFleet` ( `TimeSeriesID` INTEGER, `FleetID` INTEGER, `GroupID` INTEGER , PRIMARY KEY (`TimeSeriesID`) ); CREATE INDEX `EcosimTimeSeriesFleet_GroupID_idx` ON `EcosimTimeSeriesFleet` (`FleetID`); CREATE INDEX `EcosimTimeSeriesFleet_TimeSeriesID_idx` ON `EcosimTimeSeriesFleet` (`TimeSeriesID`); CREATE TABLE `EcosimTimeSeriesGroup` ( `TimeSeriesID` INTEGER, `GroupID` INTEGER, `VariableName` varchar , PRIMARY KEY (`TimeSeriesID`) ); CREATE INDEX `EcosimTimeSeriesGroup_GroupID_idx` ON `EcosimTimeSeriesGroup` (`GroupID`); CREATE INDEX `EcosimTimeSeriesGroup_TimeSeriesID_idx` ON `EcosimTimeSeriesGroup` (`TimeSeriesID`);