Skip to main content

Database Metadata Management

Defining Additional Metadata for the Database​

Our system allows users to define additional metadata for the database to enhance data management and retrieval. This feature provides flexibility and improved organization of database elements.

Steps to Define Metadata​

  1. Access Metadata Configuration: Navigate to the metadata configuration section in the organisation settings.

  2. Add Metadata Field:

    • Click on the Edit button on the specific database

    • You can add a new metadata by filling in the form with the following details:

        • Schema Name: The name of the database.
        • Description: A brief description of the metadata field.
        • Table Name: The name of the table.
        • Type: The data type of the metadata field (e.g., string, integer, date).
        • Field Name: The name of the metadata field.
        • Value: The value of the metadata field.
        • Foreign Keys: Additional foreign keys for the metadata field.

Benefits​

  • Improved Data Organization: Metadata helps in categorizing and describing database elements.
  • Better Documentation: Provides additional context and information about the database structure.