Diversity Workbench >
Modules >
Diversity Collection >
Internals >
Database >
Structure of the Database

Structure of the Database

All object of the database like tables, views, roles etc. with their types, description etc.

Diversity Workbench

Search

Home

Manual
Submenu Modules Modules
- Submenu Agents Agents
  - Download
  - Installation
  - Login
  - Tutorial
  - Query
  - Submenu Editing Editing
    - Submenu Tables Tables
      - Spreadsheets
      - Table Editors
    - Agent
    - Contact
    - Descriptors
    - External data
    - Hierarchy
    - Identifier
    - Images
    - Keywords
    - Modules
    - Projects
    - References
    - Relations
    - Resources
    - Synonymy
    - Withholding
  - Submenu Im- & Export Im- & Export
    - Archive
    - Replication
    - Submenu Export Export
      - Backup
      - Export CSV
      - Submenu Export Wizard Export Wizard
        
        Transformation
        
        Tutorial
    - Submenu Import Import
      - Submenu Import wizard Import wizard
        
        Columns
        
        Transformation
  - FAQ
  - Submenu General General
    - Menu
    - Customize
    - Feedback
    - Display types
  - Submenu Internals Internals
    - Version
    - License
    - Submenu Access Access
    - Submenu Database Database
      - Installation
      - Creation
      - Configuration
      - Tables, ...
      - Enumerations
      - History
      - Logging
      - Logins
      - Linked server
      - Tools
      - JSON Cache
      - Submenu Documentation Documentation
        
        chm
        
        HUGO
        
        MediaWiki
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
- Submenu Collection Collection
  - Download
  - Installation
  - Login
  - Submenu Tutorial Tutorial
    - Creation
    - Project
    - Event
    - Localisation
    - Series
    - Specimen
    - Collector
    - Relation
    - Unit
    - Storage
    - Query
  - Query
  - Submenu Editing Editing
    - Submenu Data in Tables Data in Tables
      - Submenu Grids Grids
        
        Series
        
        Event
        
        Specimen
        
        Organisms
        
        Specimen Units
        
        Parts
        
        Images
      - Table Editors
      - Submenu Spreadsheets Spreadsheets
        
        Maps
    - Submenu Event Event
      - Series
      - Images
      - Geography
      - Maps
      - Distribution
      - Plots
      - Habitat
    - Submenu Specimen Specimen
      - Data
      - Specimen tree
      - Display order
      - Accession
      - Images
      - Projects
      - Notes
    - Submenu Organisms Organisms
    - Submenu Storage Storage
      - Part
      - Material
      - Processing
      - Description
    - Collector
    - References
    - Relation
    - Exsiccatae
    - Submenu Images Images
    - Methods
    - Annotation
    - Submenu Collection Collection
      - Collection
      - Manager
      - User
      - Location
      - Plan
    - External Identifier
    - Regulations
    - Submenu Transaction Transaction
      - Submenu Loan Loan
        
        Sending
        
        Confirmation
        
        Forwarding
        
        Reminder
        
        Submenu Return Return
        
        Partial
        
        Request
      - Printing
      - Documents
      - Balance
      - Permit
      - Regulation
      - Removal
      - Embargo
      - Identifier
      - Payment
      - Agent
      - Chart
    - Template
    - Submenu Task.. Task..
      - Exhibition
      - Import
      - Submenu IPM IPM
        
        Architecture
        
        Submenu Recording pests Recording pests
        
        Bycatch
        
        Outside traps
        
        Specimens
        
        Specimen groups
        
        Taxa
        
        Settings
        
        Traps
        
        Treatments
        
        Beneficials
        
        Charts
        
        Cleaning
        
        Collections
        
        Dates
        
        Images
        
        Plans
        
        Report
        
        Sensor
      - Types
  - Submenu Import Export Import Export
    - Archive
    - Submenu Export Export
      - ABCD
      - BIB
      - CSV
      - GPI
      - Naturgucker
      - Submenu Export Wizard Export Wizard
        
        Transformation
        
        Tutorial
      - Label
      - Submenu Cache Database Cache Database
        
        Example
        
        Tutorial
        
        Create DB
        
        Logins
        
        Configuration
        
        Anonym Colletors
        
        Linked Server
        
        Projects
        
        Diagnostics
        
        Submenu Infrastructure Infrastructure
        
        Tables
        
        Views
        
        Functions & procedures
        
        Roles
        
        Submenu Sources Sources
        
        Taxonomy
        
        Terms
        
        Webservices
        
        Agents
        
        Submenu Transfer Transfer
        
        Submenu Transfer Via BCP Transfer Via BCP
        
        Export
        
        Setup
        
        Settings
        
        Auto Transfer
        
        Restrictions
        
        Submenu Postgres Postgres
        
        Replace DB
        
        Copy & Replace DB
        
        Submenu Packages Packages
        
        Add Ons
        
        BioCASE
    - Submenu Import Import
      - Import GFBio
      - Submenu Wizard Wizard
        
        Columns
        
        Transformation
        
        Tutorial
    - Replication
    - Stable Identifier
  - FAQ
  - Submenu General General
    - Submenu Customization Customization
      - Entity, context
      - Main window
    - Menu
    - Feedback
    - Statistics
    - Submenu Query Query
      - Query
      - Scan
      - Results
    - Submenu Maintenance Maintenance
      - Submenu Synchronizing Synchronizing
        
        Submenu Identification Identification
        
        Hierarchy
        
        Renaming
        
        Accepted Names
        
        Identification Terms
        
        Scientific Terms
        
        Agents
        
        Exsiccatae
        
        References
      - Submenu Orphaned Orphaned
        
        Event
        
        Unrelated Data
        
        Annotations
        
        Identifier
        
        Relation
      - Submenu Event & Series.. Event & Series..
        
        Event Series
        
        Gazetteer
        
        Coordinates
        
        Sampling Plots
        
        Event Merge
      - Specimen
      - Organisms
      - Identifications
      - Analysis
      - Images
      - Regulations
      - Tools
      - Storage
      - Reference
      - Collectors
  - Submenu Internals Internals
    - Submenu Database Database
      - Submenu Structure Structure
        
        Tables
        
        Enumerations
        
        Views
        
        Functions
        
        Roles
        
        Submenu Details Details
        
        Event
        
        Regulation
        
        Method
        
        Collection
        
        Project
        
        Analysis
        
        Processing
        
        Transaction
        
        Task
        
        Entity
      - Installation
      - Creation
      - Configuration
      - History
      - Logging
      - Logins
      - Tools
      - JSON Cache
      - Submenu Documentation Documentation
        
        chm
        
        github
        
        HUGO
        
        MediaWiki
    - Version
    - Submenu Data Access.. Data Access..
    - License
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Submenu Modules Modules
      - Connections
      - Setting Connection
      - Submenu Webservices Webservices
        
        Catalogue of Life
        
        Index Fungorum
        
        Palaeontology Database
        
        Pan-European Species directories Infrastructure (PESI)
        
        Recent Literature on Lichens
    - Resources
