{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":1507,"path":"application-development/app-engine-studio/add-data.md","title":"Create a data model for your application","bundle":null,"doc_type":null,"release":"australia","body":"\n# Create a data model for your application\n\nCreate a data model in App Engine Studio \\(AES\\) for your application by creating the tables that will house your application data. Create data tables that will be used in your application by creating the table from scratch, uploading a spreadsheetor PDF, or by using an existing table as a template. You can also create and schedule data imports by mapping a spreadsheet to an existing table in your application.\n\nCreating a data model and populating data into user interfaces are crucial starting points for any new application. Users may provide data, such as their name and phone number, when they fill in a form, and other users may refer to data as they fulfill a request.\n\nIn App Engine Studio, application data is stored in table format. When users update application data, they create a row or change an existing row in the table \\(each row is also known as a data record\\). You can create tables from existing ServiceNow AI Platform tables, from a spreadsheetor PDF, or customize a completely new table for your application to store records in.\n\nThe data records stored in your application may come from several sources. One table might store data records entered by users who are using your application, another might be populated via the import and mapping of data from a spreadsheet or through a script that updates data records with data from another ServiceNow AI Platform table.\n\n## Application templates and data\n\nApplication templates automatically add data to your application. If you use a template to create your application, you can edit the tables that were added or add different tables.\n\n## Forms\n\nWhen you add data to your app, any associated form views display in the **Experience** section of your app. To edit the form, select it in the **Experience** section. Form views can be edited in the **Forms** tab of Table Builder. For more information, see [Forms in Table Builder](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/form-builder-glide-family-release/form-view-configuration.md).\n\n## Table extension\n\nThere are several tables that your organization may already be using in other applications. For example, your organization may be using the Configuration item \\[cmdb\\_ci\\] table for an application that houses configuration data. You can create a table for your application by extending any of these existing tables.\n\nTable extension allows a table to share fields and records with a parent table. You might extend a table if you expect users to fill in similar fields across different form views in an application. For example, to create a ticketing type of table, you might extend the Task \\[task\\] table. The Task table includes fields that are standard for most work tickets, such as **Number** and **Assigned to**.\n\nMany organizations create extensible standardized tables for their citizen developers to use when designing their apps. This enables the developers to standardize the way data is utilized across multiple applications within the organization.\n\nTo make a table in your application extensible, select **Make extensible** during table creation. After extending an existing table, you can further customize the new table by adding more columns.\n\nThe following table provides a list of commonly extended tables in the ServiceNow AI Platform. For more information on commonly extended tables and models for extension, see [Table extension and classes](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-administration/table-extension-and-classes.md).\n\n\n
\n\nTable\n\n\n\nShort Description\n\n\n\nDescription\n\n
\n\ntask\n\n\n\nTask\n\n\n\nStores fields for the core applications such as Incident, Problem, and Change Management. It provides a series of standard fields used on each of the tables that extend it. Any table which extends the task table can take advantage of task-specific functionality for driving tasks.\n\n
\n\ncmdb\\_ci\n\n\n\nConfiguration Item\n\n\n\nStores configuration items. This table can be extended for configuration items such as hardware, services, etc.\n\n
\n\nsn\\_customerservice\n\n \\_case\n\n\n\nCustomer Service Case\n\n\n\nStores customer service case records.\n\n
\n\nsm\\_order\n\n\n\nService Order\n\n\n\nStores data that defines and manages work that needs to be performed.\n\n
\n\nsm\\_task\n\n\n\nService Task\n\n\n\nStores units of work performed by one person in one session \\(one location, one time\\).\n\n
\n\nplanned\\_task\n\n\n\nPlanned Task\n\n\n\nStores additional fields for tasks pertaining to time and effort as part of a planned, multi-stage process.\n\n
\n\ncmn\\_location\n\n\n\nLocation\n\n\n\nStores location information.\n\n
\n\ncmdb\\_serviceorder\n\n \\_product\\_model\n\n\n\nService Order Model\n\n\n\nStores service order templates.\n\n
\n\ncmdb\\_servicetask\n\n \\_product\\_mode\n\n\n\nService Task Model\n\n\n\nStores service task templates.\n\n
\n\ncmdb\\_qb\\_result\n\n \\_base\n\n\n\nQuery Results\n\n\n\nStores query results created by the CMDB Query Builder.\n\n
\n\nalm\\_asset\n\n\n\nAsset\n\n\n\nStores general, financial, and contractual information about assets.\n\n
\n\ncmdb\\_ci\\_service\n\n\n\nBusiness Service\n\n\n\nStores IT Services data that directly supports a business process.\n\n
\n\nsys\\_user\n\n\n\nUser\n\n\n\nStores user data. The User table provides a list of all system users and their related department.\n\n
\n\nsys\\_user\\_group\n\n\n\nUser Group\n\n\n\nStores and groups a set of users who share a common purpose. Groups may perform tasks such as approving change requests, resolving incidents, receiving email notifications, or performing work order tasks.\n\n
\n\ncore\\_company\n\n\n\nCompany\n\n\n\nStores company information.\n\n
\n\ncmn\\_schedule\n\n\n\nSchedule\n\n\n\nStores records that specify a time zone and a type of schedule and use one or more schedule entries.\n\n
\n\ncmn\\_department\n\n\n\nDepartment\n\n\n\nStores a list of all departments and their related business unit.\n\n
\n\ncmn\\_cost\\_center\n\n\n\nCost Center\n\n\n\nStores cost center records. This is a reference between financial systems and IT. Cost center records represent business entities, and have a related list of CI Cost Center Relationships that measure the cost center's consumption of business services.\n\n
\n\ncmdb\\_model\n\n\n\nProduct Model\n\n\n\nSpecific versions or various configurations of an asset. Models are used for managing and tracking assets through various ServiceNow platform asset applications, including Product Catalog, Asset Management, and Procurement.\n\n
\n\nlife\\_cycle\\_stage\n\n\n\nLife Cycle Stage\n\n\n\nStores standard fields and values for tracking life cycle stages for CIs. Using these standard values consistently across applications helps to effectively track assets through their life cycle transitions.\n\n
\n\nlife\\_cycle\\_stage\n\n \\_status\n\n\n\nLife Cycle Status\n\n\n\nStores standard fields and values for tracking life cycle stage status for CIs. Using these standard values consistently across applications helps to effectively track assets through their life cycle transitions.\n\n
\n\nincident\n\n\n\nIncident\n\n\n\nStores deviations from an expected standard of operation.\n\n
\n\nsysapproval\n\n\n\nApproval\n\n\n\nStores data that allows you to require authorization on tasks before the work is done. You can define approvals for all tasks and associate users or groups to a task to approve or reject them.\n\n
Use the methods listed below to create a data model and add data to your application.\n\n- **[Create a blank table](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/use-existing-table.md)** \nAdd a data table to your application from an existing table that you or someone else previously created or from scratch.\n- **[Use a spreadsheet to add data](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/upload-multi-sheets.md)** \nAdd data tables and records to your application by uploading a Microsoft Excel spreadsheet.\n- **[Use a PDF to create data tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/pdf-extractor.md)** \nCreate tables from a PDF form using the PDF extractor tool in App Engine Studio.\n- **[Create a data integration](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/import-map-data-existing-table.md)** \nAdd new or updated information to your current data sets by importing it into existing tables in your application through the power of Integration Hub. Schedule future imports to add data at specific times.\n- **[Modify application data tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/edit-data.md)** \nUse Table Builder to modify data tables used in your application.\n\n**Parent Topic:**[Enhance your app](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/application-development/app-engine-studio/customize-application.md)\n\n"}}