[dbo].[aud_ca_contact]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	227
Created	10:36:43 PM Thursday, February 10, 2011
Last Modified	10:37:15 PM Thursday, February 10, 2011

Name	Data Type	Max Length (Bytes)	Identity
contact_uuid	binary(16)	16
middle_name	nvarchar(100)	200
alias	nvarchar(30)	60
last_name	nvarchar(100)	200
first_name	nvarchar(100)	200
pri_phone_number	nvarchar(40)	80
alt_phone_number	nvarchar(40)	80
fax_number	nvarchar(40)	80
mobile_phone_number	nvarchar(40)	80
pager_number	nvarchar(40)	80
email_address	nvarchar(120)	240
location_uuid	binary(16)	16
floor_location	nvarchar(30)	60
pager_email_address	nvarchar(120)	240
room_location	nvarchar(30)	60
contact_type	int	4
inactive	int	4
creation_user	nvarchar(64)	128
creation_date	int	4
last_update_user	nvarchar(64)	128
last_update_date	int	4
version_number	int	4
department	int	4
comments	nvarchar(255)	510
company_uuid	binary(16)	16
organization_uuid	binary(16)	16
admin_organization_uuid	binary(16)	16
alternate_identifier	nvarchar(30)	60
job_title	int	4
job_function	int	4
mail_stop	nvarchar(30)	60
cost_center	int	4
userid	nvarchar(100)	200
supervisor_contact_uuid	binary(16)	16
exclude_registration	int	4
delete_time	int	4
inrdid	int	4
tenant	binary(16)	16
tenant_group	binary(16)	16
audit_trail_id	bigint	8	1 - 1
audit_trail_user	nvarchar(64)	128
audit_trail_type	varchar(6)	6
audit_trail_date	int	4
audit_trail_product	varchar(64)	64

	Name	Columns	Unique
	aud_ca_contact_PK	audit_trail_id

SQL Script

CREATE TABLE [dbo].[aud_ca_contact]
(
[contact_uuid] [binary] (16) NOT NULL,
[middle_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[first_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pri_phone_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[alt_phone_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fax_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mobile_phone_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pager_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email_address] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[location_uuid] [binary] (16) NULL,
[floor_location] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pager_email_address] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[room_location] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_type] [int] NULL,
[inactive] [int] NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL,
[department] [int] NULL,
[comments] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[company_uuid] [binary] (16) NULL,
[organization_uuid] [binary] (16) NULL,
[admin_organization_uuid] [binary] (16) NULL,
[alternate_identifier] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[job_title] [int] NULL,
[job_function] [int] NULL,
[mail_stop] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cost_center] [int] NULL,
[userid] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[supervisor_contact_uuid] [binary] (16) NULL,
[exclude_registration] [int] NULL,
[delete_time] [int] NULL,
[inrdid] [int] NULL,
[tenant] [binary] (16) NULL,
[tenant_group] [binary] (16) NULL,
[audit_trail_id] [bigint] NOT NULL IDENTITY(1, 1),
[audit_trail_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[audit_trail_type] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[audit_trail_date] [int] NULL,
[audit_trail_product] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[aud_ca_contact] ADD CONSTRAINT [aud_ca_contact_PK] PRIMARY KEY CLUSTERED ([audit_trail_id]) ON [PRIMARY]
GO