Throughout this book, you’ve seen examples from the HelpDesk sample application. Chapter 2 describes the main tables and relationships that the application uses. This appendix summarizes the remaining tables that belong in this application.

HelpDesk Tables

This section shows you the tables in the Intrinsic database, organized in alphabetical order.

External Tables

Chapter 4 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

CREATE TABLE [dbo].[AuditDetail](
      [AuditID] [int] IDENTITY(1,1) NOT NULL,
      [AuditDesc] [nvarchar](max) NULL,
      [LoginName] [nvarchar](255) NULL,
      [AuditDate] [datetime] NULL,
 CONSTRAINT [PK_AuditDetail] PRIMARY KEY CLUSTERED
(
      [AuditID] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
      ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Database Diagram

The following two diagrams show the relationships between tables in SQL Server after the Intrinsic database has been deployed.