USE SCHEDULE

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORSchedules]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORSchedules](
	[Name] [varchar](100) NULL,
	[ORRoomID] [int] NULL,
	[Surgeon] [varchar](10) NULL,
	[Anesthesiologist] [varchar](4) NULL,
	[ScheduleDate] [datetime] NULL,
	[IDNum] [varchar](10) NULL,
	[HospNum] [varchar](10) NULL,
	[RecordStatus] [varchar](1) NULL CONSTRAINT [DF__tbORSched__Recor__7E02B4CC]  DEFAULT (''),
	[RequestBy] [varchar](30) NULL,
	[RequestDate] [datetime] NULL,
	[Remarks] [text] NULL,
	[TransNum] [int] IDENTITY(1,1) NOT NULL,
	[CNurse] [varchar](50) NULL,
	[SNurse1] [varchar](50) NULL,
	[SNurse2] [varchar](50) NULL,
	[AsstSurgeon1] [varchar](50) NULL,
	[AsstSurgeon2] [varchar](50) NULL,
	[AsstAnesth1] [varchar](50) NULL,
	[ProcedureName] [varchar](500) NULL,
	[RoomID] [varchar](10) NULL,
	[ProcessBy] [varchar](50) NULL,
	[ProcessDate] [datetime] NULL,
	[RevokeBy] [varchar](50) NULL,
	[RevokeDate] [datetime] NULL,
	[AsstDoctorID] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END







GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORApplication]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORApplication](
	[StartTime] [datetime] NULL,
	[DayLength] [int] NULL,
	[ScheduleIncrement] [int] NULL,
	[RoomID] [int] NULL
) ON [PRIMARY]
END







GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORCategory]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORCategory](
	[CategoryId] [int] NOT NULL,
	[CategoryName] [varchar](20) NULL,
	[Color] [int] NULL,
	[SortOrder] [int] NULL
) ON [PRIMARY]
END






GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORRoom]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORRoom](
	[RoomId] [int] NOT NULL,
	[RoomName] [varchar](20) NULL,
	[SortOrder] [int] NULL,
	[RevenueID] [varchar](4) NULL
) ON [PRIMARY]
END






GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORSchedule]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORSchedule](
	[ScheduleId] [int] NOT NULL,
	[ScheduleDate] [datetime] NULL
) ON [PRIMARY]
END







GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbORScheduleDetails]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbORScheduleDetails](
	[ScheduleId] [int] NULL,
	[RowId] [int] NULL,
	[RoomId] [int] NULL,
	[StartTime] [datetime] NULL,
	[Length] [int] NULL,
	[Description] [varchar](500) NULL,
	[ProcedureID] [varchar](8) NULL,
	[DoctorID1] [varchar](10) NULL,
	[DoctorID2] [varchar](10) NULL,
	[CategoryId] [int] NULL,
	[ScheduleDate] [datetime] NULL,
	[IDNum] [varchar](10) NULL,
	[HospNum] [varchar](10) NULL,
	[RecordStatus] [varchar](1) NULL CONSTRAINT [DF_tbORScheduleDetails_RecordStatus]  DEFAULT (''),
	[RequestBy] [varchar](50) NULL,
	[RequestDate] [datetime] NULL,
	[ProcessBy] [varchar](50) NULL,
	[ProcessDate] [datetime] NULL,
	[StationID] [varchar](10) NULL,
	[ResidentDoctor] [varchar](100) NULL,
	[Remarks] [text] NULL,
	[TransNum] [int] IDENTITY(1,1) NOT NULL,
	[CNurse] [varchar](10) NULL,
	[SNurse1] [varchar](100) NULL,
	[SNurse2] [varchar](100) NULL,
	[AsstSurgeon1] [varchar](100) NULL,
	[AsstSurgeon2] [varchar](100) NULL,
	[AsstAnesth1] [varchar](100) NULL,
	[ProcedureName] [varchar](500) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END