text: -- DBO.[CORRESPONDENCE] (BEGIN) 
  
  /* 
  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_NAME = 'Correspondence')  AND (TABLE_SCHEMA = 'dbo'))
    DROP TABLE dbo.[Correspondence]
  GO 
  */ 
  
  
  CREATE TABLE dbo.[Correspondence] (
      CorrespondenceId                                                          BIGINT  NOT NULL    IDENTITY (1000000000, 1),
      CorrespondenceName                                                       VARCHAR (0060) NOT NULL,
      CorrespondenceDescription                                                VARCHAR (0999) NOT NULL,
      Version                                                                  DECIMAL (20, 8) NOT NULL,
      FormId                                                                    BIGINT  NOT NULL,
  
      StoreImage                                                                   BIT  NOT NULL    CONSTRAINT [Correspondence_Dft_StoreImage] DEFAULT (0),
      HasContent                                                                   BIT  NOT NULL    CONSTRAINT [Correspondence_Dft_HasContent] DEFAULT (0),
  
      ExtendedProperties                                                           XML      NULL,
  
      Enabled                                                                      BIT  NOT NULL    CONSTRAINT [Correspondence_Dft_Enabled] DEFAULT (1),
      Visible                                                                      BIT  NOT NULL    CONSTRAINT [Correspondence_Dft_Visible] DEFAULT (1),
  
      CreateAuthorityName                                                      VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_CreateAuthorityName] DEFAULT ('SQL Server'),
      CreateAccountId                                                          VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_CreateAccountId] DEFAULT (CAST (ISNULL (SUSER_ID (), SUSER_NAME ()) AS VARCHAR (060))),
      CreateAccountName                                                        VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_CreateAccountName] DEFAULT (CAST (SUSER_NAME () AS VARCHAR (060))),
      CreateDate                                                              DATETIME  NOT NULL    CONSTRAINT [Correspondence_Dft_CreateDate] DEFAULT (GETDATE ()),
  
      ModifiedAuthorityName                                                    VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_ModifiedAuthorityName] DEFAULT ('SQL Server'),
      ModifiedAccountId                                                        VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_ModifiedAccountId] DEFAULT (CAST (ISNULL (SUSER_ID (), SUSER_NAME ()) AS VARCHAR (060))),
      ModifiedAccountName                                                      VARCHAR (0060) NOT NULL    CONSTRAINT [Correspondence_Dft_ModifiedAccountName] DEFAULT (CAST (SUSER_NAME () AS VARCHAR (060))),
      ModifiedDate                                                            DATETIME  NOT NULL    CONSTRAINT [Correspondence_Dft_ModifiedDate] DEFAULT (GETDATE ())
  
    , CONSTRAINT [Correspondence_Pk] PRIMARY KEY (CorrespondenceId)
  
    , CONSTRAINT [Correspondence_Unq_CorrespondenceName] UNIQUE (CorrespondenceName)
  
    ) -- dbo.Correspondence
  
  GO
  
  /* 
  -- COLUMN DESCRIPTIONS 
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique Identifier', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CorrespondenceId'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CorrespondenceName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CorrespondenceDescription'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Version [Correspondence Version]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'Version'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique Identifier [Reference to Form Template (for Received)]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'FormId'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True/False Boolean', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'StoreImage'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True/False Boolean', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'HasContent'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ExtendedProperties', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'ExtendedProperties'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enabled/Disabled Toggle', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'Enabled'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Visible/Not Visible Toggle', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'Visible'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name [Security Authority Name]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CreateAuthorityName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique User Account ID', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CreateAccountId'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name [User Account Name]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CreateAccountName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and Time [Create Date]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'CreateDate'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name [Security Authority Name]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'ModifiedAuthorityName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique User Account ID', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'ModifiedAccountId'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name [User Account Name]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'ModifiedAccountName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and Time [Modified Date]', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Correspondence', @level2type=N'COLUMN', @level2name=N'ModifiedDate'
  
  GO
  */ 
  
  -- DBO.CORRESPONDENCE ( END ) 
  
  
  