CREATE TABLE [dbo].[mst_Employee](
[Id] [int] NOT NULL,
[EmplCode] [varchar](max) NOT NULL,
[EmplName] [varchar](max) NOT NULL,
[EmplStatus] [varchar](max) NOT NULL,
[Gender] [varchar](max) NOT NULL,
[BirthDate] [date] NOT NULL,
[JoinDate] [date] NOT NULL,
[CreatDate] [date] NULL,
[LeavingDate] [date] NULL,
[PanNo] [varchar](max) NULL,
[CellPhone] [varchar](max) NULL,
[Email] [varchar](max) NOT NULL,
[Property] [varchar](max) NULL,
[mst_Empl_Bank_Id] [int] NOT NULL,
[Father_Husband] [varchar](100) NULL,
[MaritialStatus] [varchar](50) NULL,
CONSTRAINT [PK_mst_Employee] 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
above table is Employee master table