C11/System/LOCOSOFT/SQL/schema/GC/tables/data.GC_Kalender.sql

CREATE TABLE [data].[GC_Kalender] (
   [Datum] [date] NOT NULL,
   [Feiertag_Name] [varchar](30) NULL,
   [Wochentag_ID] [smallint] NOT NULL,
   [Wochentag_kurz] [varchar](5) NOT NULL,
   [Bundesland_Kuerzel] [varchar](5) NOT NULL,
   [Feiertag] [smallint] NOT NULL,
   [MoFr] [smallint] NOT NULL,
   [Vortag_MoFr] [date] NOT NULL,
   [Monat_MoFr] [smallint] NOT NULL,
   [Jahr_MoFr] [smallint] NULL,
   [MoSa] [smallint] NOT NULL,
   [Vortag_MoSa] [date] NOT NULL,
   [Monat_MoSa] [smallint] NULL,
   [Jahr_MoSa] [smallint] NULL
)


GO