Jorhat Medical College My New Plan database

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] [numeric](18, 0) NULL,

[Id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

 CONSTRAINT [PK_class] PRIMARY KEY CLUSTERED 

(

[class_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].[department]    Script Date: 08-06-2024 14:47:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[department](

[department_id] [uniqueidentifier] NOT NULL,

[department_name] [nvarchar](50) NOT NULL,

 CONSTRAINT [PK_department] PRIMARY KEY CLUSTERED 

(

[department_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].[enrollment]    Script Date: 08-06-2024 14:47:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[enrollment](

[id] [uniqueidentifier] NOT NULL,

[enroll_id] [numeric](18, 0) NOT NULL,

[enroll_name] [nvarchar](50) NULL,

[department_id] [uniqueidentifier] NULL,

[department_name] [nvarchar](50) NULL,

[batch_id] [uniqueidentifier] NULL,

[batch_name] [nvarchar](50) NULL,

[session_id] [uniqueidentifier] NULL,

[session_name] [nvarchar](50) NULL,

[roll_no] [numeric](18, 0) NULL,

 CONSTRAINT [PK_temp_enrollment] PRIMARY KEY CLUSTERED 

(

[enroll_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],

 CONSTRAINT [IX_temp_enrollment] UNIQUE NONCLUSTERED 

(

[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].[machine]    Script Date: 08-06-2024 14:47:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[machine](

[vnMachineNumber] [numeric](18, 0) NOT NULL,

[vpszIPAddress] [nvarchar](15) NOT NULL,

[vpszNetPort] [numeric](18, 0) NOT NULL,

[vpszNetPassword] [numeric](18, 0) NOT NULL,

[serverIP] [nvarchar](15) NOT NULL,

[serverPort] [nvarchar](50) NOT NULL,

[vnTimeOut] [numeric](18, 0) NOT NULL,

[vnProtocolType] [numeric](18, 0) NOT NULL,

[machineLocation] [nvarchar](50) NULL,

 CONSTRAINT [PK_machine] PRIMARY KEY CLUSTERED 

(

[vpszIPAddress] 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].[real_svr]    Script Date: 08-06-2024 14:47:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[real_svr](

[Id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[uid] [uniqueidentifier] NULL,

[aEnrollNumber] [numeric](18, 0) NOT NULL,

[aVerifyMode] [nvarchar](50) NULL,

[aInOutMode] [numeric](18, 0) NULL,

[adtLog] [datetime] NULL,

[abDrawFlag] [bit] NULL,

[astrRemoteIP] [nvarchar](50) NULL,

[anRemotePort] [numeric](18, 0) NULL,

[anDeviceID] [nvarchar](50) NULL,

[astrSerialNo] [nvarchar](50) NULL,

[astrRouterIP] [nvarchar](50) NULL,

[batch_id] [uniqueidentifier] NULL,

[class_id] [uniqueidentifier] NULL,

[department_id] [uniqueidentifier] NULL,

 CONSTRAINT [PK_real_svr] 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

/****** Object:  Table [dbo].[session]    Script Date: 08-06-2024 14:47:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[session](

[session_id] [uniqueidentifier] NOT NULL,

[session_name] [nvarchar](50) NOT NULL,

 CONSTRAINT [PK_session] PRIMARY KEY CLUSTERED 

(

[session_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


Comments

Post a Comment

Popular posts from this blog

Full Stack Web Development

  HTML Tutorial CSS Tutorial JavaScript Tutorial React Tutorial Bootstrap 5 Tutorial Node.js Tutorial Node.js Tutorial Key Components of Full Stack Development 1. Front-End (Client Side) This is what the user sees and interacts with. Languages & Technologies: HTML (Structure) CSS (Styling) JavaScript (Interactivity) Popular Frameworks/Libraries: React.js Angular Vue.js SASS / Tailwind CSS / Bootstrap 2. Back-End (Server Side) Handles the business logic, database interactions, and authentication. Languages & Frameworks: Node.js (JavaScript) Express.js Python (Django, Flask) Ruby on Rails Java (Spring Boot) PHP (Laravel) Database Management: SQL Databases: MySQL, PostgreSQL NoSQL Databases: MongoDB, Firebase
Read more

Reading Substring value from string excel data in c#

1. Form1.cs  using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.IO; using System.Data.SqlClient; namespace mspc {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private SqlConnection cn = new SqlConnection(Properties.Settings.Default.cnstr);         public void ConnectionOpen()         {             try             {                 if (cn.State != ConnectionState.Open) cn.Open();             }             ca...
Read more

Nodemon (automatically restarting the Node.js server)

 npm ps1 is not loaded because of running script is desable how to solve ChatGPT said: The error you're encountering is typically related to the execution policy in PowerShell, which restricts the running of scripts for security reasons. By default, PowerShell doesn't allow scripts to run unless the execution policy is set to allow them. To resolve this issue, you need to change the execution policy to allow scripts to run. Here are the steps to fix this issue: Open PowerShell as Administrator : Press Windows + X and choose Windows PowerShell (Admin) or Command Prompt (Admin) . Check the current execution policy (optional): In the PowerShell window, run this command to check the current execution policy: powershell Copy Get-ExecutionPolicy It will likely return Restricted , which is preventing the script from running. Set the execution policy to allow scripts : To allow scripts to run, use the following command: powershell Copy Set-ExecutionPolicy RemoteSi...
Read more