CREATE TABLE [STM].[CONTACT](
	[TABLE_ID] [dbo].[UDDT_TABLEID] ROWGUIDCOL  NOT NULL,
	[TITLE] [dbo].[UDDT_MVARCHAR] NULL,
	[SALUTATION] [dbo].[UDDT_MVARCHAR] NULL,
	[LAST_NAME] [dbo].[UDDT_MVARCHAR] NULL,
	[FIRST_NAME] [dbo].[UDDT_MVARCHAR] NULL,
	[BIRTHDAY] [datetime] NULL,
	[MARITAL_STATUS] [int] NOT NULL,
	[CITIZENSHIP] [dbo].[UDDT_SVARCHAR] NULL,
	[ID_COMPANY] [uniqueidentifier] NULL,
	[FIELD1] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD2] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD3] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD4] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD5] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD6] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD7] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD8] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD9] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD10] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD11] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD12] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD13] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD14] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD15] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD16] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD17] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD18] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD19] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD20] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD21] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD22] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD23] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD24] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD25] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD26] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD27] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD28] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD29] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD30] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD31] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD32] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD33] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD34] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD35] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD36] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD37] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD38] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD39] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD40] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD41] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD42] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD43] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD44] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD45] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD46] [dbo].[UDDT_XLVARCHAR] NULL,
	[FIELD47] [dbo].[UDDT_XLVARCHAR] NULL,
	[FIELD48] [dbo].[UDDT_XLVARCHAR] NULL,
	[FIELD49] [dbo].[UDDT_XLVARCHAR] NULL,
	[FIELD50] [dbo].[UDDT_XLVARCHAR] NULL,
	[PHOTO] [varbinary](max) FILESTREAM  NULL,
	[ROW_VERSION] [timestamp] NOT NULL,
	[STATUS] [int] NOT NULL,
	[STATUS_INFO] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD51] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD52] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD53] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD54] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD55] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD56] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD57] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD58] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD59] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD60] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD61] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD62] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD63] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD64] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD65] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD66] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD67] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD68] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD69] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD70] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD71] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD72] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD73] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD74] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD75] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD76] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD77] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD78] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD79] [dbo].[UDDT_MVARCHAR] NULL,
	[FIELD80] [dbo].[UDDT_MVARCHAR] NULL,
	[ID_MAIN_COMPANY] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_CONTACT] PRIMARY KEY NONCLUSTERED 
(
	[TABLE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] FILESTREAM_ON [MEDICONNECT2_Files]
GO

ALTER TABLE [STM].[CONTACT] ADD  DEFAULT ('00000000-0000-0000-0000-000000000000') FOR [ID_MAIN_COMPANY]
GO