
      -- Tables
      
          /***** Object:  Table [dbo].[T_MO_RECOUPMENT] *****/
          CREATE TABLE [dbo].[T_MO_RECOUPMENT]
          (
	  [Mo] varchar(6) NULL,
                  [MonthValuesID] uniqueidentifier NOT NULL
          ) ON [PRIMARY]
          GO
        
      -- Alters
      
              ALTER TABLE [dbo].[T_MO_RECOUPMENT] WITH NOCHECK ADD CONSTRAINT [PK_T_MO_RECOUPMENT]
              PRIMARY KEY CLUSTERED ([MonthValuesID]) ON [PRIMARY]
              GO
          
                    ALTER TABLE [dbo].[T_MO_RECOUPMENT] ADD [Mo_UQ] AS (CASE WHEN [Mo] IS NOT NULL THEN NULL ELSE [MonthValuesID] END)
                  CREATE UNIQUE NONCLUSTERED INDEX [UQ_T_MO_RECOUPMENT_MO] ON [dbo].[T_MO_RECOUPMENT] ([Mo] ASC, [Mo_UQ] ASC) ON [PRIMARY]
                  GO
              ALTER TABLE [dbo].[T_MO_RECOUPMENT] WITH NOCHECK ADD CONSTRAINT [FK_T_MO_T_MO_RECOUPMENT_MO] FOREIGN KEY([Mo])
              REFERENCES [dbo].[T_MO] ([MCOD])
              GO
              ALTER TABLE [dbo].[T_MO_RECOUPMENT] WITH NOCHECK ADD CONSTRAINT [FK_T_MONTH_VALUES_T_MO_RECOUPMENT_MONTHVALUESID] FOREIGN KEY([MonthValuesID])
              REFERENCES [dbo].[T_MONTH_VALUES] ([MonthValuesID])
              GO