college2 (Jorhat Medical College & Hospital) Complete Database
1. Tables USE [college2] GO /****** Object: Table [dbo].[temp_unique_class_status] Script Date: 04/29/2024 16:45:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[temp_unique_class_status]( [record_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL, [class_id] [uniqueidentifier] NOT NULL, [class_of_date] [date] NULL, [weekday] [nvarchar](50) NULL, [batch_id] [uniqueidentifier] NULL, [class_start_time] [datetime] NULL, [class_end_time] [datetime] NULL, [class_subject_or_department] [nvarchar](250) NULL, [class_topic] [nvarchar](250) NULL, [enroll_id] [numeric](18, 0) NOT NULL, [uid] [uniqueidentifier] NULL, [session_id] [uniqueidentifier] NULL, [real_svr_Id] [numeric](18, 0) NULL, [astrRemoteIP] [nvarchar](50) NULL, [anDeviceID] [nvarchar](50) NULL, [log_time] [datetime] NULL, [class_status] [nvarchar](50) NULL, CONSTRAINT [PK_temp_unique_class_status] PRIMARY KEY CLUSTERED ( [class_id] ASC, ...