test1
-
CREATE TABLE [dbo].[Employee_Details]( [ID] [int] IDENTITY(1,1) NOT NULL, Emp_ID Varchar(10), Title int NOT NULL, First_Name Varchar(250), Last_Name Varchar(250), Nick_Name Varchar(250), Gender int NOT NULL, Nationality int NOT NULL, Designation Varchar(100), Department int NOT NULL, Qualification Varchar(100), Signature Image, Tel_Pri Varchar(20), Tel_Sec Varchar(20), Fax_Pri Varchar(20), Fax_Sec Varchar(20), Email_Pri Varchar(100), Email_Sec Varchar(100), Address Varchar(max), Photo Image, User_Name Varchar(25), Password Varchar(25), User_Role int NOT NULL, Remarks Varchar(max) CONSTRAINT [PK_EMP_ID] PRIMARY KEY NONCLUSTERED ( [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 ------------------------------------------------------------------------------------------------------------------ CREATE TABLE [dbo].[Company]( [ID] [int] IDENTITY(1,1) NOT NULL, Name Varchar(250), Address Varchar(max), POBox Varchar(20), Country int NOT NULL, State Varchar(100), Tel_Pri Varchar(20), Tel_Sec Varchar(20), Fax_Pri Varchar(20), Fax_Sec Varchar(20), Email_Pri Varchar(100), Email_Sec Varchar(100), Logo Image, Header Image, Footer Image, Photo Image, Created_By int NOT NULL, Created_On Datetime, Lastmodified_By int NOT NULL, Lastmodified_On Timestamp CONSTRAINT [PK_COMP_ID] PRIMARY KEY NONCLUSTERED ( [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 ------------------------------------------------------------------------------------------------------------------ CREATE TABLE [dbo].[Calibration_Details]( [Analysiscal_ID] [int] IDENTITY(1,1) NOT NULL, Inst_ID int NOT NULL, Calibration_Date Date, Calibrated_By int NOT NULL, Calibration_Type int NOT NULL, Validity_Days Integer, Calibration_Due Date, Calibration_Certificate Image, Remarks Varchar(max), Created_By int NOT NULL, Created_On Datetime, Lastmodified_By int NOT NULL, Lastmodified_On Timestamp CONSTRAINT [PK_CALIB_ID] PRIMARY KEY NONCLUSTERED ( [Analysiscal_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 ------------------------------------------------------------------------------------------------------------------ CREATE TABLE