Workbench >
Modules >
Collection >
Internals >
Database >
Structure

Structure of the Database

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

Details
Enumerations
Functions
Roles
Tables
Views

Dec 28, 2024

Diversity Workbench

Search

Home

Manual
Submenu Best practice Best practice
Submenu Workflows Workflows
Submenu Modules Modules
- Submenu Agents Agents
  - Download
  - Installation
  - Login
  - Menu
  - Tutorial
  - Query
  - Submenu Editing Editing
    - Display types
    - New & Delete
    - Submenu Tables Tables
      - Spreadsheets
      - Table Editors
    - Contact
    - Descriptors
    - External data
    - Hierarchy
    - Identifier
    - Images
    - Keywords
    - Submenu Modules Modules
      - Module Related Entry
    - Projects
    - References
    - Relations
    - Resources
    - Synonymy
    - Withholding
  - Submenu Im- & Export Im- & Export
    - Archive
    - Replication
    - Submenu Export Export
      - Backup
      - CSV
      - Submenu Export Wizard Export Wizard
        
        Transformation
        
        Tutorial
    - Submenu Import Import
      - Submenu Import wizard Import wizard
        
        Columns
        
        Transformation
  - FAQ
  - Customize
  - Submenu Internals Internals
    - Version
    - License
    - Submenu Access Access
    - Submenu Database Database
      - Installation
      - Creation
      - Configuration
      - Model
      - Tables, ...
      - Enumerations
      - History
      - Logging
      - Logins
      - Linked server
      - Tools
      - JSON Cache
      - Submenu Documentation Documentation
        
        chm
        
        HUGO
        
        MediaWiki
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
    - Settings
- Submenu Collection Collection
  - Download
  - Installation
  - Login
  - Menu
  - Submenu Tutorial Tutorial
    - Creation
    - Event
    - Localisation
    - Series
    - Specimen
    - Collector
    - Relation
    - Organisms
    - Storage
    - Query
  - Submenu 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
      - Copy Specimen
      - 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
    - 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
      - Types
  - Submenu Import Export Import Export
    - Archive
    - Submenu Export Export
      - ABCD
      - BIB
      - CSV
      - Submenu Export Wizard Export Wizard
        
        Transformation
        
        Tutorial
      - GPI
      - Label
      - Naturgucker
      - 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
        
        Auto Transfer
        
        Settings
        
        Transfer Protocol
        
        Submenu Transfer Via BCP Transfer Via BCP
        
        Export
        
        Setup
        
        Restrictions
        
        Submenu Postgres Postgres
        
        Copy & Replace DB
        
        Replace DB
        
        Submenu Packages Packages
        
        ABCD
        
        Add Ons
        
        BioCASE
    - Submenu Import Import
      - Import GFBio
      - Submenu Wizard Wizard
        
        Columns
        
        Transformation
        
        Tutorial
    - Replication
    - Stable Identifier
  - FAQ
  - Statistics
  - Submenu Customization Customization
  - Submenu Maintenance Maintenance
    - Submenu Synchronizing Synchronizing
      - Submenu Identification Identification
        
        Hierarchy
        
        Renaming
        
        Accepted Names
        
        Identification Terms
        
        Scientific Terms
      - Agents
      - Exsiccatae
      - References
    - Submenu Orphaned Orphaned
    - Submenu Event & Series.. Event & Series..
    - 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
      - Backup
      - History
      - Restore
      - Logging
      - Logins
      - Linked server
      - Tools
      - JSON Cache
      - Submenu Documentation Documentation
        
        chm
        
        github
        
        HUGO
        
        MediaWiki
      - Database Description
    - Dataset Version
    - Version
    - Submenu Data Access Data Access
    - License
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Submenu Modules Modules
      - Connections
      - Setting Connections
      - Submenu Webservices Webservices
        
        CoL
        
        Index Fungorum
        
        PbDb
        
        PESI
        
        RLL
      - Description
    - Resources
    - Settings
