CREATE TABLE [dbo].[PRTimecardDays]
(
[DayID] [int] NOT NULL IDENTITY(1, 1),
[Day] [datetime] NOT NULL,
[TimecardID] [int] NOT NULL,
[NormalHours] [decimal] (14, 4) NOT NULL,
[NonPayHours] [decimal] (14, 4) NOT NULL,
[Gaps] [int] NOT NULL,
[Conflicts] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PRTimecardDays] ADD CONSTRAINT [PK__PRTimeca__BF3DD82581609FE2] PRIMARY KEY CLUSTERED ([DayID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PRTimecardDays] ADD CONSTRAINT [FK_PRTimecardDays_TimecardID_PRPayPeriodTimeCards] FOREIGN KEY ([TimecardID]) REFERENCES [dbo].[PRPayPeriodTimecards] ([TimeCardID])
GO