- Submenu Descriptions Descriptions
  - Download
  - Installation
  - Login
  - Submenu Database Access Database Access
  - Submenu Tutorial Tutorial
  - Submenu Query Overview Query Overview
  - Submenu Extended Query Extended Query
    - Submenu Extended Query Parameter Extended Query Parameter
      - Extended Query Description
      - Submenu Extended Query Descriptor Extended Query Descriptor
        
        Extended Query Categorical
        
        Extended Query Quantitative
        
        Extended Query Sequence
        
        Extended Query Text
      - Extended Query Scope
    - Extended Query Save
  - Submenu Editing Editing
    - Submenu Edit Description Edit Description
    - Submenu Edit Description Grid Edit Description Grid
    - Submenu Edit Descriptor Edit Descriptor
    - Submenu Edit Project Edit Project
    - Submenu Edit Sample Data Grid Edit Sample Data Grid
      - Edit Sample Data Grid Editing
      - Edit Sample Data Grid Save
    - Table Editors
    - Text Editing
  - Submenu Import Export Import Export
    - Submenu Cache Database Cache Database
    - Submenu Export Export
      - Export CSV
      - Export Questionnaires
      - Submenu List Export List Export
        
        Export Descriptions List
        
        Export Descriptors List
        
        Export Resource List
        
        Export Samples List
        
        Export Translation List
      - Matrix Export Wizard
    - Submenu File Operations File Operations
    - Submenu Import Import
      - Submenu Matrix Wizard Matrix Wizard
        
        Matrix Wizard Description
        
        Matrix Wizard Sample
      - Submenu Wizard Wizard
        
        Import DELTA
        
        Import Questionnaires
        
        Import SDD
        
        Import Sessions
        
        Submenu Wizard Advanced Tutorial Wizard Advanced Tutorial
        
        Wizard Advanced Tutorial Step 1
        
        Wizard Advanced Tutorial Step 2
        
        Wizard Advanced Tutorial Step 3
        
        Wizard Advanced Tutorial Step 4
        
        Wizard Advanced Tutorial Step 5
        
        Wizard Advanced Tutorial Step 6
        
        Wizard Advanced Tutorial Step 7
        
        Wizard Advanced Tutorial Step 8
        
        Wizard Advanced Tutorial Step Overview
        
        Wizard Columns
        
        Wizard Transformation
        
        Submenu Wizard Tutorial Wizard Tutorial
        
        Wizard Tutorial Step 1
        
        Wizard Tutorial Step 2
        
        Wizard Tutorial Step 3
        
        Wizard Tutorial Step 4
        
        Wizard Tutorial Step 5
        
        Wizard Tutorial Step 6
        
        Wizard Tutorial Step 7
        
        Wizard Tutorial Step Epilogue
  - Submenu Translations Translations
    - Edit Language Codes
    - Edit Translations
  - Submenu Summarize Data Summarize Data
  - Submenu Generate Document Generate Document
  - Submenu Generate Diagram Generate Diagram
  - Submenu Generate State Statisctics Generate State Statisctics
    - Three Descriptor Statisctics
  - Submenu Maintenance Maintenance
    - Submenu Descriptions Descriptions
      - Clean Descriptions
      - Description Projects
      - Summary Categorical
      - Summary Quantitative
      - Summary Status
      - Submenu Maintenance Violations Maintenance Violations
        
        Maintenance Ambiguous
        
        Maintenance Exclusive
        
        Maintenance Mandatory
    - Submenu Descriptors Descriptors
      - Categorical States
    - Submenu Resources Resources
      - Clean Resources
      - Get Resources
    - Submenu Scopes Scopes
    - Submenu Synchronize Synchronize
    - Submenu Trees Trees
      - Clean
      - Frequency
      - Measure
      - Missing
      - Modifier
  - FAQ
  - Submenu General General
  - Submenu Internals Internals
    - Submenu Database Database
    - License
    - Resources directory
    - Version
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
  - Submenu Workbench Workbench
    - Module Related Entry
    - Modules
    - Submenu Webservice Webservice
