[dbo].[aud_ca_location]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	3
Created	10:36:44 PM Thursday, February 10, 2011
Last Modified	10:37:16 PM Thursday, February 10, 2011

Name	Data Type	Max Length (Bytes)	Identity
location_uuid	binary(16)	16
location_name	nvarchar(100)	200
inactive	int	4
pri_phone_number	nvarchar(40)	80
fax_number	nvarchar(40)	80
address_1	nvarchar(50)	100
address_2	nvarchar(50)	100
mail_address_1	nvarchar(50)	100
mail_address_2	nvarchar(50)	100
mail_address_3	nvarchar(50)	100
city	nvarchar(50)	100
state	int	4
address_3	nvarchar(50)	100
mail_address_6	nvarchar(50)	100
mail_address_5	nvarchar(50)	100
mail_address_4	nvarchar(50)	100
address_6	nvarchar(50)	100
address_5	nvarchar(50)	100
address_4	nvarchar(50)	100
primary_contact_uuid	binary(16)	16
zip	nvarchar(20)	40
country	int	4
county	nvarchar(50)	100
geo_coord_type	int	4
geo_coords	nvarchar(40)	80
contact_address_flag	int	4
creation_user	nvarchar(64)	128
site_id	int	4
creation_date	int	4
comments	nvarchar(255)	510
last_update_user	nvarchar(64)	128
last_update_date	int	4
version_number	int	4
exclude_registration	int	4
delete_time	int	4
location_type_id	int	4
parent_location_uuid	binary(16)	16
organization_uuid	binary(16)	16
tenant	binary(16)	16
region_id	int	4
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_location_PK	audit_trail_id

SQL Script

CREATE TABLE [dbo].[aud_ca_location]
(
[location_uuid] [binary] (16) NOT NULL,
[location_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[inactive] [int] NOT NULL,
[pri_phone_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fax_number] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[state] [int] NULL,
[address_3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_6] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_5] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[mail_address_4] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address_6] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address_5] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address_4] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[primary_contact_uuid] [binary] (16) NULL,
[zip] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[country] [int] NULL,
[county] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[geo_coord_type] [int] NULL,
[geo_coords] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_address_flag] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[site_id] [int] NULL,
[creation_date] [int] NULL,
[comments] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL,
[exclude_registration] [int] NULL,
[delete_time] [int] NULL,
[location_type_id] [int] NULL,
[parent_location_uuid] [binary] (16) NULL,
[organization_uuid] [binary] (16) NULL,
[tenant] [binary] (16) NULL,
[region_id] [int] 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_location] ADD CONSTRAINT [aud_ca_location_PK] PRIMARY KEY CLUSTERED ([audit_trail_id]) ON [PRIMARY]
GO