IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'DefinePharmacyTechnicalAndPharmacist')
BEGIN

CREATE TABLE [dbo].[DefinePharmacyTechnicalAndPharmacist](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[UserName] [SMALLINT] NOT NULL,
	[Name] [NVARCHAR](30) NOT NULL,
	[Family] [NVARCHAR](60) NOT NULL,
	[NationalCode] [VARCHAR](10) NOT NULL,
	[MedicalCode] [VARCHAR](7) NULL,
	[Status] [TINYINT] NOT NULL,
 CONSTRAINT [PK_DefineTechnicalAssistantAndScrewVersion] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)
) ON [PRIMARY]

ALTER TABLE [dbo].[DefinePharmacyTechnicalAndPharmacist] ADD  CONSTRAINT [DF_DefineTechnicalAssistantAndScrewVersion_Id]  DEFAULT (NEWID()) FOR [Id]
ALTER TABLE [dbo].[DefinePharmacyTechnicalAndPharmacist] ADD  CONSTRAINT [DF_DefineTechnicalAssistantAndScrewVersion_Status]  DEFAULT ((0)) FOR [Status]
End