CREATE TABLE [dbo].[dim_dr](

[dr_sk] [bigint] IDENTITY(1,1) NOT NULL,

[dr_nk] [varchar](30) NOT NULL,

[s_sk] [bigint] NULL,

[s_nk] [varchar](30) NULL,

[dr_frdate_hq_sk] [int] NULL,

[dr_frtime_hq_sk] [int] NULL,

[dr_tdate_hq_sk] [int] NULL,

[dr_ttime_hq_sk] [int] NULL,

[dr_frdate_local_sk] [int] NULL,

[dr_frtime_local_sk] [int] NULL,

[dr_tdate_local_sk] [int] NULL,

[dr_ttime_local_sk] [int] NULL,

[dr_frdate_utc_sk] [int] NULL,

[dr_frtime_utc_sk] [int] NULL,

[dr_tdate_utc_sk] [int] NULL,

[dr_ttime_utc_sk] [int] NULL,

[p_dr_id] [int] NULL,

[p_s_id] [int] NULL,

[p_ita_dr_id] [int] NULL,

[p_ita_s_id] [int] NULL,

[e_idfodr] [numeric](28, 12) NULL,

[e_idfos] [numeric](28, 12) NULL,

[c_datetime_hq] [datetime] NULL,

[c_datetime_local] [datetime] NULL,

[c_datetime_utc] [datetime] NULL,

[dr_decimal] [decimal](28, 12) NULL,

[dr_numerator] [int] NULL,

[dr_denominator] [numeric](9, 0) NULL,

[dr_fraction] [varchar](20) NULL,

[ibr_dr_flag] [bit] NULL,

[dr_frdatetime_hq] [datetime] NULL,

[dr_frdatetime_local] [datetime] NULL,

[dr_frdatetime_utc] [datetime] NULL,

[dr_tdatetime_hq] [datetime] NULL,

[dr_tdatetime_local] [datetime] NULL,

[dr_tdatetime_utc] [datetime] NULL,

[current_dr_flag] [bit] NULL,

[inferred_m_flag] [bit] NULL,

[inserted_exec_log_key] [bigint] NULL,

[updated_exec_log_key] [bigint] NULL,

CONSTRAINT [PK_dim_dr] PRIMARY KEY CLUSTERED

(

[dr_sk] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [DIM_dr]

) ON [DIM_dr]

GO

SET ANSI_PADDING ON

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frdate_hq_sk_dim_d] FOREIGN KEY([dr_frdate_hq_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frdate_hq_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frdate_local_sk_dim_d] FOREIGN KEY([dr_frdate_local_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frdate_local_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frdate_utc_sk_dim_d] FOREIGN KEY([dr_frdate_utc_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frdate_utc_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frtime_hq_sk_dim_t] FOREIGN KEY([dr_frtime_hq_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frtime_hq_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frtime_local_sk_dim_t] FOREIGN KEY([dr_frtime_local_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frtime_local_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_frtime_utc_sk_dim_t] FOREIGN KEY([dr_frtime_utc_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_frtime_utc_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_tdate_hq_sk_dim_d] FOREIGN KEY([dr_tdate_hq_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_tdate_hq_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_tdate_local_sk_dim_d] FOREIGN KEY([dr_tdate_local_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_tdate_local_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_tdate_utc_sk_dim_d] FOREIGN KEY([dr_tdate_utc_sk])

REFERENCES [dbo].[dim_d] ([d_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_tdate_utc_sk_dim_d]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_ttime_hq_sk_dim_t] FOREIGN KEY([dr_ttime_hq_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_ttime_hq_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_ttime_local_sk_dim_t] FOREIGN KEY([dr_ttime_local_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_ttime_local_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_dr_ttime_utc_sk_dim_t] FOREIGN KEY([dr_ttime_utc_sk])

REFERENCES [dbo].[dim_t] ([t_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_dr_ttime_utc_sk_dim_t]

GO

ALTER TABLE [dbo].[dim_dr] WITH NOCHECK ADD CONSTRAINT [FK_dim_dr_s_sk_dim_s] FOREIGN KEY([s_sk])

REFERENCES [dbo].[dim_s] ([s_sk])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[dim_dr] NOCHECK CONSTRAINT [FK_dim_dr_s_sk_dim_s]

GO

CREATE NONCLUSTERED INDEX [IX_dim_dr_dr_nk] ON [dbo].[dim_dr]

(

[dr_nk] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [DIM_DR]

GO

CREATE NONCLUSTERED INDEX [IX_dim_dr_s_nk] ON [dbo].[dim_dr]

(

[s_nk] ASC,

[dr_frdatetime_hq] ASC,

[dr_tdatetime_hq] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [DIM_DR]

GO

CREATE NONCLUSTERED INDEX [IX_dim_dr_s_sk] ON [dbo].[dim_dr]

(

[s_sk] ASC,

[dr_frdatetime_hq] ASC,

[dr_tdatetime_hq] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [DIM_DR]

GO