text: -- DBO.[COVERAGETYPE] (BEGIN) 
  
  /* 
  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_NAME = 'CoverageType')  AND (TABLE_SCHEMA = 'dbo'))
    DROP TABLE dbo.[CoverageType]
  GO 
  */ 
  
  
  CREATE TABLE dbo.[CoverageType] (
      CoverageTypeId                                                            BIGINT  NOT NULL    IDENTITY (1000000000, 1),
      CoverageTypeName                                                         VARCHAR (0060) NOT NULL,
  
      HipaaCode                                                                VARCHAR (0003) NOT NULL    CONSTRAINT [CoverageType_Dft_HipaaCode] DEFAULT (''),
  
      CreateAuthorityName                                                      VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_CreateAuthorityName] DEFAULT ('SQL Server'),
      CreateAccountId                                                          VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_CreateAccountId] DEFAULT (CAST (ISNULL (SUSER_ID (), SUSER_NAME ()) AS VARCHAR (060))),
      CreateAccountName                                                        VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_CreateAccountName] DEFAULT (CAST (SUSER_NAME () AS VARCHAR (060))),
      CreateDate                                                              DATETIME  NOT NULL    CONSTRAINT [CoverageType_Dft_CreateDate] DEFAULT (GETDATE ()),
  
      ModifiedAuthorityName                                                    VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_ModifiedAuthorityName] DEFAULT ('SQL Server'),
      ModifiedAccountId                                                        VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_ModifiedAccountId] DEFAULT (CAST (ISNULL (SUSER_ID (), SUSER_NAME ()) AS VARCHAR (060))),
      ModifiedAccountName                                                      VARCHAR (0060) NOT NULL    CONSTRAINT [CoverageType_Dft_ModifiedAccountName] DEFAULT (CAST (SUSER_NAME () AS VARCHAR (060))),
      ModifiedDate                                                            DATETIME  NOT NULL    CONSTRAINT [CoverageType_Dft_ModifiedDate] DEFAULT (GETDATE ())
  
    , CONSTRAINT [CoverageType_Pk] PRIMARY KEY (CoverageTypeId)
  
    , CONSTRAINT [CoverageType_Unq_CoverageTypeName] UNIQUE (CoverageTypeName)
  
    ) -- dbo.CoverageType
  
  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'CoverageType', @level2type=N'COLUMN', @level2name=N'CoverageTypeId'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'CoverageType', @level2type=N'COLUMN', @level2name=N'CoverageTypeName'
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'HIPAA Complaint Code 2/3', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'CoverageType', @level2type=N'COLUMN', @level2name=N'HipaaCode'
    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'CoverageType', @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'CoverageType', @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'CoverageType', @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'CoverageType', @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'CoverageType', @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'CoverageType', @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'CoverageType', @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'CoverageType', @level2type=N'COLUMN', @level2name=N'ModifiedDate'
  
  GO
  */ 
  
  -- DBO.COVERAGETYPE ( END ) 
  
  
  