Skip to content

Database Tables and Entity Mapping

This page contains information about tables in the MIKE OPERATIONS relational database.

Table schema definitions and diagrams are aligned with MIKE OPERATIONS 2023.

Diagrams are made with the ERD tool of PgAdmin (PostgreSQL).

Analysis Module

Table Entity Description Columns
mca_comparison AnalysisComparison This class implementing analysis comparison.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • blob_id (Guid) - Property: Blob
  • is_mca (Boolean) - Property: IsMCA
    		•
    mca_session AnalysisSession This class implementing analysis session.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • setup_id (Guid) - Property: MCASetupId
  • stakeholder (string) - Property: StakeHolder
  • blob_id (Guid) - Property: Blob
  • is_mca (Boolean) - Property: IsMCA
    		•
    mca_session_comparison MCASessionComparison This class implementing MCA session comparison.
  • id (Guid) - Property: Id
  • session_id (Guid) - Property: MCASessionId
  • comparison_id (Guid) - Property: MCAComparisonId
    		•
    mca_setup AnalysisSetup This class implementing analysis setup.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • blob_id (Guid) - Property: Blob
  • is_mca (Boolean) - Property: IsMCA
  • version (Guid) - Property: Version
  • group_id (Guid) - Property: Group
    		•
    mca_setup_group MCASetupGroup This class implementing MCA setup group.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    mca_tradeoff AnalysisTradeoff This class implementing analysis tradeoff.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • setup_id (Guid) - Property: MCASetupId
  • blob_id (Guid) - Property: Blob
  • is_mca (Boolean) - Property: IsMCA
    		•

    Core

    Table Entity Description Columns
    action Action Class for Action
  • id (Guid) - Property: Id
  • visable (boolean) - Property: Visable
  • enable (boolean) - Property: Enable
  • manger_name (string) - Property: MangerName
  • name (string) - Property: Name
  • workspace_role_id (Guid) - Property: WorkspaceRole
    		•
    dss_admin DssAdmin The DssAdmin class
  • id (Guid) - Property: Id
  • key_data (string) - Property: Key
  • data_value (string) - Property: Value
  • version (Guid) - Property: Version
    		•
    entity_description EntityDescription Base class for group entity
  • id (Guid) - Property: Id
  • entity_type_id (Guid) - Property: EntityTypeId
    		•
    entity_type EntityType Base class for group entity
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • type (string) - Property: Type
    		•
    setting GlobalSetting GlobalSetting class
  • id (Guid) - Property: Id
  • key (string) - Property: Key
  • value (string) - Property: Value
    		•
    global_role GlobalRole The GlobalRole class
  • id (Guid) - Property: Id
  • version (Guid) - Property: Version
  • name (string) - Property: Name
  • user_id (Guid) - Property: User
    		•
    userinfo User User class
  • id (Guid) - Property: Id
  • username (string) - Property: UserName
  • password (string) - Property: Password
  • email (string) - Property: Email
  • fullname (string) - Property: FullName
  • is_admin (bool) - Property: IsAdmin
  • version (Guid) - Property: Version
  • user_type (int) - Property: UserType
  • trusted_account (string) - Property: TrustedAccount
    		•
    user_login_status UserLoginStatus UserLoginStatus class
  • id (Guid) - Property: Id
  • login_failed_count (int) - Property: LoginFailedCount
  • user_id (Guid) - Property: User
    		•
    user_setting UserSetting UserSetting class
  • id (Guid) - Property: Id
  • category (string) - Property: Category
  • key (string) - Property: Key
  • value (string) - Property: Value
  • username (string) - Property: User
    		•
    user_workspace UserWorkspace The UserWorkspace class
  • id (Guid) - Property: Id
  • version (Guid) - Property: Version
  • user_id (Guid) - Property: User
  • workspace_id (Guid) - Property: Workspace
  • role_id (Guid) - Property: Role
    		•
    workspace Workspace Workspace class
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • schema_name (string) - Property: SchemaName
  • is_online (bool) - Property: IsOnline
  • is_shared (bool) - Property: IsShared
  • version (Guid) - Property: Version
    		•
    workspace_role WorkspaceRole WorkspaceRole class
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • version (Guid) - Property: Version
    		•
    workspace_setting WorkspaceSetting WorkspaceSetting class
  • id (Guid) - Property: Id
  • username (string) - Property: User
  • category (string) - Property: Category
  • key (string) - Property: Key
  • value (string) - Property: Value
  • shared (bool) - Property: Shared
    		•
    blob Blob

    Document Module

    Table Entity Description Columns
    document Document SpreadsheetDTO object for NHibernate mapped table 'document'.
  • id (Guid) - Property: Id
  • title (string) - Property: Name
  • author (string) - Property: Author
  • summary (string) - Property: Summary
  • description (string) - Property: Description
  • language (string) - Property: Language
  • keywords (string) - Property: Keywords
  • format (string) - Property: Format
  • data_id (Guid) - Property: Data
  • thumbnail_id (Guid) - Property: ThumbnailID
  • modified_time (datetime) - Property: ModifiedTime
  • version (Guid) - Property: Version
  • is_public (bool) - Property: IsPublic
    		•
    document_feature_assoc DocumentFeatureAssoc This class represenets an associatio between a document and a geographical feature
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • feature_class_id (Guid) - Property: FeatureClassId
  • feature_id (Guid) - Property: FeatureId
  • document_id (Guid) - Property: DocumentId
  • version (Guid) - Property: Version
    		•
    document_folder_association DocumentFolderAssociation DocumentFolderAssociation object for NHibernate mapped table 'document_folder_association'.
  • id (Guid) - Property: Id
  • document_id (Guid) - Property: DocumentId
  • document_folder_id (Guid) - Property: DocumentFolderId
    		•
    document_folder DocumentFolder DocumentGroupDTO object for NHibernate mapped table 'documentFolder'.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    document_relationship DocumentRelationship DocumentRelationship object for NHibernate mapped table 'document_relationship'.
  • id (Guid) - Property: Id
  • document_id (Guid) - Property: DocumentId
  • related_document_id (Guid) - Property: RelatedDocumentId
    		•

    Event Module

    Table Entity Description Columns
    event EventDTO Event table containing events raised by the event service, to be used by other session subscribing to events, e.g. in order to refresh and update the user interface when events are raised. The event table are primaryly containing events raised by the Job Manager (starting, terminating and finishing jobs), but also the Operations Manager are raising events.
  • id (Guid) - Property: Id
  • eventid (int) - Property: Eventid
  • eventname (string) - Property: Eventname
  • eventtype (short) - Property: Eventtype
  • source (string) - Property: Source
  • occuredat (DateTime) - Property: Occuredat
  • userid (Guid) - Property: Userid
  • message (string) - Property: Message
  • data (string) - Property: Data
  • status (int) - Property: Status
    		•

    Favorite Module

    Table Entity Description Columns
    favorite Favorite FavoriteDTO object for NHibernate mapped table 'favorite'.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • type_name (string) - Property: TypeName
  • content (string) - Property: Content
  • template (string) - Property: Template
  • version (Guid) - Property: Version
  • is_public (bool) - Property: IsPublic
  • group_id (Guid) - Property: Group
    		•
    favorite_group FavoriteGroup FavoriteGroupDTO object for NHibernate mapped table 'favorite_group'.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•

    Gauge Module

    Table Entity Description Columns
    gauge_rc RatingCurve Class implementing rating curves
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • h_raw (Guid) - Property: HRawTimeSeriesId
  • h_approved (Guid) - Property: HApprovedTimeSeriesId
  • q_raw (Guid) - Property: QRawTimeSeriesId
  • q_approved (Guid) - Property: QApprovedTimeSeriesId
  • h_observed (Guid) - Property: HObservedTimeSeriesId
  • q_rc (Guid) - Property: QCalculatedTimeSeriesId
    		•
    gauge_rc_feature_assoc RatingCurveFeatureAssociation Class implementing associations between rating curves and features
  • id (Guid) - Property: Id
  • feature_id (Guid) - Property: FeatureId
  • feature_class_id (Guid) - Property: FeatureClassId
  • version (Guid) - Property: Version
  • gauge_rc_id (Guid) - Property: RatingCurve
    		•
    gauge_rc_segment RatingCurveSegment Class implementing rating curve segments
  • id (Guid) - Property: Id
  • date_time (datetime) - Property: DateTime
  • level (double) - Property: Level
  • c_value (double) - Property: CValue
  • n_value (double) - Property: nValue
  • h0_value (double) - Property: H0Value
  • r2_value (double) - Property: R2Value
  • gauge_rc_id (Guid) - Property: RatingCurve
    		•

    GIS Module

    Each feature class contain a reference in the table_name column to a table with the fc_ prefix.

    Tables with the fc_ prefix contains a list of features of the feature class and the geometry of the feature as well as a columnn per feature class attribute containing attribute values of the attributes.

    Table Entity Description Columns
    feature_class FeatureClass FeatureClass represents a set of spatial features with common attributes.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • table_name (string) - Property: TableName
  • display_field (string) - Property: DisplayField
  • is_template (Boolean) - Property: IsTemplate
  • istemporal (Boolean) - Property: IsTemporal
  • group_id (Guid) - Property: Group
    		•
    feature_class_group FeatureClassGroup FeatureClassGroup represents the grouping of feature classes.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • group_id (Guid) - Property: Parent
    		•
    raster_data Raster Raster represents grided data.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • table_name (string) - Property: TableName
  • display_field (string) - Property: DisplayField
  • is_template (Boolean) - Property: IsTemplate
  • istemporal (Boolean) - Property: IsTemporal
  • group_id (Guid) - Property: Group
    		•
    raster_group RasterGroup RasterGroup represents raster grouping.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • group_id (Guid) - Property: Parent
    		•

    Indicator Module

    Table Entity Description Columns
    indicator_definition IndicatorDefinition Represents indicator definition entity.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • script_prepared_id (Guid) - Property: PreparedScriptId
  • version (Guid) - Property: Version
    		•
    indicator_group IndicatorGroup Represents indicator group entity.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•

    Job Module

    With MIKE OPERATIONS 2023.2, job_group was added to support grouping of jobs.

    Table Entity Description Columns
    job Job Job represents the the definition of tasks to execute and the sequence of the tasks.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (string) - Property: Content
  • provider_name (string) - Property: JobServiceProviderName
  • created (DateTime) - Property: Created
  • lastmodified (DateTime) - Property: LastModified
  • targetcomputer (string) - Property: Computer
  • version (Guid) - Property: Version
  • group_id (Guid) - Property: Group
    		•
    job_group JobGroup JobGroup represents the grouping of jobs
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    jobinstance JobInstance JobInstance represents the job runs of a job with time of execution and status.
  • id (Guid) - Property: Id
  • targetcomputer (string) - Property: Computer
  • processid (int) - Property: ProcessID
  • status (int) - Property: Status
  • executed (DateTime) - Property: ExecutedAt
  • finishtime (DateTime) - Property: FinishTime
  • lastupdatetime (DateTime) - Property: LastUpdateTime
  • currenttarget (string) - Property: CurrentTarget
  • currenttask (string) - Property: CurrentTask
  • content (string) - Property: Log
  • jobid (Guid) - Property: JobId
  • tag (string) - Property: Tag
  • version (Guid) - Property: Version
  • provider_ref_id (string) - Property: ProviderReferenceId
    		•

    Metadata Module

    Tables of the metadata module contains both entity metadata and data for the changelog.

    Metadata

    In the metadata diagram, the time series table is shown as an example on how metadata are connected to an entity.

    Metadata can be specified for any entity type. The following entity types are supported.

    • Document
    • Favorite
    • Feature Class
    • MCA comparison
    • MCA setup
    • Indicator
    • Job
    • Model Setup
    • Place
    • MCA session
    • Raster
    • Report definition
    • Scenario
    • Script Storage
    • Simulation
    • Spreadsheet
    • Time Series
    • Workflow
    Table Entity Description Columns
    change_log ChangeLogEntry ChangeLogEntry represents changes made to an entity.
  • id (Guid) - Property: Id
  • sequence (int) - Property: Sequence
  • entity_id (Guid) - Property: EntityId
  • datetime (DateTime) - Property: DateTime
  • activity (string) - Property: Activity
  • site (string) - Property: Site
  • source (string) - Property: Source
  • user_name (string) - Property: UserName
  • description (string) - Property: Description
  • data (string) - Property: Data
  • entity_type_id (Guid) - Property: EntityTypeId
    		•
    language Language Language represents translation langauges for metadata.
  • id (Guid) - Property: Id
  • code (string) - Property: Code
  • name (string) - Property: Name
    		•
    metadata Metadata Metadata represents metadata for an entity (time_series, feature_class, raster, spreadsheet etc.).
  • id (Guid) - Property: Id
  • entity_description_id (Guid) - Property: EntityDescriptionId
  • metadata_values (string) - Property: MetadataValues
    		•
    metadata_schema MetadataSchema MetadataSchema represents metadata schemas for specific entity types.
  • id (Guid) - Property: Id
  • entity_type_id (Guid) - Property: EntityTypeId
  • schema (string) - Property: Schema
    		•
    translated_key TranslatedKey TranslatedKey represents translations for languages.
  • id (Guid) - Property: Id
  • language_id (Guid) - Property: LanguageId
  • key (string) - Property: Key
  • value (string) - Property: Value
    		•

    Operations Module

    Table Entity Description Columns
    operations_manager_image OperationsImage
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • extension (string) - Property: Extension
  • image (Byte[]) - Property: Image
    		•
    operations_manager_state OperationsState
  • id (Guid) - Property: Id
  • path (string) - Property: Path
  • state (int) - Property: State
  • message (string) - Property: Message
    		•
    operations_manager OperationsTree
  • id (Guid) - Property: Id
  • tree (string) - Property: Tree
  • user_id (Guid) - Property: User
  • workspace_id (Guid) - Property: WorkspaceId
  • is_template (bool) - Property: IsTemplate
    		•
    oper_manager_view_settings OperationsViewSettings
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • checkSum (string) - Property: CheckSum
  • settings (string) - Property: Settings
    		•

    Places Module

    Table Entity Description Columns
    place Place Class for Place
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • attribute_value (string) - Property: AttributeValue
  • category (string) - Property: Category
  • feature_id (Guid) - Property: FeatureId
  • place_collection_id (Guid) - Property: PlaceCollectionId
  • version (Guid) - Property: Version
    		•
    place_collection PlaceCollection Class for PlaceCollection
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • attribute_key (string) - Property: AttributeKey
  • feature_class_id (Guid) - Property: FeatureClassId
  • scenario_id (Guid) - Property: ScenarioId
  • version (Guid) - Property: Version
  • group_id (Guid) - Property: Group
    		•
    place_collection_group PlaceCollectionGroup Class for PlaceCollectionGroup
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    place_indicator PlaceIndicator Class for PlaceIndicator
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • aggregation_type (int) - Property: AggregationType
  • time_series_type (int) - Property: TimeSeriesType
  • time_series_id_type (int) - Property: TimeSeriesIdType
  • quantile (double) - Property: Quantile
  • time_series_id (string) - Property: TimeSeriesId
  • connection_info (string) - Property: ConnectionInfo
  • data_type (int) - Property: DataSourceType
  • place_id (Guid) - Property: PlaceId
  • version (Guid) - Property: Version
    		•
    place_indicator_style PlaceIndicatorStyle Class for PlaceIndicatorStyle
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • color (string) - Property: Color
  • place_collection_id (Guid) - Property: PlaceCollectionId
  • version (Guid) - Property: Version
    		•
    place_indicator_threshold PlaceIndicatorThreshold Class for PlaceIndicatorThreshold
  • id (Guid) - Property: Id
  • threshold_index (int) - Property: ThresholdIndex
  • threshold_value (double) - Property: ThresholdValue
  • indicator_style_id (Guid) - Property: IndicatorStyleId
  • place_indicator_id (Guid) - Property: PlaceIndicatorId
  • version (Guid) - Property: Version
    		•
    place_time_interval PlaceTimeInterval Class of PlaceTimeInterval, containing time intervals for places.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • interval_type (int) - Property: IntervalType
  • start_time (double) - Property: StartTime
  • end_time (double) - Property: EndTime
  • place_collection_id (Guid) - Property: PlaceCollectionId
  • version (Guid) - Property: Version
    		•

    Realtime Module

    Table Entity Description Columns
    threshold_cache ThresholdCache
  • id (Guid) - Property: Id
  • configuration_name (string) - Property: ConfigurationName
  • theme_id (string) - Property: ThemeId
  • observation_period_id (string) - Property: ObservationPeriodId
  • observation_period_offset (string) - Property: ObservationPeriodOffset
  • status (int) - Property: Status
  • last_update_time (DateTime) - Property: LastUpdateTime
  • version (Guid) - Property: Version
    		•
    threshold_cache_feature ThresholdCacheFeature
  • id (Guid) - Property: Id
  • cache_id (Guid) - Property: CacheId
  • feature_type_id (string) - Property: FeatureTypeId
  • time_series_definition_id (string) - Property: TimeSeriesDefinitionId
  • feature_id (string) - Property: FeatureId
  • value_type (int) - Property: ValueType
  • variable_code (int) - Property: VariableCode
  • unit_code (int) - Property: UnitCode
  • num_decimals (int) - Property: Decimals
  • version (Guid) - Property: Version
    		•

    Report Module

    Report templates are stored as Word documents in the blob table.

    Table Entity Description Columns
    report_content_item ContentItem
  • id (Guid) - Property: Id
  • report_id (Guid) - Property: ReportId
  • tag_name (string) - Property: TagName
  • content_provider_id (Guid) - Property: ContentProviderId
  • content_formatting (StringClob) - Property: ContentFormattingStr
  • content_configuration (StringClob) - Property: ContentConfigurationStr
  • version (Guid) - Property: Version
    		•
    report Report
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • base_report_id (Guid) - Property: BaseReportId
  • report_writer_id (Guid) - Property: ReportWriterId
  • template_file_name (string) - Property: TemplateFileName
  • template_blob_id (Guid) - Property: TemplateId
  • report_properties (StringClob) - Property: ReportPropertiesStr
  • content_item_tags (StringClob) - Property: ContentItemTagsStr
  • version (Guid) - Property: Version
  • group_id (Guid) - Property: Group
    		•
    report_group ReportGroup
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•

    Scenario Module

    Model Setup Diagram

    Note that some registration information are stored as fast Protobuf formatted text (like XML) in the blob table, so that columns contains id references to the blob table.

    This goes for the following types (columns):

    • Model Object Types (model_object_type_list_blob)
    • Model Objects (model_object_blob)
    • ModelInputTimeseries (input_time_series_blob)
    • ModelOutputTimeseries (output_time_series_blob)

    Scenario Diagram

    Simulation Diagram

    Table Entity Description Columns
    linked_transfer LinkedTransfer LinkedTransfer class which represents a linked transfer between model input and output.
  • id (Guid) - Property: Id
  • model_setup_id (Guid) - Property: ModelSetupId
  • input_time_series_id (Guid) - Property: InputId
  • output_time_series_id (Guid) - Property: OutputId
  • prepared_script_id (Guid) - Property: PreparedScriptId
    		•
    linking_model_s
    etup    		 LinkingModelSetup LinkingModelSetup class which represents a linking model setup for the scenario Manager
  • id (Guid) - Property: Id
  • sequence (int) - Property: Sequence
  • model_setup_id (Guid) - Property: ModelSetupId
  • version (Guid) - Property: Version
  • linked_model_setup_id (Guid) - Property: LinkedModelSetupId
    		•
    model_setup ModelSetup ModelSetup represents the model setup of a registered model.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (Guid) - Property: ContentId
  • model_object_type_list_blob (Guid) - Property: ModelObjectTypeListBlob
  • model_type (string) - Property: ModelType
  • adapter (string) - Property: AdapterReference
  • description (string) - Property: Description
  • simulation_start_date (DateTime) - Property: SimulationStartDate
  • time_of_forecast (DateTime) - Property: TimeOfForecast
  • simulation_end_date (DateTime) - Property: SimulationEndDate
  • indicators_enabled (Boolean) - Property: IndicatorsEnabled
  • is_linking_model (Boolean) - Property: IsLinkingModel
  • version (Guid) - Property: Version
  • output_time_series_blob (Guid) - Property: ModelOutputTimeseriesBlob
  • input_time_series_blob (Guid) - Property: ModelInputTimeseriesBlob
  • model_object_blob (Guid) - Property: ModelObjectBlob
  • save_initcond_to_disk (Boolean) - Property: SaveInitCondToDisk
  • save_simcontent_to_disk (Boolean) - Property: SaveSimContentToDisk
  • folder (string) - Property: Folder
  • layer_setting (string) - Property: LayerSetting
  • model_setup_group_id (Guid) - Property: Group
    		•
    model_setup_gro
    up    		 ModelSetupGroup ModelSetupGroup contains groups of model setups.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    model_setup_ind
    icator_def    		 ModelSetupIndicatorD
    efinition    		 ModelSetupIndicatorDefinition represents a template for creating indicators for a simulation. The simulation indicators can be used in the model optimization.
  • id (Guid) - Property: Id
  • model_setup_id (Guid) - Property: ModelSetupId
  • indicator_definition_id (Guid) - Property: IndicatorDefinitionId
  • version (Guid) - Property: Version
    		•
    model_setup_ini
    tial_conditions    		 ModelInitialConditio
    n    		 ModelInitialCondition represents initial conditions of a model setup stored as blobs in the blob table (ref. content). Initial conditions represents a collection of states covering an interval in time to be used for initializing the model. The nature of these states is defined by the model and the adapter.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (Guid) - Property: ContentId
  • start_date (DateTime) - Property: StartDate
  • end_date (DateTime) - Property: EndDate
  • create_time (DateTime) - Property: CreateTime
  • type (int) - Property: Type
  • model_setup_id (Guid) - Property: ModelSetupId
  • description (string) - Property: Description
    		•
    model_setup_inp
    ut_time_series    		 ModelInputTimeseries ModelInputTimeseries represents input time series of a model setup. Each model input time series is associated to a model object.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • time_series_id (Guid) - Property: TimeseriesId
  • model_setup_object_id (Guid) - Property: ModelObjectId
    		•
    model_setup_obj
    ect    		 ModelObject ModelObject represents a model object of a model setups. Model objects contain a spatial reference as well as model object type information.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • type (Guid) - Property: Type
  • adapter_reference_id (string) - Property: AdapterReference
  • extended_attributes (string) - Property: ExtendedAttributes
  • feature_class_id (Guid) - Property: FeatureClassId
  • feature_id (Guid) - Property: FeatureId
  • model_setup_id (Guid) - Property: ModelSetupId
    		•
    model_setup_oth
    er_output_data    		 ModelOtherOutputData ModelOtherOutputData represents output files connected to the model setup. This includes log files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • content_type (string) - Property: ContentType
  • model_setup_id (Guid) - Property: ModelSetupId
    		•
    model_setup_out
    put_data    		 ModelOutputData ModelOutputData represents output files of the model setup connected to a model object. This includes adapter specific output files like PDF or XML files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • content_type (string) - Property: ContentType
  • model_setup_object_id (Guid) - Property: ModelObjectId
    		•
    model_setup_out
    put_time_series    		 ModelOutputTimeserie
    s    		 ModelOutputTimeseries represents an output time series of a model setup. Each model output time series is associated to a model object.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • model_setup_object_id (Guid) - Property: ModelObjectId
    		•
    model_setup_spa
    tial_in_ts    		 ModelSpatialInputTim
    eseries    		 ModelSpatialInputTimeseries represents spatial input timeseries of a model setup.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • model_setup_object_id (Guid) - Property: ModelObjectId
  • raster_id (Guid) - Property: RasterId
    		•
    model_setup_spa
    tial_output_ts    		 ModelSpatialOutputTi
    meseries    		 ModelSpatialOutputTimeseries represents spatial output timeseries of a model setup.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • adapter_reference_id (string) - Property: AdapterReference
  • model_setup_object_id (Guid) - Property: ModelObjectId
  • spa_type (int) - Property: SpatialType
    		•
    optimization_re
    sult    		 OptimizationResult Class for OptimizationResult. Implements the interface and inherits from the class.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (string) - Property: Content
  • version (Guid) - Property: Version
  • blob_id (Guid) - Property: Blob
  • optimization_scenario_id (Guid) - Property: OptimizationScenario
    		•
    optimization_re
    sult_file    		 OptimizationResultFi
    le    		 class for Optimization result file.
  • id (Guid) - Property: Id
  • content (string) - Property: Content
  • filename (string) - Property: Filename
  • version (Guid) - Property: Version
  • optimization_result_id (Guid) - Property: OptimizationResult
    		•
    optimization_sc
    enario    		 OptimizationScenario Class for OptimizationScenario. Implements the interfaces and inherits from the class.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • xml (string) - Property: Xml
  • xml2 (string) - Property: Xml2
  • description (string) - Property: Description
  • version (Guid) - Property: Version
  • scenario_id (Guid) - Property: ScenarioId
    		•
    sensitivity_ana
    lysis_result    		 SensitivityAnalysisR
    esult    		 Class for SensitivityAnalysisResult. Implements the interface and inherits from the class.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (string) - Property: Content
  • version (Guid) - Property: Version
  • blob_id (Guid) - Property: Blob
  • optimization_scenario_id (Guid) - Property: OptimizationScenario
    		•
    scenario_compar
    ison    		 ScenarioComparison Class for scenario model object.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (string) - Property: Content
  • version (Guid) - Property: Version
    		•
    sce_comp_model_
    setup_assoc    		 ScenarioComparisonMo
    delSetupAssociation    		 ScenarioComparisonModelSetupAssociation class.
  • id (Guid) - Property: Id
  • content (string) - Property: Content
  • scenario_comparison_id (Guid) - Property: ScenarioComparisonId
  • model_setup_id (Guid) - Property: ModelSetupId
    		•
    sce_comp_sim_as
    soc    		 ScenarioComparisonSi
    mulationAssociation    		 ScenarioComparisonSimulationAssociation class.
  • id (Guid) - Property: Id
  • alias (string) - Property: Alias
  • scenario_comparison_id (Guid) - Property: ScenarioComparisonId
  • simulation_id (Guid) - Property: SimulationId
    		•
    scenario Scenario Scenario represents the scenarios of a registered model setup. For a scenario, a number og model objects and input and/or output time series are included. Included input time series defines what input can be changed in the scenario. Included output time series defines what simulation results are imported after a simulation run.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • initial_condition (string) - Property: InitialCondition
  • simulation_dates (string) - Property: SimulationDates
  • model_setup_id (Guid) - Property: ModelSetupId
  • settings (string) - Property: Settings
  • pre_process_script_id (Guid) - Property: PreProPreparedScriptId
  • post_process_script_id (Guid) - Property: PostProPreparedScriptId
  • version (Guid) - Property: Version
  • param_spreadsheet_id (Guid) - Property: ModelObjectParametersSpreadsheetId
    		•
    sce_in_ts_def ScenarioInputTimeser
    iesDefinition    		 ScenarioInputTimeseriesDefinition represents the input time series of the model setup included in the scenario. Scenario input time series included defines the time series able to change in the scenario.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • time_series_id (Guid) - Property: TimeseriesId
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_in_ts_id (Guid) - Property: ModelSetupInputTimeseriesDefinitionId
  • prepared_script_id (Guid) - Property: PreparedScriptId
  • settings (string) - Property: Settings
  • hierachy_definition (string) - Property: HierarchyDefinitionXml
    		•
    scenario_model_
    object    		 ScenarioModelObject ScenarioModelObject represents the model objects of the model setup included in the scenario in order to set model object properties.
  • id (Guid) - Property: Id
  • xml (string) - Property: Xml
  • is_modified (Boolean) - Property: IsScenarioModelObjectModified
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_object_id (Guid) - Property: ModelSetupObjectId
  • parameters_source (int) - Property: ParametersSource
  • parameters_worksheet (string) - Property: ParametersSpreadsheetWorksheet
  • action (int) - Property: Action
    		•
    sce_other_out_d
    ata_def    		 ScenarioOtherOutputD
    ataDefinition    		 ScenarioOtherOutputDataDefinition represents output files connected to the scenario. This includes log files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_other_out_data_id (Guid) - Property: ModelSetupOtherOutputDataDefinitionId
    		•
    sce_out_data_de
    f    		 ScenarioOutputDataDe
    finition    		 ScenarioOutputDataDefinition represents scenario output files connected to a model object. This includes adapter specific output files like PDF or XML files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_output_data_id (Guid) - Property: ModelSetupOutputDataDefinitionId
    		•
    sce_out_ts_def ScenarioOutputTimese
    riesDefinition    		 ScenarioOutputTimeseriesDefinition represents the output time series of the model setup included in the scenario. Scenario output time series included will be stored in the database after a simulation run.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_out_ts_id (Guid) - Property: ModelSetupOutputTimeseriesDefinitionId
  • time_series_id (Guid) - Property: TimeseriesId
  • disposition (int) - Property: Disposition
  • settings (string) - Property: Settings
    		•
    sce_spa_in_ts_d
    ef    		 ScenarioSpatialInput
    TimeseriesDefinition    		 ScenarioSpatialInputTimeseriesDefinition represents the spatial input time series of the model setup included in the scenario. Spatial scenario input time series included defines the spatial time series able to change in the scenario.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_spa_in_ts_id (Guid) - Property: ModelSetupSpatialInputTimeseriesId
  • raster_id (Guid) - Property: RasterId
  • prepared_script_id (Guid) - Property: PreparedScriptId
  • settings (string) - Property: Settings
    		•
    sce_spa_out_ts_
    def    		 ScenarioSpatialOutpu
    tTimeseriesDefinition    		 ScenarioSpatialOutputTimeseriesDefinition represents the output time series of the model setup included in the scenario. Spatial scenario output time series included will be stored in the database after a simulation run.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • is_used (Boolean) - Property: Isused
  • scenario_id (Guid) - Property: ScenarioId
  • model_setup_spa_out_ts_id (Guid) - Property: ModelSetupSpatialOutputTimeseriesId
  • layer_id (Guid) - Property: SpatialLayerId
  • spa_type (int) - Property: SpatialType
  • settings (string) - Property: Settings
    		•
    simulation Simulation Simulation represents simulation runs based on a scenario configuration.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • description (string) - Property: Description
  • simulation_start_date (DateTime) - Property: SimulationStartDate
  • time_of_forecast (DateTime) - Property: TimeOfForecast
  • simulation_end_date (DateTime) - Property: SimulationEndDate
  • content (Guid) - Property: ContentId
  • status (string) - Property: Status
  • out_init_condition_content (Guid) - Property: OutputInitialConditionContentId
  • out_init_condition_start_date (DateTime) - Property: OutputInitialConditionStartDate
  • out_init_condition_end_date (DateTime) - Property: OutputInitialConditionEndDate
  • scenario_id (Guid) - Property: ScenarioId
  • time_of_simulation_run (DateTime) - Property: TimeOfSimulationRun
  • ensemble_runs (int) - Property: EnsembleRuns
  • parent_id (Guid) - Property: ParentId
  • model_setup_id (Guid) - Property: ModelSetupId
  • job_instance_log (string) - Property: JobInstanceLog
  • param_spreadsheet_id (Guid) - Property: ModelObjectParametersSpreadsheetId
  • total_simulation_time (string) - Property: TotalSimulationTime
  • version (Guid) - Property: Version
  • input_initial_condition (string) - Property: InputInitialCondition
  • out_init_condition_description (string) - Property: OutputInitialConditionDescription
    		•
    simulation_indi
    cator    		 SimulationIndicator SimulationIndicatorDTO object for NHibernate mapped table 'simulation_indicator'.
  • id (Guid) - Property: Id
  • calculation_error (string) - Property: CalculationError
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_indicator_def_id (Guid) - Property: ModelSetupIndicatorDefinitionId
  • indicator_id (Guid) - Property: IndicatorId
  • version (Guid) - Property: Version
    		•
    sim_in_ts SimulationInputTimes
    eries    		 SimulationInputTimeseries represents the input timeseries defined by the scenario used for the simulation run.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • time_series_id (Guid) - Property: TimeseriesId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_in_ts_id (Guid) - Property: ModelSetupInputTimeseriesId
  • hierachy_definition (string) - Property: HierarchyDefinitionXml
    		•
    simulation_mode
    l_object    		 SimulationModelObjec
    t    		 SimulationModelObject represents model objects of a scenario used for the simulation run.
  • id (Guid) - Property: Id
  • xml (string) - Property: Xml
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_object_id (Guid) - Property: ModelSetupObjectId
  • parameters_source (int) - Property: ParametersSource
  • parameters_worksheet (string) - Property: ParametersSpreadsheetWorksheet
    		•
    sim_other_out_d
    ata    		 SimulationOtherOutpu
    tData    		 SimulationOtherOutputData represents simulation output files connected to the simulation. This includes log files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (Guid) - Property: ContentId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_other_out_data_id (Guid) - Property: ModelSetupOtherOutputDataId
    		•
    simulation_outp
    ut_data    		 SimulationOutputData SimulationOutputData represents simulation output files connected to a model object. This includes adapter specific output files like PDF or XML files.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (Guid) - Property: ContentId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_output_data_id (Guid) - Property: ModelSetupOutputDataId
    		•
    sim_out_ts SimulationOutputTime
    series    		 SimulationOutputTimeseries represents the output time series results of a simulation. The spatial output time series included is defined by the scenario.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • time_series_id (Guid) - Property: TimeseriesId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_out_ts_id (Guid) - Property: ModelSetupOutputTimeseriesId
    		•
    sim_spa_in_ts SimulationSpatialInp
    utTimeseries    		 SimulationSpatialInputTimeseries represents the spatial input timeseries defined by the scenario used for the simulation run.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • raster_id (Guid) - Property: RasterId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_spa_in_ts_id (Guid) - Property: ModelSetupSpatialInputTimeseriesId
    		•
    sim_spa_out_ts SimulationSpatialOut
    putTimeseries    		 SimulationSpatialOutputTimeseries represents the spatial output time series results of a simulation. The output time series included is defined by the scenario.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • layer_id (Guid) - Property: SpatialLayerId
  • simulation_id (Guid) - Property: SimulationId
  • model_setup_spa_out_ts_id (Guid) - Property: ModelSetupSpatialOutputTimeseriesId
  • spa_type (int) - Property: SpatialType
  • url (string) - Property: SpatialOutputUrl
  • data_provider (string) - Property: DataProvider
    		•

    Script Module

    Table Entity Description Columns
    script_prepared PreparedScript Represents prepared script entity. Class for prepared script.
  • id (Guid) - Property: Id
  • parameter_values (string) - Property: ParameterValuesXml
  • script_id (Guid) - Property: ScriptId
  • version (Guid) - Property: Version
    		•
    script Script Represents script entity.
  • id (Guid) - Property: Id
  • function (string) - Property: Name
  • parameters_definition (StringClob) - Property: ParametersDefinition
  • return_value_definition (StringClob) - Property: ReturnValueDefinition
  • author (string) - Property: Author
  • description (StringClob) - Property: Description
  • version (Guid) - Property: Version
  • group_id (Guid) - Property: Group
  • storage_id (Guid) - Property: Storage
    		•
    script_group ScriptGroup Class represents script group entity.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•
    script_storage ScriptStorage Represents script storage entity.
  • id (Guid) - Property: Id
  • data (StringClob) - Property: Data
  • name (string) - Property: Name
  • last_update (timestamp) - Property: LastUpdate
  • script_type (string) - Property: ScriptType
  • version (Guid) - Property: Version
    		•

    Spreadsheet Module

    Table Entity Description Columns
    spreadsheet Spreadsheet Spreadsheet reprsents Excel type spreadsheets (.xls) stored in the blob table.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • data (Guid) - Property: Data
  • modified_time (datetime) - Property: ModifiedTime
  • version (Guid) - Property: Version
  • is_public (bool) - Property: IsPublic
  • group_id (Guid) - Property: Group
    		•
    spreadsheet_fea
    ture_assoc    		 SpreadsheetFeatureAs
    sociation    		 SpreadsheetFeatureAssociation represents associations between spredasheets and features of feature classes.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • feature_id (Guid) - Property: FeatureId
  • feature_class_id (Guid) - Property: FeatureClassId
  • version (Guid) - Property: Version
  • spreadsheet_id (Guid) - Property: SpreadsheetId
    		•
    spreadsheet_gro
    up    		 SpreadsheetGroup SpreadsheetGroup represents spredasheet groups for grouping spreadsheets.
  • group_id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_group_id (Guid) - Property: Parent
    		•

    Timeseries Module

    Table Entity Description Columns
    time_series_blo
    b    		 DataSeriesBlobDTO Represents time series blobs and the reference to the blob table containg the zipped time series values.
  • id (Guid) - Property: Id
  • time_series_id (Guid) - Property: TimeSeriesId
  • blob_id (Guid) - Property: BlobId
  • start_time (DateTime) - Property: StartTime
  • sequence (int) - Property: Sequence
    		•
    time_series_fla
    g    		 FlagDefinition Time series flag definitions (color, value, description).
  • id (Guid) - Property: Id
  • flag_type_id (Guid) - Property: FlagTypeId
  • flag_value (int) - Property: FlagValue
  • description (string) - Property: Description
  • color (string) - Property: ColorValue
  • version (Guid) - Property: Version
    		•
    time_series_fla
    g_Type    		 FlagType Time series flag types
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
    		•
    time_series_com
    ments    		 TimeSeriesCommentMap
    ping    		 Comments associated to time series.
  • id (Guid) - Property: Id
  • time_series_id (Guid) - Property: TimeSeriesId
  • date_time (DateTime) - Property: DateTime
  • comment_1 (string) - Property: Comments
  • sequence (int) - Property: Sequence
  • version (Guid) - Property: Version
    		•
    time_series DataSeries Dataseries containing time series information. A time series can be of storage type Raw (0) or Blob (1). Time step values of storage type Raw can be found in the time_series_value table. Time step values of storage type Blob can be found in the time_series_blob table.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • eum_type (int) - Property: YAxisVariableCode
  • start_time (DateTime) - Property: _Start
  • end_time (DateTime) - Property: _End
  • time_step (double) - Property: TimeStep
  • value_type (int) - Property: ValueType
  • time_type (int) - Property: XAxisType
  • eum_unit (int) - Property: YAxisUnitCode
  • version (Guid) - Property: Version
  • storage_type (int) - Property: StorageType
  • url (string) - Property: Url
  • time_zone_utc (string) - Property: TimeZoneUTC
  • is_public (bool) - Property: IsPublic
  • xmlinfo (string) - Property: XmlInfo
  • group_id (Guid) - Property: Group
    		•
    ts_feature_asso
    c    		 TimeSeriesFeatureAss
    ociation    		 Associations between time series and features of feature classes in the GIS module.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • feature_id (Guid) - Property: FeatureId
  • feature_class_id (Guid) - Property: FeatureClassId
  • version (Guid) - Property: Version
  • time_series_id (Guid) - Property: TimeSeries
    		•
    ts_flag_type_ma
    pping    		 TimeSeriesFlagMappin
    g    		 Mapping of flags and time series.
  • id (Guid) - Property: Id
  • time_series_id (Guid) - Property: TimeSeriesId
  • date_time (DateTime) - Property: DateTime
  • flag_type_id (Guid) - Property: FlagTypeId
  • flag_value (int) - Property: FlagValue
  • sequence (int) - Property: Sequence
  • version (Guid) - Property: Version
    		•
    time_series_gro
    up    		 TimeSeriesGroup Time series group.
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•

    Workflow Module

    Table Entity Description Columns
    workflow Workflow
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • content (string) - Property: Content
  • version (Guid) - Property: Version
  • provider_name (string) - Property: WorkflowProviderName
  • group_id (Guid) - Property: Group
    		•
    workflow_group WorkflowGroup
  • id (Guid) - Property: Id
  • name (string) - Property: Name
  • version (Guid) - Property: Version
  • parent_id (Guid) - Property: Parent
    		•