CREATE TABLE [dbo].[HARUSERCONTACT]
(
[FORMOBJID] [int] NOT NULL,
[CONTACTEXTENSION] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ZIP] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTACTPHONE] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATE] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CITY] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTACTFAX] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTACTNAME] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONTACTTITLE] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COUNTRY] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[POSITION] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MAILSTOP] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORGANIZATION] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ADDRESS] [varchar] (257) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERCONTACT] ADD CONSTRAINT [HARUSERCONTACT_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERCONTACT] ADD CONSTRAINT [HARUSERCONTACT_FORMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSERCONTACT table stores the information for user contacts.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'ADDRESS'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CITY'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CONTACTEXTENSION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CONTACTFAX'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CONTACTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CONTACTPHONE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'CONTACTTITLE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'COUNTRY'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'MAILSTOP'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'ORGANIZATION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'POSITION'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'STATE'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined form field', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERCONTACT', 'COLUMN', N'ZIP'
GO