USE [DiversityScientificTerms]
GO
/****** Object:  Table [dbo].[TermReference]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TermReference](
	[RepresentationID] [int] NOT NULL,
	[Reference] [nvarchar](255) NOT NULL,
	[ReferenceURI] [varchar](255) NULL,
	[ReferenceDetails] [varchar](255) NULL,
	[InternalNotes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TermReference_1] PRIMARY KEY CLUSTERED 
(
	[RepresentationID] ASC,
	[Reference] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the term, referes to table TermRepresentation, Foreign key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'RepresentationID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A link to e.g. a website containing a description of the terminology or the title of the publication where the collection event was published. Note this is only a cached value where ReferenceURI is present' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'Reference'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of reference where specimen is published, e.g. referring to the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'ReferenceURI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The exact location within the reference, e.g. pages, plates' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'ReferenceDetails'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes about the reference' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A TermReference used in a certain scientifc area, e.g. mineralogy, soil sciences, paleontology, stratigraphy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermReference'
GO
/****** Object:  Table [dbo].[TerminologyPropertyDataType_Enum]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TerminologyPropertyDataType_Enum](
	[Code] [varchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
 CONSTRAINT [PK_TerminologyPropertyDataType] PRIMARY KEY CLUSTERED 
(
	[Code] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The datatype of the property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the datatype' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The display text shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The display order if different from alphabetic order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True if the entry should be displayed, otherwise false' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes for this entry' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyPropertyDataType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
/****** Object:  Table [dbo].[LanguageCode_Enum]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LanguageCode_Enum](
	[Code] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](500) NULL,
	[DisplayText] [nvarchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
 CONSTRAINT [PK_LanguageCode_Enum] PRIMARY KEY CLUSTERED 
(
	[Code] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The 2-letter code of the language according to ISO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the language' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The display text shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The display order if different from alphabetic order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True if the entry should be displayed, otherwise false' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes for this entry' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Code of a language according to ISO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum'
GO
/****** Object:  Table [dbo].[Terminology]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Terminology](
	[TerminologyID] [int] NOT NULL,
	[DisplayText] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](max) NULL,
	[ExternalDatabase] [nvarchar](200) NULL,
	[ExternalDatabaseVersion] [nvarchar](255) NULL,
	[ExternalDatabaseAuthors] [nvarchar](200) NULL,
	[ExternalDatabaseURI] [varchar](255) NULL,
	[ExternalDatabaseInstitution] [nvarchar](300) NULL,
	[ExternalAttribute_NameID] [nvarchar](255) NULL,
	[Rights] [nvarchar](100) NULL,
	[DefaultLanguageCode] [nvarchar](50) NULL,
	[InternalNotes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_ExternalDatabase] PRIMARY KEY CLUSTERED 
(
	[TerminologyID] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An ID to identify an external data collection of scientific terms (primary key, the ID has no meaning outside of the DiversityScientificTerms)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The text for the terminology as shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the terminology' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the data collection that has been integrated or can be linked to for further analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalDatabase'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The version of this data collection (either official version number, or dates when the collection was integrated)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalDatabaseVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The persons or institutions responsible for the external database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalDatabaseAuthors'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the database provider resp. the external database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalDatabaseURI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The institution responsible for the external database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalDatabaseInstitution'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The table and field name in the external data collection to which TaxonNameExternalID refers' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'ExternalAttribute_NameID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Information about rights (copyright, intellectual property) held in and over the database. Enter esp. name of person or institution holding the copyright. Leave empty if unknown.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'Rights'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the default language of the terminology' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'DefaultLanguageCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Additional notes concerning this data collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A terminology used in a certain scientifc area, e.g. mineralogy, soil sciences, paleontology, stratigraphy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Terminology'
GO
/****** Object:  Table [dbo].[TerminologyReference]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TerminologyReference](
	[TerminologyID] [int] NOT NULL,
	[Reference] [nvarchar](255) NOT NULL,
	[ReferenceURI] [varchar](255) NULL,
	[ReferenceDetails] [varchar](255) NULL,
	[InternalNotes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TerminologyReference] PRIMARY KEY CLUSTERED 
(
	[TerminologyID] ASC,
	[Reference] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An ID to identify an external data collection of scientific terms (primary key, the ID has no meaning outside of the DiversityScientificTerms)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A link to e.g. a website containing a description of the terminology or the title of the publication where the collection event was published. Note this is only a cached value where ReferenceURI is present' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'Reference'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of reference where specimen is published, e.g. referring to the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'ReferenceURI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The exact location within the reference, e.g. pages, plates' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'ReferenceDetails'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Additional notes concerning the reference' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A TerminologyReference used in a certain scientifc area, e.g. mineralogy, soil sciences, paleontology, stratigraphy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyReference'
GO
/****** Object:  Table [dbo].[TerminologyProperty]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TerminologyProperty](
	[TerminologyID] [int] NOT NULL,
	[Property] [nvarchar](50) NOT NULL,
	[DisplayText] [nvarchar](50) NULL,
	[Description] [nvarchar](max) NULL,
	[Datatype] [varchar](50) NULL,
	[DisplayOrder] [smallint] NULL,
	[DisplayEnable] [bit] NULL,
	[InternalNotes] [nvarchar](500) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TerminologyProperty] PRIMARY KEY CLUSTERED 
(
	[TerminologyID] ASC,
	[Property] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An ID to identify an external data collection of scientific terms (primary key, the ID has no meaning outside of the DiversityScientificTerms)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'Property'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The text shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The datatype of the property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'Datatype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sequence with which the properties are shown in a user interface if different from alphabetic order' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'DisplayOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True if the property should be shown, otherwise false' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'DisplayEnable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes about this property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'InternalNotes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Properties of scientific terms in a certain terminology, e.g. the specific weight of a mineral in mineralogy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TerminologyProperty'
GO
/****** Object:  Table [dbo].[Term]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Term](
	[TerminologyID] [int] NOT NULL,
	[TermID] [int] IDENTITY(1,1) NOT NULL,
	[BroaderTermID] [int] NULL,
	[RankingTermID] [int] NULL,
	[IsRankingTerm] [bit] NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
	[xx_ExternalID] [nvarchar](50) NULL,
	[xx_DisplayText] [nvarchar](400) NULL,
	[xx_Description] [nvarchar](max) NULL,
	[xx_HierarchyCache] [nvarchar](max) NULL,
 CONSTRAINT [PK_Glossary] PRIMARY KEY CLUSTERED 
(
	[TerminologyID] ASC,
	[TermID] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of an external data collection as defined in ExternalDatabase (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the term, Primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'TermID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the superior dataset within DiversityScientificTerms to which this record belongs to' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'BroaderTermID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the ranking term of the dataset, e.g. Epoch for Paleocene' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'RankingTermID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the term is a ranking term, e.g. epoch in palaeontolgoy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'IsRankingTerm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the entry was retrieved from an external database, a code or number for the entry as defined in the external database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'xx_ExternalID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The label or name of the term in one of the supported languages' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'xx_DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'xx_Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A system generated list defining the hierarchy of the term above the current entry, necessary to distinguish synonymous entries' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term', @level2type=N'COLUMN',@level2name=N'xx_HierarchyCache'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The scientific term within a scientific terminology, e.g. the name of a soil in soil sciences or the name of a mineral in mineralogy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Term'
GO
/****** Object:  Table [dbo].[TermRepresentation]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TermRepresentation](
	[RepresentationID] [int] IDENTITY(1,1) NOT NULL,
	[TerminologyID] [int] NOT NULL,
	[TermID] [int] NOT NULL,
	[DisplayText] [nvarchar](400) NOT NULL,
	[Description] [nvarchar](max) NULL,
	[HierarchyCache] [nvarchar](max) NULL,
	[ExternalID] [nvarchar](50) NULL,
	[Notes] [nvarchar](max) NULL,
	[LanguageCode] [nvarchar](50) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
 CONSTRAINT [PK_TermRepresetation] PRIMARY KEY CLUSTERED 
(
	[RepresentationID] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the representation of a term within DiversityScientificTerms (primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'RepresentationID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the terminology of to which the term belongs (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the term to which the represenation belongs (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'TermID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The label or name of the term as shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'DisplayText'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A system generated list defining the hierarchy of the term above the current entry, necessary to distinguish synonymous entries' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'HierarchyCache'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the entry was retrieved from an external database, a code or number for the entry as defined in the external database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'ExternalID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the language of the property  (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'LanguageCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The representation of a scientific term within a scientific terminology in a certain language, e.g. the name of a soil in soil sciences in english, german or russian' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermRepresentation'
GO
/****** Object:  Table [dbo].[TermProperty]    Script Date: 04/23/2010 11:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TermProperty](
	[TerminologyID] [int] NOT NULL,
	[TermID] [int] NOT NULL,
	[Property] [nvarchar](50) NOT NULL,
	[TextValue] [nvarchar](500) NULL,
	[NumericValue] [float] NULL,
	[DateValue] [datetime] NULL,
	[Notes] [nvarchar](max) NULL,
	[LogInsertedBy] [nvarchar](50) NULL,
	[LogInsertedWhen] [smalldatetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
	[LogUpdatedWhen] [smalldatetime] NULL,
	[xx_Value] [sql_variant] NULL,
 CONSTRAINT [PK_GlossaryProperties] PRIMARY KEY CLUSTERED 
(
	[TerminologyID] ASC,
	[TermID] ASC,
	[Property] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An ID to identify an external data collection of terms (primary key, the ID has no meaning outside of the DiversityScientificTerms)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'TerminologyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the term, referes to table Term, Foreign key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'TermID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The property as defined in table TermiologyProperty, Foreign key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'Property'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The text if the value is a text value' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'TextValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The numeric value if the value is numeric' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'NumericValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date if the value is a date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'DateValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the property entry' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'LogInsertedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was first entered (typed or imported) into this system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'LogInsertedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when record was last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The value of the property' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty', @level2type=N'COLUMN',@level2name=N'xx_Value'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The property of a scientific term, e.g. the specific weight of a certain mineral in mineralogy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TermProperty'
GO
/****** Object:  Default [DF_Term_IsRankingTerm]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term] ADD  CONSTRAINT [DF_Term_IsRankingTerm]  DEFAULT ((0)) FOR [IsRankingTerm]
GO
/****** Object:  Default [DF_Term_LogInsertedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term] ADD  CONSTRAINT [DF_Term_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_Term_LogInsertedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term] ADD  CONSTRAINT [DF_Term_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_Term_LogUpdatedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term] ADD  CONSTRAINT [DF_Term_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_Term_LogUpdatedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term] ADD  CONSTRAINT [DF_Term_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_Terminology_LanguageCode]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology] ADD  CONSTRAINT [DF_Terminology_LanguageCode]  DEFAULT (N'en') FOR [DefaultLanguageCode]
GO
/****** Object:  Default [DF_Terminology_LogInsertedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology] ADD  CONSTRAINT [DF_Terminology_LogInsertedBy_1]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_Terminology_LogInsertedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology] ADD  CONSTRAINT [DF_Terminology_LogInsertedWhen_1]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_Terminology_LogUpdatedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology] ADD  CONSTRAINT [DF_Terminology_LogUpdatedBy_1]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_Terminology_LogUpdatedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology] ADD  CONSTRAINT [DF_Terminology_LogUpdatedWhen_1]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TerminologyProperty_LogInsertedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty] ADD  CONSTRAINT [DF_TerminologyProperty_LogInsertedBy_1]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TerminologyProperty_LogInsertedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty] ADD  CONSTRAINT [DF_TerminologyProperty_LogInsertedWhen_1]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TerminologyProperty_LogUpdatedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty] ADD  CONSTRAINT [DF_TerminologyProperty_LogUpdatedBy_1]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TerminologyProperty_LogUpdatedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty] ADD  CONSTRAINT [DF_TerminologyProperty_LogUpdatedWhen_1]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TerminologyReference_LogInsertedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyReference] ADD  CONSTRAINT [DF_TerminologyReference_LogInsertedBy_1]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TerminologyReference_LogInsertedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyReference] ADD  CONSTRAINT [DF_TerminologyReference_LogInsertedWhen_1]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TerminologyReference_LogUpdatedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyReference] ADD  CONSTRAINT [DF_TerminologyReference_LogUpdatedBy_1]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TerminologyReference_LogUpdatedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyReference] ADD  CONSTRAINT [DF_TerminologyReference_LogUpdatedWhen_1]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TermProperty_LogInsertedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty] ADD  CONSTRAINT [DF_TermProperty_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TermProperty_LogInsertedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty] ADD  CONSTRAINT [DF_TermProperty_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TermProperty_LogUpdatedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty] ADD  CONSTRAINT [DF_TermProperty_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TermProperty_LogUpdatedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty] ADD  CONSTRAINT [DF_TermProperty_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TermReference_LogInsertedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermReference] ADD  CONSTRAINT [DF_TermReference_LogInsertedBy_1]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TermReference_LogInsertedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermReference] ADD  CONSTRAINT [DF_TermReference_LogInsertedWhen_1]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TermReference_LogUpdatedBy_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermReference] ADD  CONSTRAINT [DF_TermReference_LogUpdatedBy_1]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TermReference_LogUpdatedWhen_1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermReference] ADD  CONSTRAINT [DF_TermReference_LogUpdatedWhen_1]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  Default [DF_TermRepresetation_LanguageCode]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation] ADD  CONSTRAINT [DF_TermRepresetation_LanguageCode]  DEFAULT (N'en') FOR [LanguageCode]
GO
/****** Object:  Default [DF_TermRepresetation_LogInsertedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation] ADD  CONSTRAINT [DF_TermRepresetation_LogInsertedBy]  DEFAULT (user_name()) FOR [LogInsertedBy]
GO
/****** Object:  Default [DF_TermRepresetation_LogInsertedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation] ADD  CONSTRAINT [DF_TermRepresetation_LogInsertedWhen]  DEFAULT (getdate()) FOR [LogInsertedWhen]
GO
/****** Object:  Default [DF_TermRepresetation_LogUpdatedBy]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation] ADD  CONSTRAINT [DF_TermRepresetation_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
/****** Object:  Default [DF_TermRepresetation_LogUpdatedWhen]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation] ADD  CONSTRAINT [DF_TermRepresetation_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
/****** Object:  ForeignKey [FK_Glossary_ExternalDatabase]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term]  WITH CHECK ADD  CONSTRAINT [FK_Glossary_ExternalDatabase] FOREIGN KEY([TerminologyID])
REFERENCES [dbo].[Terminology] ([TerminologyID])
GO
ALTER TABLE [dbo].[Term] CHECK CONSTRAINT [FK_Glossary_ExternalDatabase]
GO
/****** Object:  ForeignKey [FK_Term_Term]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term]  WITH CHECK ADD  CONSTRAINT [FK_Term_Term] FOREIGN KEY([TerminologyID], [BroaderTermID])
REFERENCES [dbo].[Term] ([TerminologyID], [TermID])
GO
ALTER TABLE [dbo].[Term] CHECK CONSTRAINT [FK_Term_Term]
GO
/****** Object:  ForeignKey [FK_Term_Term1]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Term]  WITH CHECK ADD  CONSTRAINT [FK_Term_Term1] FOREIGN KEY([TerminologyID], [RankingTermID])
REFERENCES [dbo].[Term] ([TerminologyID], [TermID])
GO
ALTER TABLE [dbo].[Term] CHECK CONSTRAINT [FK_Term_Term1]
GO
/****** Object:  ForeignKey [FK_Terminology_LanguageCode_Enum]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[Terminology]  WITH CHECK ADD  CONSTRAINT [FK_Terminology_LanguageCode_Enum] FOREIGN KEY([DefaultLanguageCode])
REFERENCES [dbo].[LanguageCode_Enum] ([Code])
GO
ALTER TABLE [dbo].[Terminology] CHECK CONSTRAINT [FK_Terminology_LanguageCode_Enum]
GO
/****** Object:  ForeignKey [FK_TerminologyProperty_Terminology]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty]  WITH CHECK ADD  CONSTRAINT [FK_TerminologyProperty_Terminology] FOREIGN KEY([TerminologyID])
REFERENCES [dbo].[Terminology] ([TerminologyID])
GO
ALTER TABLE [dbo].[TerminologyProperty] CHECK CONSTRAINT [FK_TerminologyProperty_Terminology]
GO
/****** Object:  ForeignKey [FK_TerminologyProperty_TerminologyPropertyDataType_Enum]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyProperty]  WITH CHECK ADD  CONSTRAINT [FK_TerminologyProperty_TerminologyPropertyDataType_Enum] FOREIGN KEY([Datatype])
REFERENCES [dbo].[TerminologyPropertyDataType_Enum] ([Code])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TerminologyProperty] CHECK CONSTRAINT [FK_TerminologyProperty_TerminologyPropertyDataType_Enum]
GO
/****** Object:  ForeignKey [FK_TerminologyReference_Terminology]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TerminologyReference]  WITH CHECK ADD  CONSTRAINT [FK_TerminologyReference_Terminology] FOREIGN KEY([TerminologyID])
REFERENCES [dbo].[Terminology] ([TerminologyID])
GO
ALTER TABLE [dbo].[TerminologyReference] CHECK CONSTRAINT [FK_TerminologyReference_Terminology]
GO
/****** Object:  ForeignKey [FK_TermProperty_Term]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty]  WITH CHECK ADD  CONSTRAINT [FK_TermProperty_Term] FOREIGN KEY([TerminologyID], [TermID])
REFERENCES [dbo].[Term] ([TerminologyID], [TermID])
GO
ALTER TABLE [dbo].[TermProperty] CHECK CONSTRAINT [FK_TermProperty_Term]
GO
/****** Object:  ForeignKey [FK_TermProperty_TerminologyProperty]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermProperty]  WITH CHECK ADD  CONSTRAINT [FK_TermProperty_TerminologyProperty] FOREIGN KEY([TerminologyID], [Property])
REFERENCES [dbo].[TerminologyProperty] ([TerminologyID], [Property])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TermProperty] CHECK CONSTRAINT [FK_TermProperty_TerminologyProperty]
GO
/****** Object:  ForeignKey [FK_TermReference_TermRepresentation]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermReference]  WITH CHECK ADD  CONSTRAINT [FK_TermReference_TermRepresentation] FOREIGN KEY([RepresentationID])
REFERENCES [dbo].[TermRepresentation] ([RepresentationID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[TermReference] CHECK CONSTRAINT [FK_TermReference_TermRepresentation]
GO
/****** Object:  ForeignKey [FK_TermRepresentation_LanguageCode_Enum]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation]  WITH CHECK ADD  CONSTRAINT [FK_TermRepresentation_LanguageCode_Enum] FOREIGN KEY([LanguageCode])
REFERENCES [dbo].[LanguageCode_Enum] ([Code])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TermRepresentation] CHECK CONSTRAINT [FK_TermRepresentation_LanguageCode_Enum]
GO
/****** Object:  ForeignKey [FK_TermRepresetation_Term]    Script Date: 04/23/2010 11:02:57 ******/
ALTER TABLE [dbo].[TermRepresentation]  WITH CHECK ADD  CONSTRAINT [FK_TermRepresetation_Term] FOREIGN KEY([TerminologyID], [TermID])
REFERENCES [dbo].[Term] ([TerminologyID], [TermID])
GO
ALTER TABLE [dbo].[TermRepresentation] CHECK CONSTRAINT [FK_TermRepresetation_Term]
GO