This wiki has undergone a migration to Confluence found Here
SqlServer RIMBAA script
Jump to navigation
Jump to search
This is a SQL Server script to create tables which correspond to a simple RIM Based database. It is not intended to provide a complete implementation of the RIM. See RIMdb and RIMBAA.
USE [HL7RimJavaSig]
GO
/****** Object: Table [dbo].[Act] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Act](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[classCode] [varchar](32) NULL,
[moodCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[code_code] [varchar](400) NULL,
[code_codeSystem] [varchar](400) NULL,
[code_displayName] [varchar](400) NULL,
[code_xml] [nvarchar](max) NULL,
[negationInd] [varchar](255) NULL,
[derivationExpr] [varchar](255) NULL,
[title] [nvarchar](max) NULL,
[text] [nvarchar](max) NULL,
[statusCode_code] [varchar](400) NULL,
[statusCode_codeSystem] [varchar](400) NULL,
[effectiveTime_low] [varchar](400) NULL,
[effectiveTime_high] [varchar](400) NULL,
[effectiveTime_xml] [nvarchar](max) NULL,
[activityTime_low] [varchar](400) NULL,
[activityTime_high] [varchar](400) NULL,
[activityTime_xml] [nvarchar](max) NULL,
[availabilityTime] [varchar](255) NULL,
[repeatNumber] [nvarchar](max) NULL,
[interruptibleInd] [varchar](255) NULL,
[levelCode_code] [varchar](400) NULL,
[levelCode_codeSystem] [varchar](400) NULL,
[levelCode_displayName] [varchar](400) NULL,
[levelCode_xml] [nvarchar](max) NULL,
[independentInd] [varchar](255) NULL,
[uncertaintyCode_code] [varchar](400) NULL,
[uncertaintyCode_codeSystem] [varchar](400) NULL,
[uncertaintyCode_displayName] [varchar](400) NULL,
[uncertaintyCode_xml] [nvarchar](max) NULL,
[languageCode_code] [varchar](400) NULL,
[languageCode_codeSystem] [varchar](400) NULL,
[languageCode_displayName] [varchar](400) NULL,
[languageCode_xml] [nvarchar](max) NULL,
[balanceAmt] [nvarchar](max) NULL,
[currencyCode_code] [varchar](400) NULL,
[currencyCode_codeSystem] [varchar](400) NULL,
[currencyCode_displayName] [varchar](400) NULL,
[currencyCode_xml] [nvarchar](max) NULL,
[interestRateQuantity_numeratorNumber] [varchar](400) NULL,
[interestRateQuantity_numeratorUnit] [varchar](400) NULL,
[interestRateQuantity_denominatorNumber] [varchar](400) NULL,
[interestRateQuantity_denominatorUnit] [varchar](400) NULL,
[interestRateQuantity_xml] [nvarchar](max) NULL,
[allowedBalanceQuantity] [nvarchar](max) NULL,
[parameterValue] [nvarchar](max) NULL,
[paymentTermsCode_code] [varchar](400) NULL,
[paymentTermsCode_codeSystem] [varchar](400) NULL,
[paymentTermsCode_displayName] [varchar](400) NULL,
[paymentTermsCode_xml] [nvarchar](max) NULL,
[amt] [nvarchar](max) NULL,
[creditExchangeRateQuantity] [varchar](255) NULL,
[debitExchangeRateQuantity] [varchar](255) NULL,
[unitQuantity_numeratorNumber] [varchar](400) NULL,
[unitQuantity_numeratorUnit] [varchar](400) NULL,
[unitQuantity_denominatorNumber] [varchar](400) NULL,
[unitQuantity_denominatorUnit] [varchar](400) NULL,
[unitQuantity_xml] [nvarchar](max) NULL,
[unitPriceAmt_numeratorNumber] [varchar](400) NULL,
[unitPriceAmt_numeratorUnit] [varchar](400) NULL,
[unitPriceAmt_denominatorNumber] [varchar](400) NULL,
[unitPriceAmt_denominatorUnit] [varchar](400) NULL,
[unitPriceAmt_xml] [nvarchar](max) NULL,
[netAmt] [nvarchar](max) NULL,
[factorNumber] [varchar](255) NULL,
[pointsNumber] [varchar](255) NULL,
[value_displayName] [varchar](400) NULL,
[value_code] [varchar](400) NULL,
[value_codeSystem] [varchar](400) NULL,
[value_number] [varchar](400) NULL,
[value_unit] [varchar](400) NULL,
[value_xml] [nvarchar](max) NULL,
[subjectOrientationCode_code] [varchar](400) NULL,
[subjectOrientationCode_codeSystem] [varchar](400) NULL,
[subjectOrientationCode_displayName] [varchar](400) NULL,
[subjectOrientationCode_xml] [nvarchar](max) NULL,
[detectionMethodCode_code] [varchar](400) NULL,
[detectionMethodCode_codeSystem] [varchar](400) NULL,
[detectionMethodCode_displayName] [varchar](400) NULL,
[detectionMethodCode_xml] [nvarchar](max) NULL,
[transmissionModeCode_code] [varchar](400) NULL,
[transmissionModeCode_codeSystem] [varchar](400) NULL,
[transmissionModeCode_displayName] [varchar](400) NULL,
[transmissionModeCode_xml] [nvarchar](max) NULL,
[diseaseImportedCode_code] [varchar](400) NULL,
[diseaseImportedCode_codeSystem] [varchar](400) NULL,
[diseaseImportedCode_displayName] [varchar](400) NULL,
[diseaseImportedCode_xml] [nvarchar](max) NULL,
[admissionReferralSourceCode_code] [varchar](400) NULL,
[admissionReferralSourceCode_codeSystem] [varchar](400) NULL,
[admissionReferralSourceCode_displayName] [varchar](400) NULL,
[admissionReferralSourceCode_xml] [nvarchar](max) NULL,
[lengthOfStayQuantity] [nvarchar](max) NULL,
[dischargeDispositionCode_code] [varchar](400) NULL,
[dischargeDispositionCode_codeSystem] [varchar](400) NULL,
[dischargeDispositionCode_displayName] [varchar](400) NULL,
[dischargeDispositionCode_xml] [nvarchar](max) NULL,
[preAdmitTestInd] [varchar](255) NULL,
[routeCode_code] [varchar](400) NULL,
[routeCode_codeSystem] [varchar](400) NULL,
[routeCode_displayName] [varchar](400) NULL,
[routeCode_xml] [nvarchar](max) NULL,
[doseQuantity] [nvarchar](max) NULL,
[rateQuantity] [nvarchar](max) NULL,
[administrationUnitCode_code] [varchar](400) NULL,
[administrationUnitCode_codeSystem] [varchar](400) NULL,
[administrationUnitCode_displayName] [varchar](400) NULL,
[administrationUnitCode_xml] [nvarchar](max) NULL,
[quantity] [nvarchar](max) NULL,
[expectedUseTime] [nvarchar](max) NULL,
[energyQuantity] [nvarchar](max) NULL,
[carbohydrateQuantity] [nvarchar](max) NULL,
[ownershipLevelCode_code] [varchar](400) NULL,
[ownershipLevelCode_codeSystem] [varchar](400) NULL,
[ownershipLevelCode_displayName] [varchar](400) NULL,
[ownershipLevelCode_xml] [nvarchar](max) NULL,
[setId_root] [varchar](400) NULL,
[setId_extension] [varchar](400) NULL,
[versionNumber] [varchar](255) NULL,
[completionCode_code] [varchar](400) NULL,
[completionCode_codeSystem] [varchar](400) NULL,
[completionCode_displayName] [varchar](400) NULL,
[completionCode_xml] [nvarchar](max) NULL,
[storageCode_code] [varchar](400) NULL,
[storageCode_codeSystem] [varchar](400) NULL,
[storageCode_displayName] [varchar](400) NULL,
[storageCode_xml] [nvarchar](max) NULL,
[copyTime] [varchar](255) NULL,
[bibliographicDesignationText] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[entity] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[entity](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[classCode] [varchar](32) NULL,
[determinerCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[code_code] [varchar](400) NULL,
[code_codeSystem] [varchar](400) NULL,
[code_displayName] [varchar](400) NULL,
[code_xml] [varchar](400) NULL,
[quantity] [nvarchar](max) NULL,
[desc] [nvarchar](max) NULL,
[statusCode_code] [varchar](400) NULL,
[statusCode_codeSystem] [varchar](400) NULL,
[existenceTime] [nvarchar](max) NULL,
[riskCode_code] [varchar](400) NULL,
[riskCode_codeSystem] [varchar](400) NULL,
[riskCode_displayName] [varchar](400) NULL,
[riskCode_xml] [nvarchar](max) NULL,
[handlingCode_code] [varchar](400) NULL,
[handlingCode_codeSystem] [varchar](400) NULL,
[handlingCode_displayName] [varchar](400) NULL,
[handlingCode_xml] [nvarchar](max) NULL,
[administrativeGenderCode_code] [varchar](400) NULL,
[administrativeGenderCode_codeSystem] [varchar](400) NULL,
[administrativeGenderCode_displayName] [varchar](400) NULL,
[administrativeGenderCode_xml] [nvarchar](max) NULL,
[birthTime] [varchar](255) NULL,
[deceasedInd] [varchar](255) NULL,
[deceasedTime] [varchar](255) NULL,
[multipleBirthInd] [varchar](255) NULL,
[multipleBirthOrderNumber] [varchar](255) NULL,
[organDonorInd] [varchar](255) NULL,
[strainText] [nvarchar](max) NULL,
[genderStatusCode_code] [varchar](400) NULL,
[genderStatusCode_codeSystem] [varchar](400) NULL,
[genderStatusCode_displayName] [varchar](400) NULL,
[genderStatusCode_xml] [nvarchar](max) NULL,
[maritalStatusCode_code] [varchar](400) NULL,
[maritalStatusCode_codeSystem] [varchar](400) NULL,
[maritalStatusCode_displayName] [varchar](400) NULL,
[maritalStatusCode_xml] [nvarchar](max) NULL,
[educationLevelCode_code] [varchar](400) NULL,
[educationLevelCode_codeSystem] [varchar](400) NULL,
[educationLevelCode_displayName] [varchar](400) NULL,
[educationLevelCode_xml] [nvarchar](max) NULL,
[livingArrangementCode_code] [varchar](400) NULL,
[livingArrangementCode_codeSystem] [varchar](400) NULL,
[livingArrangementCode_displayName] [varchar](400) NULL,
[livingArrangementCode_xml] [nvarchar](max) NULL,
[religiousAffiliationCode_code] [varchar](400) NULL,
[religiousAffiliationCode_codeSystem] [varchar](400) NULL,
[religiousAffiliationCode_displayName] [varchar](400) NULL,
[religiousAffiliationCode_xml] [nvarchar](max) NULL,
[formCode_code] [varchar](400) NULL,
[formCode_codeSystem] [varchar](400) NULL,
[formCode_displayName] [varchar](400) NULL,
[formCode_xml] [nvarchar](max) NULL,
[lotNumberText] [varchar](255) NULL,
[expirationTime] [nvarchar](max) NULL,
[stabilityTime] [nvarchar](max) NULL,
[capacityQuantity] [nvarchar](max) NULL,
[heightQuantity] [nvarchar](max) NULL,
[diameterQuantity] [nvarchar](max) NULL,
[capTypeCode_code] [varchar](400) NULL,
[capTypeCode_codeSystem] [varchar](400) NULL,
[capTypeCode_displayName] [varchar](400) NULL,
[capTypeCode_xml] [nvarchar](max) NULL,
[separatorTypeCode_code] [varchar](400) NULL,
[separatorTypeCode_codeSystem] [varchar](400) NULL,
[separatorTypeCode_displayName] [varchar](400) NULL,
[separatorTypeCode_xml] [nvarchar](max) NULL,
[barrierDeltaQuantity] [nvarchar](max) NULL,
[bottomDeltaQuantity] [nvarchar](max) NULL,
[manufacturerModelName] [nvarchar](max) NULL,
[softwareName] [nvarchar](max) NULL,
[localRemoteControlStateCode_code] [varchar](400) NULL,
[localRemoteControlStateCode_codeSystem] [varchar](400) NULL,
[localRemoteControlStateCode_displayName] [varchar](400) NULL,
[localRemoteControlStateCode_xml] [nvarchar](max) NULL,
[alertLevelCode_code] [varchar](400) NULL,
[alertLevelCode_codeSystem] [varchar](400) NULL,
[alertLevelCode_displayName] [varchar](400) NULL,
[alertLevelCode_xml] [nvarchar](max) NULL,
[lastCalibrationTime] [varchar](255) NULL,
[standardIndustryClassCode_code] [varchar](400) NULL,
[standardIndustryClassCode_codeSystem] [varchar](400) NULL,
[standardIndustryClassCode_displayName] [varchar](400) NULL,
[standardIndustryClassCode_xml] [nvarchar](max) NULL,
[mobileInd] [varchar](255) NULL,
[addr] [nvarchar](max) NULL,
[directionsText] [nvarchar](max) NULL,
[positionText] [nvarchar](max) NULL,
[gpsText] [varchar](255) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[actrelationship] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[actrelationship](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[typeCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[SourceInternalId] [varchar](255) NULL,
[TargetInternalId] [varchar](255) NULL,
[inversionInd] [varchar](255) NULL,
[contextControlCode_code] [varchar](400) NULL,
[contextControlCode_codeSystem] [varchar](400) NULL,
[contextConductionInd] [varchar](255) NULL,
[sequenceNumber] [varchar](255) NULL,
[priorityNumber] [varchar](255) NULL,
[pauseQuantity] [nvarchar](max) NULL,
[checkpointCode_code] [varchar](400) NULL,
[checkpointCode_codeSystem] [varchar](400) NULL,
[splitCode_code] [varchar](400) NULL,
[splitCode_codeSystem] [varchar](400) NULL,
[joinCode_code] [varchar](400) NULL,
[joinCode_codeSystem] [varchar](400) NULL,
[negationInd] [varchar](255) NULL,
[conjunctionCode_code] [varchar](400) NULL,
[conjunctionCode_codeSystem] [varchar](400) NULL,
[localVariableName] [varchar](255) NULL,
[seperatableInd] [varchar](255) NULL,
[subsetCode_code] [varchar](400) NULL,
[subsetCode_codeSystem] [varchar](400) NULL,
[uncertaintyCode_code] [varchar](400) NULL,
[uncertaintyCode_codeSystem] [varchar](400) NULL,
[uncertaintyCode_displayName] [varchar](400) NULL,
[uncertaintyCode_xml] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[Act_reasonCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Act_reasonCode](
[ActInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Act_priorityCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Act_priorityCode](
[ActInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Act_id] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Act_id](
[actInternalId] [varchar](255) NOT NULL,
[root] [varchar](400) NULL,
[extension] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Act_confidentialityCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Act_confidentialityCode](
[ActInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[InvoiceElement_modifierCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InvoiceElement_modifierCode](
[InvoiceElementInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Entity_telecom] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Entity_telecom](
[EntityInternalId] [varchar](255) NOT NULL,
[url] [varchar](400) NULL,
[use_] [varchar](400) NULL,
[useablePeriod] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Entity_name] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Entity_name](
[EntityInternalId] [varchar](255) NOT NULL,
[familyName] [varchar](400) NULL,
[givenName] [varchar](400) NULL,
[trivialName] [varchar](400) NULL,
[xml] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Entity_id] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Entity_id](
[entityInternalId] [varchar](255) NOT NULL,
[root] [varchar](400) NULL,
[extension] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Organization_addr] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Organization_addr](
[OrganizationInternalId] [varchar](255) NOT NULL,
[elt] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Observation_targetSiteCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Observation_targetSiteCode](
[ObservationInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Observation_methodCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Observation_methodCode](
[ObservationInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Observation_interpretationCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Observation_interpretationCode](
[ObservationInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[role_] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[role_](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[classCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[PlayerInternalId] [varchar](255) NULL,
[ScoperInternalId] [varchar](255) NULL,
[code_code] [varchar](400) NULL,
[code_codeSystem] [varchar](400) NULL,
[code_displayName] [varchar](400) NULL,
[code_xml] [nvarchar](max) NULL,
[negationInd] [varchar](255) NULL,
[statusCode_code] [varchar](400) NULL,
[statusCode_codeSystem] [varchar](400) NULL,
[effectiveTime] [nvarchar](max) NULL,
[certificateText] [nvarchar](max) NULL,
[quantity_numeratorNumber] [varchar](400) NULL,
[quantity_numeratorUnit] [varchar](400) NULL,
[quantity_denominatorNumber] [varchar](400) NULL,
[quantity_denominatorUnit] [varchar](400) NULL,
[quantity_xml] [nvarchar](max) NULL,
[positionNumber] [nvarchar](max) NULL,
[approachSiteCode_code] [varchar](400) NULL,
[approachSiteCode_codeSystem] [varchar](400) NULL,
[approachSiteCode_displayName] [varchar](400) NULL,
[approachSiteCode_xml] [nvarchar](max) NULL,
[targetSiteCode_code] [varchar](400) NULL,
[targetSiteCode_codeSystem] [varchar](400) NULL,
[targetSiteCode_displayName] [varchar](400) NULL,
[targetSiteCode_xml] [nvarchar](max) NULL,
[gaugeQuantity] [nvarchar](max) NULL,
[jobCode_code] [varchar](400) NULL,
[jobCode_codeSystem] [varchar](400) NULL,
[jobCode_displayName] [varchar](400) NULL,
[jobCode_xml] [nvarchar](max) NULL,
[jobTitleName] [nvarchar](max) NULL,
[jobClassCode_code] [varchar](400) NULL,
[jobClassCode_codeSystem] [varchar](400) NULL,
[jobClassCode_displayName] [varchar](400) NULL,
[jobClassCode_xml] [nvarchar](max) NULL,
[occupationCode_code] [varchar](400) NULL,
[occupationCode_codeSystem] [varchar](400) NULL,
[occupationCode_displayName] [varchar](400) NULL,
[occupationCode_xml] [nvarchar](max) NULL,
[salaryTypeCode_code] [varchar](400) NULL,
[salaryTypeCode_codeSystem] [varchar](400) NULL,
[salaryTypeCode_displayName] [varchar](400) NULL,
[salaryTypeCode_xml] [nvarchar](max) NULL,
[salaryQuantity] [nvarchar](max) NULL,
[hazardExposureText] [nvarchar](max) NULL,
[protectiveEquipmentText] [nvarchar](max) NULL,
[recertificationTime] [varchar](255) NULL,
[veryImportantPersonCode_code] [varchar](400) NULL,
[veryImportantPersonCode_codeSystem] [varchar](400) NULL,
[veryImportantPersonCode_displayName] [varchar](400) NULL,
[veryImportantPersonCode_xml] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[Procedure_targetSiteCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Procedure_targetSiteCode](
[ProcedureInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Procedure_methodCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Procedure_methodCode](
[ProcedureInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Procedure_approachSiteCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Procedure_approachSiteCode](
[ProcedureInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Person_raceCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person_raceCode](
[PersonInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Person_ethnicGroupCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person_ethnicGroupCode](
[PersonInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Person_disabilityCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person_disabilityCode](
[PersonInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Person_addr] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person_addr](
[PersonInternalId] [varchar](255) NOT NULL,
[elt] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[PatientEncounter_specialCourtesiesCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PatientEncounter_specialCourtesiesCode](
[PatientEncounterInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[PatientEncounter_specialArrangementCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PatientEncounter_specialArrangementCode](
[PatientEncounterInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SubstanceAdministration_maxDoseQuantity] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SubstanceAdministration_maxDoseQuantity](
[SubstanceAdministrationInternalId] [varchar](255) NOT NULL,
[numeratorNumber] [varchar](400) NULL,
[numeratorUnit] [varchar](400) NULL,
[denominatorNumber] [varchar](400) NULL,
[denominatorUnit] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SubstanceAdministration_doseCheckQuantity] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SubstanceAdministration_doseCheckQuantity](
[SubstanceAdministrationInternalId] [varchar](255) NOT NULL,
[numeratorNumber] [varchar](400) NULL,
[numeratorUnit] [varchar](400) NULL,
[denominatorNumber] [varchar](400) NULL,
[denominatorUnit] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SubstanceAdministration_approachSiteCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SubstanceAdministration_approachSiteCode](
[SubstanceAdministrationInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[rolelink] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rolelink](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[typeCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[SourceInternalId] [varchar](255) NULL,
[TargetInternalId] [varchar](255) NULL,
[priorityNumber] [varchar](255) NULL,
[effectiveTime] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[Role_telecom] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role_telecom](
[RoleInternalId] [varchar](255) NOT NULL,
[url] [varchar](400) NULL,
[use_] [varchar](400) NULL,
[useablePeriod] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Role_name] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role_name](
[RoleInternalId] [varchar](255) NOT NULL,
[familyName] [varchar](400) NULL,
[givenName] [varchar](400) NULL,
[trivialName] [varchar](400) NULL,
[xml] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Role_id] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role_id](
[roleInternalId] [varchar](255) NOT NULL,
[root] [varchar](400) NULL,
[extension] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Role_confidentialityCode] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role_confidentialityCode](
[RoleInternalId] [varchar](255) NOT NULL,
[code] [varchar](400) NULL,
[codeSystem] [varchar](400) NULL,
[displayName] [varchar](400) NULL,
[xml] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Role_addr] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role_addr](
[RoleInternalId] [varchar](255) NOT NULL,
[elt] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[participation] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[participation](
[internalId] [varchar](255) NOT NULL,
[internalDiscriminator] [varchar](255) NOT NULL,
[internalVersionNumber] [bigint] NOT NULL,
[typeCode] [varchar](32) NULL,
[cloneCode_code] [varchar](400) NULL,
[ActInternalId] [varchar](255) NULL,
[RoleInternalId] [varchar](255) NULL,
[functionCode_code] [varchar](400) NULL,
[functionCode_codeSystem] [varchar](400) NULL,
[functionCode_displayName] [varchar](400) NULL,
[functionCode_xml] [nvarchar](max) NULL,
[contextControlCode_code] [varchar](400) NULL,
[contextControlCode_codeSystem] [varchar](400) NULL,
[sequenceNumber] [varchar](255) NULL,
[negationInd] [varchar](255) NULL,
[noteText] [nvarchar](max) NULL,
[time] [nvarchar](max) NULL,
[modeCode_code] [varchar](400) NULL,
[modeCode_codeSystem] [varchar](400) NULL,
[modeCode_displayName] [varchar](400) NULL,
[modeCode_xml] [nvarchar](max) NULL,
[awarenessCode_code] [varchar](400) NULL,
[awarenessCode_codeSystem] [varchar](400) NULL,
[awarenessCode_displayName] [varchar](400) NULL,
[awarenessCode_xml] [nvarchar](max) NULL,
[signatureCode_code] [varchar](400) NULL,
[signatureCode_codeSystem] [varchar](400) NULL,
[signatureCode_displayName] [varchar](400) NULL,
[signatureCode_xml] [nvarchar](max) NULL,
[signatureText] [nvarchar](max) NULL,
[performInd] [varchar](255) NULL,
[substitutionConditionCode_code] [varchar](400) NULL,
[substitutionConditionCode_codeSystem] [varchar](400) NULL,
[substitutionConditionCode_displayName] [varchar](400) NULL,
[substitutionConditionCode_xml] [nvarchar](max) NULL,
[subsetCode_code] [varchar](400) NULL,
[subsetCode_codeSystem] [varchar](400) NULL,
[statusCode_code] [varchar](400) NULL,
[statusCode_codeSystem] [varchar](400) NULL,
PRIMARY KEY CLUSTERED
(
[internalId] 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: Table [dbo].[ManagedParticipation_id] Script Date: 02/03/2009 15:34:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ManagedParticipation_id](
[ManagedParticipationInternalId] [varchar](255) NOT NULL,
[root] [varchar](400) NULL,
[extension] [varchar](400) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: ForeignKey [FK7B6C91E6D338BA0B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Act_confidentialityCode] WITH CHECK ADD CONSTRAINT [FK7B6C91E6D338BA0B] FOREIGN KEY([ActInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Act_confidentialityCode] CHECK CONSTRAINT [FK7B6C91E6D338BA0B]
GO
/****** Object: ForeignKey [FK74944408D338BA0B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Act_id] WITH CHECK ADD CONSTRAINT [FK74944408D338BA0B] FOREIGN KEY([actInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Act_id] CHECK CONSTRAINT [FK74944408D338BA0B]
GO
/****** Object: ForeignKey [FKC9CD5C5ED338BA0B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Act_priorityCode] WITH CHECK ADD CONSTRAINT [FKC9CD5C5ED338BA0B] FOREIGN KEY([ActInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Act_priorityCode] CHECK CONSTRAINT [FKC9CD5C5ED338BA0B]
GO
/****** Object: ForeignKey [FK7E63EC3ED338BA0B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Act_reasonCode] WITH CHECK ADD CONSTRAINT [FK7E63EC3ED338BA0B] FOREIGN KEY([ActInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Act_reasonCode] CHECK CONSTRAINT [FK7E63EC3ED338BA0B]
GO
/****** Object: ForeignKey [FK68ABA3CA3BD6608A] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[actrelationship] WITH CHECK ADD CONSTRAINT [FK68ABA3CA3BD6608A] FOREIGN KEY([TargetInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[actrelationship] CHECK CONSTRAINT [FK68ABA3CA3BD6608A]
GO
/****** Object: ForeignKey [FK68ABA3CA50ADC04A] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[actrelationship] WITH CHECK ADD CONSTRAINT [FK68ABA3CA50ADC04A] FOREIGN KEY([TargetInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[actrelationship] CHECK CONSTRAINT [FK68ABA3CA50ADC04A]
GO
/****** Object: ForeignKey [FK68ABA3CA60B53294] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[actrelationship] WITH CHECK ADD CONSTRAINT [FK68ABA3CA60B53294] FOREIGN KEY([SourceInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[actrelationship] CHECK CONSTRAINT [FK68ABA3CA60B53294]
GO
/****** Object: ForeignKey [FK68ABA3CA758C9254] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[actrelationship] WITH CHECK ADD CONSTRAINT [FK68ABA3CA758C9254] FOREIGN KEY([SourceInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[actrelationship] CHECK CONSTRAINT [FK68ABA3CA758C9254]
GO
/****** Object: ForeignKey [FK4B4DFED73668AD6F] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Entity_id] WITH CHECK ADD CONSTRAINT [FK4B4DFED73668AD6F] FOREIGN KEY([entityInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Entity_id] CHECK CONSTRAINT [FK4B4DFED73668AD6F]
GO
/****** Object: ForeignKey [FKAFCBED473668AD6F] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Entity_name] WITH CHECK ADD CONSTRAINT [FKAFCBED473668AD6F] FOREIGN KEY([EntityInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Entity_name] CHECK CONSTRAINT [FKAFCBED473668AD6F]
GO
/****** Object: ForeignKey [FKE85D695B3668AD6F] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Entity_telecom] WITH CHECK ADD CONSTRAINT [FKE85D695B3668AD6F] FOREIGN KEY([EntityInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Entity_telecom] CHECK CONSTRAINT [FKE85D695B3668AD6F]
GO
/****** Object: ForeignKey [FK2CA16C749B4375E7] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[InvoiceElement_modifierCode] WITH CHECK ADD CONSTRAINT [FK2CA16C749B4375E7] FOREIGN KEY([InvoiceElementInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[InvoiceElement_modifierCode] CHECK CONSTRAINT [FK2CA16C749B4375E7]
GO
/****** Object: ForeignKey [FK53735E782088E18D] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[ManagedParticipation_id] WITH CHECK ADD CONSTRAINT [FK53735E782088E18D] FOREIGN KEY([ManagedParticipationInternalId])
REFERENCES [dbo].[participation] ([internalId])
GO
ALTER TABLE [dbo].[ManagedParticipation_id] CHECK CONSTRAINT [FK53735E782088E18D]
GO
/****** Object: ForeignKey [FK9CF95328AB4FE4BF] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Observation_interpretationCode] WITH CHECK ADD CONSTRAINT [FK9CF95328AB4FE4BF] FOREIGN KEY([ObservationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Observation_interpretationCode] CHECK CONSTRAINT [FK9CF95328AB4FE4BF]
GO
/****** Object: ForeignKey [FKE18E3081AB4FE4BF] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Observation_methodCode] WITH CHECK ADD CONSTRAINT [FKE18E3081AB4FE4BF] FOREIGN KEY([ObservationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Observation_methodCode] CHECK CONSTRAINT [FKE18E3081AB4FE4BF]
GO
/****** Object: ForeignKey [FKFA500F18AB4FE4BF] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Observation_targetSiteCode] WITH CHECK ADD CONSTRAINT [FKFA500F18AB4FE4BF] FOREIGN KEY([ObservationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Observation_targetSiteCode] CHECK CONSTRAINT [FKFA500F18AB4FE4BF]
GO
/****** Object: ForeignKey [FKB7FAEF5D9994234F] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Organization_addr] WITH CHECK ADD CONSTRAINT [FKB7FAEF5D9994234F] FOREIGN KEY([OrganizationInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Organization_addr] CHECK CONSTRAINT [FKB7FAEF5D9994234F]
GO
/****** Object: ForeignKey [FKB6018D41B42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[participation] WITH CHECK ADD CONSTRAINT [FKB6018D41B42BD995] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[participation] CHECK CONSTRAINT [FKB6018D41B42BD995]
GO
/****** Object: ForeignKey [FKB6018D41BE615A4B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[participation] WITH CHECK ADD CONSTRAINT [FKB6018D41BE615A4B] FOREIGN KEY([ActInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[participation] CHECK CONSTRAINT [FKB6018D41BE615A4B]
GO
/****** Object: ForeignKey [FKB6018D41D338BA0B] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[participation] WITH CHECK ADD CONSTRAINT [FKB6018D41D338BA0B] FOREIGN KEY([ActInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[participation] CHECK CONSTRAINT [FKB6018D41D338BA0B]
GO
/****** Object: ForeignKey [FKB6018D41D98D00D5] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[participation] WITH CHECK ADD CONSTRAINT [FKB6018D41D98D00D5] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[participation] CHECK CONSTRAINT [FKB6018D41D98D00D5]
GO
/****** Object: ForeignKey [FKCB495DAFD3D84A5] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[PatientEncounter_specialArrangementCode] WITH CHECK ADD CONSTRAINT [FKCB495DAFD3D84A5] FOREIGN KEY([PatientEncounterInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[PatientEncounter_specialArrangementCode] CHECK CONSTRAINT [FKCB495DAFD3D84A5]
GO
/****** Object: ForeignKey [FK6D604333D3D84A5] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[PatientEncounter_specialCourtesiesCode] WITH CHECK ADD CONSTRAINT [FK6D604333D3D84A5] FOREIGN KEY([PatientEncounterInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[PatientEncounter_specialCourtesiesCode] CHECK CONSTRAINT [FK6D604333D3D84A5]
GO
/****** Object: ForeignKey [FK4A032E7B40E5ECD3] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Person_addr] WITH CHECK ADD CONSTRAINT [FK4A032E7B40E5ECD3] FOREIGN KEY([PersonInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Person_addr] CHECK CONSTRAINT [FK4A032E7B40E5ECD3]
GO
/****** Object: ForeignKey [FK8FC56F340E5ECD3] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Person_disabilityCode] WITH CHECK ADD CONSTRAINT [FK8FC56F340E5ECD3] FOREIGN KEY([PersonInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Person_disabilityCode] CHECK CONSTRAINT [FK8FC56F340E5ECD3]
GO
/****** Object: ForeignKey [FKCDF83F3340E5ECD3] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Person_ethnicGroupCode] WITH CHECK ADD CONSTRAINT [FKCDF83F3340E5ECD3] FOREIGN KEY([PersonInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Person_ethnicGroupCode] CHECK CONSTRAINT [FKCDF83F3340E5ECD3]
GO
/****** Object: ForeignKey [FK6476D9E840E5ECD3] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Person_raceCode] WITH CHECK ADD CONSTRAINT [FK6476D9E840E5ECD3] FOREIGN KEY([PersonInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[Person_raceCode] CHECK CONSTRAINT [FK6476D9E840E5ECD3]
GO
/****** Object: ForeignKey [FKC5D075A8E769018D] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Procedure_approachSiteCode] WITH CHECK ADD CONSTRAINT [FKC5D075A8E769018D] FOREIGN KEY([ProcedureInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Procedure_approachSiteCode] CHECK CONSTRAINT [FKC5D075A8E769018D]
GO
/****** Object: ForeignKey [FKD31AF7AE769018D] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Procedure_methodCode] WITH CHECK ADD CONSTRAINT [FKD31AF7AE769018D] FOREIGN KEY([ProcedureInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Procedure_methodCode] CHECK CONSTRAINT [FKD31AF7AE769018D]
GO
/****** Object: ForeignKey [FK99B96991E769018D] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Procedure_targetSiteCode] WITH CHECK ADD CONSTRAINT [FK99B96991E769018D] FOREIGN KEY([ProcedureInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[Procedure_targetSiteCode] CHECK CONSTRAINT [FK99B96991E769018D]
GO
/****** Object: ForeignKey [FK67A8EA9216BEE2A] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[role_] WITH CHECK ADD CONSTRAINT [FK67A8EA9216BEE2A] FOREIGN KEY([ScoperInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[role_] CHECK CONSTRAINT [FK67A8EA9216BEE2A]
GO
/****** Object: ForeignKey [FK67A8EA9468BE86A] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[role_] WITH CHECK ADD CONSTRAINT [FK67A8EA9468BE86A] FOREIGN KEY([ScoperInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[role_] CHECK CONSTRAINT [FK67A8EA9468BE86A]
GO
/****** Object: ForeignKey [FK67A8EA9ADE744AD] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[role_] WITH CHECK ADD CONSTRAINT [FK67A8EA9ADE744AD] FOREIGN KEY([PlayerInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[role_] CHECK CONSTRAINT [FK67A8EA9ADE744AD]
GO
/****** Object: ForeignKey [FK67A8EA9D3073EED] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[role_] WITH CHECK ADD CONSTRAINT [FK67A8EA9D3073EED] FOREIGN KEY([PlayerInternalId])
REFERENCES [dbo].[entity] ([internalId])
GO
ALTER TABLE [dbo].[role_] CHECK CONSTRAINT [FK67A8EA9D3073EED]
GO
/****** Object: ForeignKey [FK8B70CDFAB42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Role_addr] WITH CHECK ADD CONSTRAINT [FK8B70CDFAB42BD995] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[Role_addr] CHECK CONSTRAINT [FK8B70CDFAB42BD995]
GO
/****** Object: ForeignKey [FK86930C0AB42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Role_confidentialityCode] WITH CHECK ADD CONSTRAINT [FK86930C0AB42BD995] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[Role_confidentialityCode] CHECK CONSTRAINT [FK86930C0AB42BD995]
GO
/****** Object: ForeignKey [FKB54A2D64B42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Role_id] WITH CHECK ADD CONSTRAINT [FKB54A2D64B42BD995] FOREIGN KEY([roleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[Role_id] CHECK CONSTRAINT [FKB54A2D64B42BD995]
GO
/****** Object: ForeignKey [FK8B76AC94B42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Role_name] WITH CHECK ADD CONSTRAINT [FK8B76AC94B42BD995] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[Role_name] CHECK CONSTRAINT [FK8B76AC94B42BD995]
GO
/****** Object: ForeignKey [FKCB694AEEB42BD995] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[Role_telecom] WITH CHECK ADD CONSTRAINT [FKCB694AEEB42BD995] FOREIGN KEY([RoleInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[Role_telecom] CHECK CONSTRAINT [FKCB694AEEB42BD995]
GO
/****** Object: ForeignKey [FKF02705702AB936FA] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[rolelink] WITH CHECK ADD CONSTRAINT [FKF02705702AB936FA] FOREIGN KEY([SourceInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[rolelink] CHECK CONSTRAINT [FKF02705702AB936FA]
GO
/****** Object: ForeignKey [FKF02705702B3B8C30] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[rolelink] WITH CHECK ADD CONSTRAINT [FKF02705702B3B8C30] FOREIGN KEY([TargetInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[rolelink] CHECK CONSTRAINT [FKF02705702B3B8C30]
GO
/****** Object: ForeignKey [FKF0270570501A5E3A] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[rolelink] WITH CHECK ADD CONSTRAINT [FKF0270570501A5E3A] FOREIGN KEY([SourceInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[rolelink] CHECK CONSTRAINT [FKF0270570501A5E3A]
GO
/****** Object: ForeignKey [FKF02705705DA64F0] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[rolelink] WITH CHECK ADD CONSTRAINT [FKF02705705DA64F0] FOREIGN KEY([TargetInternalId])
REFERENCES [dbo].[role_] ([internalId])
GO
ALTER TABLE [dbo].[rolelink] CHECK CONSTRAINT [FKF02705705DA64F0]
GO
/****** Object: ForeignKey [FK215EABED3527D223] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[SubstanceAdministration_approachSiteCode] WITH CHECK ADD CONSTRAINT [FK215EABED3527D223] FOREIGN KEY([SubstanceAdministrationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[SubstanceAdministration_approachSiteCode] CHECK CONSTRAINT [FK215EABED3527D223]
GO
/****** Object: ForeignKey [FKA5A380653527D223] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[SubstanceAdministration_doseCheckQuantity] WITH CHECK ADD CONSTRAINT [FKA5A380653527D223] FOREIGN KEY([SubstanceAdministrationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[SubstanceAdministration_doseCheckQuantity] CHECK CONSTRAINT [FKA5A380653527D223]
GO
/****** Object: ForeignKey [FK1F6822DB3527D223] Script Date: 02/03/2009 15:34:46 ******/
ALTER TABLE [dbo].[SubstanceAdministration_maxDoseQuantity] WITH CHECK ADD CONSTRAINT [FK1F6822DB3527D223] FOREIGN KEY([SubstanceAdministrationInternalId])
REFERENCES [dbo].[Act] ([internalId])
GO
ALTER TABLE [dbo].[SubstanceAdministration_maxDoseQuantity] CHECK CONSTRAINT [FK1F6822DB3527D223]
GO
