Create a data table

Create a table to store the data for your application.

시작하기 전에

Role required: admin, sn_app_eng_studio.user, or delegated developer

이 태스크 정보

The first phase in building the data model for the employee travel request application is to create a table. In our tutorial, we create a blank table that extends the Task table.

Phase 1		Create a data table
Phase 2		Configure a data table
Phase 3		Share data between tables

This procedure covers the first part of the task demonstrated in the tutorial video. The rest of the procedure is outlined in the next topic Configure a data table.

Follow along to create a table for the employee travel request application.

표 1. Video sections

Timestamp	Section
0:10	Create a data table.
0:14	Create a table by extending the Task table.
0:21	Define table properties.
0:33	Add permissions to your table.

프로시저

1. Navigate to All > App Engine > App Engine Studio.
2. Select the travel request application.
3. On the application dashboard, select + Add next to Data.
4. Select Create a blank table.
   A blank table enables you to create the fields, rows, and columns in your table from scratch. You can import existing data, such as spreadsheets or PDFs, to create the table for your application.
5. Select Continue.
6. Select Create from an extensible table.
   Extensible tables are tables with built-in capabilities and functionality that you can use to create new tables. If you don't want to create a table from an extensible table, you can create a table from scratch by selecting Create new table.
7. Select Task from the Table list.
   

   The Task table is one of the commonly extended tables in the ServiceNow AI Platform. The Task table includes built-in functionality for approvals and assignments, which we need for the table in our tutorial application.

8. Select Continue.
9. Define the properties of your new table.
   We define the following properties for the table in our tutorial:

   표 2. Table properties

   Field	Description	Tutorial table properties
   Table label	Unique label to identify the table.	Travel request
   Table name	Database name for the table. Auto-populates based on the Table label that you provided.	No action needed
   Table name prefix	Database prefix for the table. Auto-populates based on the application that you created the table in.	No action needed
   Make extensible	Option to enable other tables to share data from this table. For more information, see Table extension.	No action needed
   Auto-number	Option to track table records with a unique number.	Select the check mark
   Prefix	Abbreviated name of the table to append to the beginning of record numbers.	TRA
   Starting number	Number to identify the first record created for your table.	No action needed
   Number of digits	Maximum number of digits for the record number.	No action needed

10. Select Continue.
11. Control who has access to content in the table by adding permissions to each existing role, or creating new roles.
    주:

    At least one role must have read access for you to be able to preview the table.
    In our tutorial, we grant the following permissions to the admin and user roles.

    Role	Permissions
    Admin	All
    User	Create Read

12. Select Continue to add the roles to your new table.
13. Select Edit table to continue setting up your new table.

결과

You have created a table for your application.

다음에 수행할 작업

Complete the setup of your table by proceeding to the next phase: Configure a data table