USE [cloudERP]
GO

/***** Object:  Table [db_masters].[emp_relations]    Script Date: 15-Jan-20 11:48:52 AM *****/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [db_masters].[emp_referals](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[coid] [int] NULL,
	[boid] [int] NULL,
	[empid] [bigint] NULL,
	[name] [varchar](200) NULL,
	[organization] [varchar](200) NULL,
	[contactno] [varchar](200) NULL,
	[email] [varchar](100) NULL,
	[isactive] [bit] NULL,
	[createdby] [int] NULL,
	[createdon] [datetime] NULL,
	
 CONSTRAINT [PK_emp_referals] 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

SET ANSI_PADDING OFF
GO



alter table db_masters.employee add [filename] varchar(200)
alter table db_masters.emp_relations add name varchar(200),dob date,genderid int,bloodgroup int,relation int
alter table db_masters.emp_healthcard alter column bloodgroup int
alter table db_masters.emp_healthcard alter column rhfactor int