- Submenu Exsiccatae Exsiccatae
  - Diversity exsiccatae
  - Tutorial
  - Submenu Editing Editing
  - Import Export
  - Installation
  - Login
  - Query
  - FAQ
  - Submenu General General
    - Menu
    - Feedback
  - Submenu Internals Internals
    - Database
    - Version
    - License
    - Submenu Access Access
      - Administration
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
- Submenu Gazetteer Gazetteer
  - Diversity Gazetteer
  - Submenu Tutorial Tutorial
  - Editing
  - Import Export
  - FAQ
  - General
  - Submenu Internals Internals
    - Submenu Database Database
- Submenu Projects Projects
  - Diversity projects
  - Submenu Editing Editing
    - Project
    - Agents
    - Archive
    - Descriptor
    - Hierarchy
    - Identifier
    - Licenses
    - References
    - Resources
    - Settings
    - History
    - Table Editors
  - Tutorial
  - Submenu Import Export Import Export
    - Submenu Import Import
      - GFBio
  - Installation
  - Login
  - Query
  - FAQ
  - Submenu General General
    - Menu
    - Feedback
  - Submenu Internals Internals
    - Submenu Database Database
      - Tables, ...
      - Enumerations
    - Version
    - License
    - Submenu Access Access
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
- Submenu References References
  - Diversity references
  - Installation
  - Login
  - Tutorial
  - Query
  - Submenu Editing Editing
    - Authors
    - Keywords
    - Marker
    - Abstract
    - Notes
    - Availability
    - Projects
    - Images
    - Links
    - Hierarchy
  - Submenu Import Export Import Export
    - Submenu Export Export
      - Export CSV
      - Export Text
      - Submenu Export Wizard Export Wizard
        
        Transformation
        
        Tutorial
    - Submenu Import Import
      - Import Text
      - Submenu Import wizard Import wizard
        
        Columns
        
        Transformation
    - Reference Manager
  - FAQ
  - Submenu General General
    - High Resolution
    - Feedback
  - Submenu Internals Internals
    - Submenu Administration Administration
    - Submenu Database Database
      - Tables, ...
      - Installation
      - Project tables
      - Enumerations
      - Creation
      - Configuration
      - History
      - Logging
      - Logins
      - Linked server
      - Tools
      - Submenu Documentation Documentation
        
        chm
        
        HUGO
        
        MediaWiki
    - License
    - Submenu Access Access
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
- Submenu Sampling plots Sampling plots
  - Diversity sampling plots
  - Submenu Tutorial Tutorial
    - Backlinks
    - Edit Plots
    - Hierarchy
    - Import wizard
    - Localisation
    - Maps
    - Properties
    - Query
    - Query Results
    - Resources
  - Submenu Editing Editing
    - Projects
  - Import Export
  - FAQ
  - Submenu General General
    - Menu
  - Submenu Internals Internals
    - Feedback
    - Maintenance
    - Submenu Database Database
      - Tables, ...
- Submenu Scientific terms Scientific terms
  - Diversity Scientific terms
  - Submenu Editing Editing
    - Chart
    - Dependency
    - Hierarchy
    - History
    - Language
    - Properties
    - Ranking terms
    - References
    - Resources
    - Sections
    - Synonyms
    - Table Editors
    - Terminology
  - Tutorial
  - Import Export
  - FAQ
  - Submenu General General
    - Menu
  - Submenu Internals Internals
    - Manual
    - Submenu Database Database
      - Tables, ...
      - Enumerations
- Submenu Taxon names Taxon names
  - Download
  - Tutorial
  - Submenu Editing Editing
    - External databases
    - Hierarchy
    - List view
    - Menu
    - Projects
    - References
    - Relations
    - Synonymy
    - Submenu Taxon List Taxon List
      - Taxon List User
    - Edit Taxa In List
    - Data
    - Taxonomic Name
    - Authors
    - Nomenclature
    - Protologue
    - Typification
    - x Hybrids
    - Common names
    - Ignored Data
    - Geography
    - Resources
  - Submenu Import Export Import Export
    - Submenu Import Import
      - List import
      - Submenu Wizard Wizard
        
        Submenu Tutorial Tutorial
        
        Hierarchy 1
        
        Hierarchy 2
        
        Hierarchy 3
        
        Synonyms
    - Submenu Export Export
      - Hierarchy, synonymy
      - List
  - FAQ
  - General
  - Submenu Internals Internals
    - Submenu Database Database
    - Submenu Workbench Workbench
Submenu Special software Special software
- Submenu GIS Editor GIS Editor
- Submenu BayernFlora BayernFlora
  - Download
  - Submenu Export Export
    - Taxa wie in Liste
    - SQL export
  - Wartung
- Submenu GUC GUC
  - Download
  - Internals
  - Artcode
  - Nachweis
  - TK25
Submenu Development Development
- Submenu Architecture Architecture
  - Migrations
  - Synchronize
- Submenu Roadmap Roadmap
  - IPM
- Submenu HUGO HUGO
  - HUGO
  - Links
- github

Language
Theme

Built for with by Hugo