Tables [dbo].[al_form_override_def]
Properties
PropertyValue
Row Count9
Created10:33:03 PM Thursday, February 10, 2011
Last Modified10:34:38 PM Thursday, February 10, 2011
Columns
NameData TypeCollationMax Length (Bytes)Allow NullsDefault
Cluster Primary Key al_form_override_def_pk01: form_override_id\formlet_name\contact_uuidForeign Keys AL_FORM_OVERRIDE_DEF_FK01: [dbo].[al_form_def].form_override_idform_override_idint4
No
Cluster Primary Key al_form_override_def_pk01: form_override_id\formlet_name\contact_uuidformlet_namenvarchar(255)SQL_Latin1_General_CP1_CS_AS510
No
Cluster Primary Key al_form_override_def_pk01: form_override_id\formlet_name\contact_uuidForeign Keys AL_FORM_OVERRIDE_DEF_FK03: [dbo].[ca_contact].contact_uuidcontact_uuidbinary(16)16
No
creation_usernvarchar(64)SQL_Latin1_General_CP1_CI_AS128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)SQL_Latin1_General_CP1_CI_AS128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0                         ')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key al_form_override_def_pk01: form_override_id\formlet_name\contact_uuidal_form_override_def_pk01form_override_id, formlet_name, contact_uuid
Yes
Foreign Keys Foreign Keys
NameNo CheckColumns
AL_FORM_OVERRIDE_DEF_FK01
Yes
form_override_id->[dbo].[al_form_def].[form_id]
AL_FORM_OVERRIDE_DEF_FK03contact_uuid->[dbo].[ca_contact].[contact_uuid]
SQL Script
CREATE TABLE [dbo].[al_form_override_def]
(
[form_override_id] [int] NOT NULL,
[formlet_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[contact_uuid] [binary] (16) 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 CONSTRAINT [DF__AL_FORM_O__VERSI__4924D839] DEFAULT ('0                         ')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_form_override_def] ADD CONSTRAINT [al_form_override_def_pk01] PRIMARY KEY CLUSTERED ([form_override_id], [formlet_name], [contact_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_form_override_def] WITH NOCHECK ADD CONSTRAINT [AL_FORM_OVERRIDE_DEF_FK01] FOREIGN KEY ([form_override_id]) REFERENCES [dbo].[al_form_def] ([form_id])
GO
ALTER TABLE [dbo].[al_form_override_def] ADD CONSTRAINT [AL_FORM_OVERRIDE_DEF_FK03] FOREIGN KEY ([contact_uuid]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO
Uses
Used By