Untitled
unknown
plain_text
a year ago
2.2 kB
4
Indexable
CREATE TABLE [dbo].[SCH_Class_Closed_Hour]( [id] [int] IDENTITY(1,1) NOT NULL, [classId] [int] NOT NULL, [scheduleDayHourId] [int] NOT NULL, [createdDate] [datetime] NOT NULL, [updatedDate] [datetime] NOT NULL, [createdUserId] [int] NOT NULL, [updatedUserId] [int] NOT NULL, CONSTRAINT [PK_SCH_Class_Closed_Hour] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SCH_Class_Closed_Hour] WITH CHECK ADD CONSTRAINT [FK__SCH_Class__class__0662F0A3] FOREIGN KEY([classId]) REFERENCES [dbo].[CMP_Class] ([id]) GO ALTER TABLE [dbo].[SCH_Class_Closed_Hour] CHECK CONSTRAINT [FK__SCH_Class__class__0662F0A3] GO ALTER TABLE [dbo].[SCH_Class_Closed_Hour] WITH CHECK ADD CONSTRAINT [FK__SCH_Class__sched__075714DC] FOREIGN KEY([scheduleDayHourId]) REFERENCES [dbo].[SCH_Schedule_Day_Hour] ([id]) GO ALTER TABLE [dbo].[SCH_Class_Closed_Hour] CHECK CONSTRAINT [FK__SCH_Class__sched__075714DC] GO CREATE TABLE [dbo].[SCH_Class_Closed_Day]( [id] [int] IDENTITY(1,1) NOT NULL, [classId] [int] NOT NULL, [scheduleDayId] [int] NOT NULL, [createdDate] [datetime] NOT NULL, [updatedDate] [datetime] NOT NULL, [createdUserId] [int] NOT NULL, [updatedUserId] [int] NOT NULL, CONSTRAINT [PK_SCH_Class_Closed_Day] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SCH_Class_Closed_Day] WITH CHECK ADD CONSTRAINT [FK__SCH_Class__class__02925FBF] FOREIGN KEY([classId]) REFERENCES [dbo].[CMP_Class] ([id]) GO ALTER TABLE [dbo].[SCH_Class_Closed_Day] CHECK CONSTRAINT [FK__SCH_Class__class__02925FBF] GO ALTER TABLE [dbo].[SCH_Class_Closed_Day] WITH CHECK ADD CONSTRAINT [FK__SCH_Class__sched__038683F8] FOREIGN KEY([scheduleDayId]) REFERENCES [dbo].[SCH_Schedule_Day] ([id]) GO ALTER TABLE [dbo].[SCH_Class_Closed_Day] CHECK CONSTRAINT [FK__SCH_Class__sched__038683F8] GO
Editor is loading...
Leave a Comment