C11/System/ARI/SQL/schema/Kalender/tables/kalender.Konfiguration_Mandant.sql

CREATE TABLE [kalender].[Konfiguration_Mandant] (
   [Hauptbetrieb_ID] [varchar](10) NOT NULL,
   [Standort_ID] [varchar](10) NOT NULL,
   [Bundesland_ID] [int] NOT NULL,
   [Samstag_Arbeitstag] [bit] NOT NULL,
   [GJ_erster_Monat] [int] NOT NULL
      CONSTRAINT [DF_Konfiguration_Mandant_GJ_erster_Monat] DEFAULT ((1))

   ,CONSTRAINT [PK_Konfiguration_Mandant] PRIMARY KEY CLUSTERED ([Hauptbetrieb_ID], [Standort_ID], [Bundesland_ID])
)


GO