year_calendar_subsidiary_mapping.sql 299 B

1234567891011
  1. CREATE TABLE [dbo].[year_calendar_subsidiary_mapping] (
  2. [subsidiary] [int] NOT NULL,
  3. [year] [int] NOT NULL,
  4. [calendar_id] [int] NULL,
  5. [client_db] [varchar](20) NOT NULL
  6. ,CONSTRAINT [year_calendar_subsidiary_mapping$0] PRIMARY KEY CLUSTERED ([subsidiary], [year], [client_db])
  7. )
  8. GO