 	[LocalAreaTeam] [varchar](100) NULL,
 	[CommissioningCounty] [varchar](50) NOT NULL,
 	[CommissioningCountry] [varchar](50) NOT NULL,
-	CONSTRAINT [PK_Organisation] PRIMARY KEY CLUSTERED
-		(
-			[SK_ServiceProviderID] ASC
-		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+ CONSTRAINT [PK_Organisation] PRIMARY KEY CLUSTERED 
+(
+	[SK_ServiceProviderID] 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

	[SK_StaffID] [int] NULL,
	[ConsultationType] [varchar](100) NULL,
	[ConsultationDuration] [smallint] NULL,
	[SK_ProblemID] [tinyint] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Index [SK_PatientID]    Script Date: 06/03/2016 15:51:58 ******/
CREATE CLUSTERED INDEX [SK_PatientID] ON [07T].[GPEncounter]
(
	[SK_PatientID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO
/****** Object:  Table [07T].[GPMedication]    Script Date: 06/03/2016 15:51:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON

	[EthnicityCode] [varchar](12) NULL,
	[YearOfDeath] [smallint] NULL,
	[UsualGPName] [varchar](100) NOT NULL,
 CONSTRAINT [PK_PatientDemographics] PRIMARY KEY NONCLUSTERED 
(
	[SK_ServiceProviderID] ASC,
	[SK_PatientID] 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
/****** Object:  Index [SK_PatientID]    Script Date: 29/03/2016 09:31:29 ******/
CREATE CLUSTERED INDEX [SK_PatientID] ON [07T].[PatientDemographics]
(
	[SK_PatientID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO
/****** Object:  Table [07T].[Patients]    Script Date: 29/03/2016 09:31:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
