Data Schemas
Throughout this book, I have referred to tables from the Help Desk sample application. In Chapter 2, I described the main tables and relationships in the application. This appendix summarizes the remaining tables that belong in this application.
Help Desk Tables
Here are the tables found in the Intrinsic database, organized in alphabetical order.
External Tables
In Chapter 6, I showed you how to insert records into an external SQL Server database. Here’s the schema and create script (Listing E-1) for the AuditDetail table.
Listing E-1. SQL create script for AuditDetail table
Database Diagram
The following diagram shows the tables and relationships in the Intrinsic database after you deploy your application.