====================================================================================================================================
StudentAttendanceRegistry Table

CREATE TABLE [dbo].[StudentAttendanceRegistry](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[StudentID] [varchar](50) NULL,
	[SchoolYear] [varchar](50) NULL,
	[SchoolMonth] [varchar](50) NULL,
	[SchoolWeek] [int] NULL,
	[SchoolDay1] [varchar](50) NULL,
	[SchoolDay2] [varchar](50) NULL,
	[SchoolDay3] [varchar](50) NULL,
	[SchoolDay4] [varchar](50) NULL,
	[SchoolDay5] [varchar](50) NULL,
	[TotalPresentDays] [int] NULL,
 CONSTRAINT [PK_AttendanceDetails] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



====================================================================================================================================
Students Table

CREATE TABLE [dbo].[Students](
	[ID] [uniqueidentifier] NOT NULL,
	[StudentID] [varchar](50) NULL,
	[ExistingStudentID] [varchar](50) NULL,
	[BatchID] [varchar](50) NULL,
	[ScholarshipID] [varchar](50) NULL,
	[FullName] [varchar](250) NULL,
	[NameWithInitial] [varchar](50) NULL,
	[NIC] [varchar](25) NULL,
	[Gender] [varchar](10) NULL,
	[DateOfBirth] [date] NULL,
	[BloodGroup] [varchar](5) NULL,
	[Address] [varchar](250) NULL,
	[Email] [varchar](50) NULL,
	[SchoolAttended] [varchar](250) NULL,
	[GradePassed] [varchar](25) NULL,
	[SchoolYear] [int] NULL,
	[PGType] [varchar](20) NULL,
	[PGName] [varchar](250) NULL,
	[ContactHome] [varchar](10) NULL,
	[ContactMobile] [varchar](15) NULL,
	[ParentsWhatsApp] [varchar](15) NULL,
	[StudentsWhatsApp] [varchar](15) NULL,
	[PGOccupation] [varchar](250) NULL,
	[RegisteredCourse] [varchar](50) NULL,
	[CourseType] [varchar](10) NULL,
	[RegisteredDate] [smalldatetime] NULL,
	[PhotoUrl] [varchar](200) NULL,
	[IsHostelStudent] [int] NULL,
	[IsDropped] [int] NULL,
	[DropReason] [varchar](200) NULL,
	[StudentCardIssued] [int] NULL,
	[IsTransferedStudent] [int] NULL,
	[PrevStudentID] [varchar](50) NULL,
	[PrevCourse] [varchar](50) NULL,
	[PrevBatch] [varchar](50) NULL,
	[StudentStatus] [varchar](50) NULL,
	[Remark] [varchar](255) NULL,
 CONSTRAINT [PK_Students] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO




====================================================================================================================================
Batches Table

CREATE TABLE [dbo].[Batches](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[BatchID] [varchar](50) NULL,
	[Course] [varchar](50) NULL,
	[DurationAmount] [int] NULL,
	[DurationType] [varchar](50) NULL,
	[CourseTime] [varchar](50) NULL,
	[ClassesPerWeek] [int] NULL,
	[CourseRegFeeForOther] [money] NULL,
	[CourseRegFeeForExisting] [money] NULL,
	[MonthlyFeeForOther] [money] NULL,
	[MonthlyFeeForExisting] [money] NULL,
	[TotalFeeForOther] [money] NULL,
	[TotalFeeForExisting] [money] NULL,
	[HostelRegFee] [money] NULL,
	[HostelFee] [money] NULL,
	[MattressFee] [money] NULL,
	[OverallKitFee] [money] NULL,
	[TShirtFee] [money] NULL,
	[HostelMaintenanceFee] [money] NULL,
	[BatchStartDate] [date] NULL,
	[BatchEndDate] [date] NULL,
	[BatchCreatedDate] [smalldatetime] NULL,
	[isEmptyBatch] [int] NULL,
	[BatchStatus] [varchar](50) NULL,
 CONSTRAINT [PK_Batches] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO