Contents x
      EdgeReady Database
      • 05 Jul 2023
      • 3 Minutes to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Contents

      EdgeReady Database

      • Updated on 05 Jul 2023
      • 3 Minutes to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Article Summary

      Database is a repository where the DB tables are stored. These are local files pertaining to the Project.
      In the Database Tab, there is a Panel on the left with a Tables and Library section that lists Tables.
      Image 4.png

      NOTE

      Refer the Library Section to understand the how tables are managed Libraries within the EdgeReady Cloud.

      How to Create a New Table?

      At the bottom of the panel, there is a + New Table button to create new DB Tables. Additionally, there is an option to Import and Export Tables on the top left corner of the DB page.

      1. Clicking the + New Table button opens the following popup screen. The user enters a valid table name and inputs the data.
        new table
      2. After a table is created, it is displayed in the Tables section. The user can create columns by click the + Button on the right side of the page.
        new column creation.png
      NOTE

      The Table Name "Requester" is meant for representation purpose only.

      How to Add Columns to a Table?

      For creating new columns, certain input fields are required to be filled. The fields with their descriptions are explained below.

      FieldDescription
      NameName of the column.
      TypeData type of the column values. Additional fields show up depending on the data type.
      DefaultDefault value given in case if the column is not given a value.
      Is Primary Key?For mentioning whether the column value can be Referenced to other tables and columns.
      Set Index?By checking Set Index we can retrieve the data specific to that column much faster.
      Not NullThe column cell will not remain empty if Not Null is selected. It will automatically be selected if the Primary Key reference checkbox is also selected.
      LengthTo set a length for the number of characters in the column.
      Auto Increment ColumnTo automatically increment the column values as the table is being populated.
      ScaleTo set a limitation to the number of decimal values after the dot. Once entered, the value does not exceed a particular limit.
      Cancel/Save ButtonsTo Cancel/Save the column.

      Exceptions:

      1. For Int, BigInt, Double, Float, Decimal, Varchar, Text, Blob, Binary Data Types, Length is displayed.
        column fields 1

      2. For Int, BigInt Data Types, another field called Auto Increment Column? is displayed.
        column field 2

      3. For Double, Float, Decimal Data Types, a field called Scale is displayed.
        column field 3

      After creating two columns, the table appears as:
      pasted image 0 17.png

      NOTE

      ReqEmp and EmpID are names of the columns as examples

      How to insert column values?

      Ideally, the column values are dynamically added in the Integration Builder through CREATE operation for the EdgeReady DB or External DB.

      NOTE

      Static values in the column can also be inserted using SQL Queries in the SQL Query section of the Database. The SQL queries can be executed separately using the Execute button.

      sql query.png

      How to Edit Tables?

      For editing a table, the user can select the 3 vertical dots (vertical ellipses) that is present on the right of each table.
      edit table

      The table editing options are described below:
      1, Rename Table - To Rename the table. A popup appears where a new name is entered and saved.
      rename table popup

      1. Share to Library - To share the table to the Library
      NOTE

      On the Library section of the Main Menu, the Table is displayed on the Database Table Section.

      3, Duplicate Table - To create a copy of the current table
      duplicate.png

      4, Delete Table - Deletes the table
      delete table.PNG

      How to edit Columns?

      For columns, the user can select the downward arrow that is present on the right of each column to edit the column.
      column edit

      The column editing options are described below:

      1. Customize Column - It opens the fields that were available during column creation. Any changes required can be incorporated to the column.

      2. Duplicate Column - Creates another column with similar properties
        duplicate column.png

      3. Foreign Key - Requests for a reference Table and Column for Foreign Key creation.
        pasted image 0 21.png

      NOTE

      Clicking foreign Key option requests the user to select a reference table and column to create a Foreign Key for the particular selected column.

      1. Delete Column - Deletes the column
        delete column.png

      2. Sort A- Z/Sort Z-A - Sorts the column values in ascending or descending order.

      LIST OF KEYWORDS

      Following is a list of keywords that can NOT be used to create Table or Column names in the EdgeReady DB.
      keyword list.png

      Exceptions:

      These are the words which are disallowed by ANSI SQL but allowed by MySQL as column or table names:

      1. ACTION
      2. BIT
      3. DATE
      4. ENUM
      5. NO
      6. TEXT
      7. TIME
      8. TIMESTAMP

      Was this article helpful?
      What's Next
      ESC

      Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses