 	[SK_PatientID] [int] NOT NULL,
 	[EventDate] [date] NOT NULL,
 	[EventTime] [time](0) NOT NULL,
-	[ClinicalCode] [varchar](12) NOT NULL,
+	[NativeClinicalCode] [varchar](12) NOT NULL,
 	[Value] [real] NOT NULL,
 	[Units] [varchar](30) NOT NULL,
 	[AgeAtEvent] [tinyint] NOT NULL,

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].[GPMedication]
(
	[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].[PatientDemographics]    Script Date: 06/03/2016 15:51:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON

	[SK_StaffID] [int] NULL,
	[ConsultationType] [varchar](100) NULL,
	[ConsultationDuration] [smallint] NULL,
	[SK_ProblemID] [tinyint] NULL,
	[SnomedClinicalCode] [varchar](255) NOT NULL
) 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].[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: 29/03/2016 09:31:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
