Track-It! data model

The Track-It! database contains standard tables and columns for each module. Each table has a corresponding view definition created for each group. The data model tool shows you various modules and the corresponding field definitions.

To download the Track-It! data model zip file, click here.

To view the data model

1. After you download the data model zip file, save it to a new folder.
2. Extract the files.
   If the files are not extracted, the HTML model does not launch correctly.
3. To view the HTML model, launch the Index.htm file.
   The Index.htm fetches the different pages in the main page from the underlying folders. The HTML first shows modules like Ticket and Assignment followed by all the configuration modules and the table definitions.
4. To view module specific schema details, such as Table and View names, click on the respective module link.

To view the data model via Internet Information Services (IIS) Manager

Follow this procedure only if you want to access the data model by using the Chrome or Mozilla Firefox browser.

1. After you download the data model zip file, save it to a new folder.
2. Extract the files to any location on your server.

3. On the same server, launch the IIS manager by selecting Control Panel > System and Security > Administrative Tools > IIS Manager.

4. In the IIS Manager, click Expand Sites and then click Default Web Site.

5. Right-click Default Web Site and then click Add Application.

6. In the Edit Application dialog box, enter the application name and the physical path of the extracted file.
7. To view the HTML model, launch the URL http://serverName/applicationName/index.html on any browser, where serverName is the server on which you have launched the IIS Manager and applicationName is the name of the application that you entered in step 6.

To query and fetch data from a specific module

All the user modules have a base table and a base view that are owned by _SMDBA_ schema. If you are querying the database to fetch data for consumption by external applications, you must query the Base Views owned by _SMDBA_.

For example,

Module = Ticket
Base View Name = Ticket
Base Table Name = _TELMASTE_

Query example:

SELECT *.* FROM [_SMDBA_].[Ticket]
WHERE <conditions>
ORDER BY <field name>