Columns
| Column Name
| Definition |
|---|
APP_ID |
- Function:
- The unique ID
for the app.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- Yes
- Foreign Key:
- No
|
APP_NAME |
- Function:
- The internal, technical name of the app associated with the metadata.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
APP_TYPE |
- Function:
- The type of the app.
- Values:
-
- EForms - Process-based app.
- StandaloneForms - Form-based app.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
CO_AUTHORED |
- Function:
- Specifies whether collaborative development is enabled for an app.
- Values:
-
- Yes - Collaborative development is enabled for the app.
- No - Collaborative development is disabled for the app.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_BY |
- Function:
- The user who created the app.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_DATE |
- Function:
- The date the app was created.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
DESCRIPTION |
- Function:
- A free text description for the app.
- Data Type:
- nvarchar
- Size:
- 2048
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DISPLAY_NAME |
- Function:
- The display name for the app.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
IS_AI_GENERATED |
- Function:
- Specifies whether the app is generated with AI.
- Values:
-
- Yes - The app is generated with AI.
- No - The app is not generated with AI.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
APP LOCALE |
- Function:
- The locale for the app.
- Data Type:
- varchar
- Size:
- 16
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
PARENT_APPLICATION_ID |
- Function:
- The process ID (GUID) for the parent process, if the item is a subprocess.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
STATUS |
- Function:
- The status of the app.
- Values:
-
- DRAFT - The app is in development and has not been released.
- RELEASED - The app is published.
- Data Type:
- nvarchar
- Size:
- 64
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
VISIBILITY |
- Function:
- The visibility state of the app.
- Values:
-
- PAAS - Platform as a service.
- SAAS_ONLY - Software as a service.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
ARIA_CONTEXT_ID |
- Function:
- Stores the ARIA context reference ID in GUID format.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
Relationships
| Table Name | Relationship |
|---|
| WF_APP_LABEL | 1:n |
| WF_APPLICATION_FILE | 1:n |
| WF_APPLICATION_FOLDER | 1:n |
