My Notes

  https://app.apidog.com/main/APIHub

USE [JMC] GO /****** Object:  Table [dbo].[batch]    Script Date: 08-06-2024 14:47:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[batch]( [batch_id] [uniqueidentifier] NOT NULL, [batch_name] [nvarchar](50) NOT NULL,  CONSTRAINT [PK_batch] PRIMARY KEY CLUSTERED  ( [batch_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 /****** Object:  Table [dbo].[class]    Script Date: 08-06-2024 14:47:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[class]( [class_id] [uniqueidentifier] NOT NULL, [class_of_date] [date] NOT NULL, [class_start_time] [datetime] NOT NULL, [class_end_time] [datetime] NOT NULL, [batch_id] [uniqueidentifier] NULL, [department_id] [uniqueidentifier] NULL, [class_topic] [nvarchar](250) NULL, [anDeviceID] [nume...