Table management

PermeAgility allows you to create tables and relationships between tables.  To create a table, use the New table.. link in the Schema manager.

  Enter the name of the table you want to create. 

The table name you enter will be converted into a camel case identifier so:

    My Table becomes myTable

    Student Course Request becomes studentCourseRequest

    WORK_TABLE becomes workTable

On presentation if there is no locale specific translation for TABLE_studentCourseRequest, then it will be displayed as Student Course Request

The table name must not have spaces and can be a mixture of upper and lower case characters. They will be removed when converting to camelCase..  To keep your tables organized, it is a good idea to use a standardized naming convention for your table names.  The PermeAgility configuration tables use the following naming convention for tables:

• • <Name> for tables that define objects or configuration items

  • <Name1><Name2> for tables that link other tables together

• <Name>Request for tables that are requests to create transactions or other objects. Typically a request is handled by an approval process (coming soon).

When a table is created, it will automatically have an internal column for a primary key and a name column of type text.  The name column is added by default as it is the standard column name the framework will look for when creating pick lists and descriptions when tables are related.

Adding columns

To add columns to the table, click the +Column.. option to popup the option dialog for adding a new column.  

Select the data type, and enter the column name (column name will be processed into camelCase similar to table names.  If a link type is selected (Link, Link set, Link list, Link map), you will also need to select the table the link will point to.

For more information on the available data types, see Data Types

Click the button to add the column to the table. The new column will be added.

You can now click on the row to edit the data in the row. A form will automatically be created to allow you to edit the row.

For information on how to use reference columns, see Reference columns

Table rights

The Rights.. popup allows you to view, revoke, and add privileges to the table.

The existing rights for a table are shown at the top of the popup.   Rights can only be added be added for a role. Rights include: NONE,  CREATE, READ, UPDATE, DELETE, or ALL.

Advanced table options

The Advanced.. popup form in the table management screen allow the user to modify tables:

In this popup, you can rename the table, rename columns, drop columns, truncate the data (delete all the rows), and drop/delete the table.

Table column order

OrientDB does not have a specific order for columns so they naturally come out in alphabetical order using the column name.  PermeAgility uses the columns table to specify the order of the columns in table and form presentations.  Open the Columns table editor to change columns.

As columns are added to tables, they will dynamically show up in forms and tables even if not listed unless explicitly removed using a minus sign (-) in front of the column name or if dynamic columns are disabled by adding a column to the list called - ( a single minus sign)

Security upgrade option

If you add role based security by row for this table, then columns can be specified by role.  If the user can read the columns record, then that is the way they will see the table.

To upgrade the columns table to enable role based table views, go to the query tool and paste this:

ALTER CLASS columns SUPERCLASS ORestricted

(future versions will let you do this from the Advanced table options...)

Note: After setting the superclass to ORestricted, one of the _allow, _allowRead, _allowUpdate, _allowDelete columns may need to be set to allow other users to see them