- 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
      - Submenu Maintenance Violations Maintenance Violations
        
        Maintenance Ambiguous
        
        Maintenance Exclusive
        
        Maintenance Mandatory
      - Summary Categorical
      - Summary Quantitative
      - Summary Status
    - 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
  - Download
  - Menu
  - Submenu Editing Editing
  - Installation
  - Login
  - Query
  - Submenu Internals Internals
    - Database
    - Tables, ...
    - Version
    - License
    - Submenu Access Access
      - Administration
    - History
    - Submenu Update Update
      - Client
      - Database
    - Errorlog
    - Connections
    - Resources
    - Settings
- Submenu Gazetteer Gazetteer
  - Submenu Download Download
    - Installation
  - Submenu Tutorial Tutorial
  - Submenu Import Export Import Export
    - Submenu Import Import
      - Import wizard
    - Submenu Export Export
      - Backup
  - FAQ
  - Submenu General General
    - Feedback
  - Submenu Internals Internals
    - Submenu Database Database
    - Hierarchy
- Submenu Projects Projects
  - Download
  - Installation
  - Login
  - Menu
  - Query
  - Submenu Editing Editing
    - Project
    - Agents
    - Archive
    - Descriptor
    - Hierarchy
    - Identifier
    - Licenses
    - References
    - Resources
    - Settings
    - History
    - Table Editors
  - Submenu Import Export Import Export
    - Submenu Import Import
      - GFBio
  - FAQ
  - Feedback
  - Submenu Internals Internals
    - Submenu Database Database
    - Version
    - License
    - Submenu Access Access
    - Submenu Update Update
      - Client
      - Database
    - Diversity projects
    - Connections
    - Diversity projects
    - Settings
- Submenu References References
  - Download
  - 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
      - Installation
      - Project tables
      - 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
  - Download
  - Installation
  - Login
  - Menu
  - Submenu Tutorial Tutorial
    - Backlinks
    - Edit Plots
    - Hierarchy
    - Import wizard
    - Localisation
    - Maps
    - Properties
    - Query
    - Query Results
    - Resources
  - Query
  - Submenu Editing Editing
    - Projects
  - Import Export
  - FAQ
  - Submenu General General
    - License
  - Submenu Internals Internals
    - Maintenance
    - Submenu Database Database
      - Tables, ...
      - JSON Cache
    - Settings
- Submenu Scientific terms Scientific terms
  - Download
  - Installation
  - Login
  - Menu
  - Query
  - Submenu Editing Editing
    - Chart
    - Dependency
    - Hierarchy
    - History
    - Language
    - Properties
    - Ranking terms
    - References
    - Resources
    - Sections
    - Synonyms
    - Table Editors
    - Terminology
  - Import Export
  - Submenu Internals Internals
    - Submenu Database Database
    - Settings
- Submenu Taxon names Taxon names
  - Submenu Download Download
    - Installation
  - Menu
  - Query
  - Submenu Editing Editing
    - External databases
    - Hierarchy
    - List view
    - Projects
    - References
    - Relations
    - Synonymy
    - Submenu Taxon List Taxon List
      - Taxon List Analysis
      - Taxon List User
    - Edit Taxa In List
    - Data
    - Taxonomic Name
    - Authors
    - Nomenclature
    - Protologue
    - Typification
    - 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
  - Submenu General General
    - Feedback
  - Submenu Internals Internals
    - Submenu Database Database
    - Submenu Workbench Workbench
    - Settings
Submenu Special software Special software
- Submenu GIS Editor GIS Editor
  - Layout
  - Submenu Modes Modes
    - Map Mode
    - Shift Mode
    - Area Mode
    - Line Mode
    - Point Mode
    - Edit Mode
    - Adapt Mode
  - Submenu Samples Samples
  - GPS Tracking
  - Settings
  - Sample Detection
  - Selecting Samples
  - Videos
- Submenu BayernFlora BayernFlora
  - Download
  - Submenu Export Export
  - Wartung
- Submenu GUC GUC
  - Download
  - Internals
  - Artcode
  - Nachweis
  - TK25
Submenu Development Development
- Submenu Architecture Architecture
- Submenu Roadmap Roadmap
  - Version 8
  - IPM
- Submenu HUGO HUGO
  - HUGO
  - Links
- github
- Icons

Language
Theme

Built for with by Hugo