/****** Objekt: Table [dbo].[Processing] Skriptdatum: 11/01/2007 10:13:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Processing]( [ProcessingID] [int] IDENTITY(1,1) NOT NULL, [ProcessingParentID] [int] NULL, [DisplayText] [nvarchar](50) NULL, [Description] [nvarchar](max) NULL, [Notes] [nvarchar](max) NULL, [ProcessingURI] [varchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionProcessing_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionProcessing_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionProcessing_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionProcessing_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionProcessing] PRIMARY KEY CLUSTERED ( [ProcessingID] 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 processing (Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'ProcessingID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the superior type of the processing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'ProcessingParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The display text of the processing as shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the processing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the processing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An URI for a processing as defined in an external datasource' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'ProcessingURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The processings of the specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Processing' GO /****** Objekt: Table [dbo].[CollTaxonomicGroup_Enum] Skriptdatum: 11/01/2007 10:11:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollTaxonomicGroup_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollectionTaxonomicGroups] PRIMARY KEY CLUSTERED ( [Code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The taxonomic groups of the organisms' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTaxonomicGroup_Enum' GO /****** Objekt: Table [dbo].[CollDateCategory_Enum] Skriptdatum: 11/01/2007 10:07:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollDateCategory_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_IdentificationDateCategory_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The categories for the collection date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollDateCategory_Enum' GO /****** Objekt: Table [dbo].[MeasurementUnit_Enum] Skriptdatum: 11/01/2007 10:13:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MeasurementUnit_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_MeasurementUnit] 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'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The measurement units, e.g. m' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MeasurementUnit_Enum' GO /****** Objekt: Table [dbo].[CollTransactionType_Enum] Skriptdatum: 11/01/2007 10:11:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollTransactionType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollTransactionType_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'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The types of the transactions of the specimen, e.g. loan, exchange' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTransactionType_Enum' GO /****** Objekt: Table [dbo].[CollEventDateCategory_Enum] Skriptdatum: 11/01/2007 10:10:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollEventDateCategory_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollEventDateCategory_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The categoies of the collection date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventDateCategory_Enum' GO /****** Objekt: Table [dbo].[CollEventImageType_Enum] Skriptdatum: 11/01/2007 10:10:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollEventImageType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollEventImageType_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The types of the images taken from a collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollEventImageType_Enum' GO /****** Objekt: Table [dbo].[CollExchangeType_Enum] Skriptdatum: 11/01/2007 10:11:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollExchangeType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollExchangeType_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollExchangeType_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO /****** Objekt: Table [dbo].[CollIdentificationCategory_Enum] Skriptdatum: 11/01/2007 10:11:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollIdentificationCategory_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_IdentificationCategory_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The categories of an identification, e.g. determination, confirmation etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationCategory_Enum' GO /****** Objekt: Table [dbo].[CollIdentificationQualifier_Enum] Skriptdatum: 11/01/2007 10:11:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollIdentificationQualifier_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_IdentificationQualifier_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The identification qualifiers, e.g. cf. spec., s.l. etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationQualifier_Enum' GO /****** Objekt: Table [dbo].[CollIdentificationDateCategory_Enum] Skriptdatum: 11/01/2007 10:11:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollIdentificationDateCategory_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollDateCategory_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The categories of the identification date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollIdentificationDateCategory_Enum' GO /****** Objekt: Table [dbo].[CollLabelTranscriptionState_Enum] Skriptdatum: 11/01/2007 10:11:28 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollLabelTranscriptionState_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollLabelTranscritionState_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The states of the transcription of a label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelTranscriptionState_Enum' GO /****** Objekt: Table [dbo].[CollLabelType_Enum] Skriptdatum: 11/01/2007 10:11:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollLabelType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollLabelType_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The types of a label, e.g. handwritten, typed etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollLabelType_Enum' GO /****** Objekt: Table [dbo].[CollSpecimenRelationType_Enum] Skriptdatum: 11/01/2007 10:11:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollSpecimenRelationType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollSpecimenRelationType_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'Types of the relation between specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenRelationType_Enum' GO /****** Objekt: Table [dbo].[CollMaterialCategory_Enum] Skriptdatum: 11/01/2007 10:11:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollMaterialCategory_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollMaterialType_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The material categories of the specimen, e.g. slide, culture etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollMaterialCategory_Enum' GO /****** Objekt: Table [dbo].[CollUnitRelationType_Enum] Skriptdatum: 11/01/2007 10:12:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollUnitRelationType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollUnitRelationType_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 type of relation between organisms within one specimen, e.g. Growing on' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollUnitRelationType_Enum' GO /****** Objekt: Table [dbo].[CollSpecimenImageType_Enum] Skriptdatum: 11/01/2007 10:11:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollSpecimenImageType_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollImageType_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The type of an image of a specimen, e.g. label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollSpecimenImageType_Enum' GO /****** Objekt: Table [dbo].[CollTypeStatus_Enum] Skriptdatum: 11/01/2007 10:12:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollTypeStatus_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollTypeStatus_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, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The type stati of the identifications, e.g. Isotype' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollTypeStatus_Enum' GO /****** Objekt: Table [dbo].[CollectionEventSeries] Skriptdatum: 11/01/2007 10:09:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollectionEventSeries]( [SeriesID] [int] IDENTITY(-1,-1) NOT NULL, [SeriesParentID] [int] NULL, [Description] [nvarchar](max) NOT NULL, [SeriesCode] [nvarchar](50) NULL, [Notes] [nvarchar](max) NULL, [DateCache] [datetime] NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventSeries_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventSeries_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventSeries_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventSeries_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionEventSeries] PRIMARY KEY CLUSTERED ( [SeriesID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. The ID for this expedition (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'SeriesID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the superior expedition' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'SeriesParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the expedition as it will be printed on e.g. the label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The user defined code for an expedition' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'SeriesCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about this expedition' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The first date of the depending events, used for sorting the expeditions [controlled by the database]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'DateCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The series whithin which collection events take place' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventSeries' GO /****** Objekt: Table [dbo].[Collection] Skriptdatum: 11/01/2007 10:08:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Collection]( [CollectionID] [int] IDENTITY(1,1) NOT NULL, [CollectionParentID] [int] NULL, [CollectionName] [nvarchar](255) NOT NULL, [CollectionAcronym] [nvarchar](10) NULL, [AdministrativeContactName] [nvarchar](255) NULL, [AdministrativeContactAgentURI] [varchar](255) NULL CONSTRAINT [DF_Collection_AgentID] DEFAULT ((0)), [Description] [nvarchar](max) NULL, [Location] [nvarchar](255) NULL, [CollectionOwner] [nvarchar](255) NULL, [DisplayOrder] [smallint] NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_Collection_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Collection_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_Collection_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Collection_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_Collection] PRIMARY KEY CLUSTERED ( [CollectionID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique reference ID for the collection (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'CollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'For a subcollection within another collection: CollectionID of the collection to which the subcollection belongs. Empty for an independent collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'CollectionParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the collection (e. g. ''Herbarium Kew'') or subcollection (e. g. ''cone collection'', ''alcohol preservations''). This text should be kept relatively short, use Description for additional information' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'CollectionName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A unique code for the Collection, e.g. the herbarium code from Index Herbariorum' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'CollectionAcronym' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the person or organisation responsible for this collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'AdministrativeContactName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the person or organisation responsible for the Collection e.g. as provided by the module DiversityAgents' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'AdministrativeContactAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A short description of the collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optionally location of the collection, e.g. the number within a file system or a description of the room(s) housing the (sub)collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'Location' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The owner of the collection as e.g. printed on a label, should be given if CollectionParentID is null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'CollectionOwner' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'Caption', @value=N'Definition of independent collections and a tree of subcollections (subcollections may contain subcollections).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The collections where the specimen are stored' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collection' GO /****** Objekt: Table [dbo].[ProjectProxy] Skriptdatum: 11/01/2007 10:13:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProjectProxy]( [ProjectID] [int] NOT NULL, [Project] [nvarchar](50) NULL, CONSTRAINT [PK_DiversityProjectProxy] PRIMARY KEY CLUSTERED ( [ProjectID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProjectProxy', @level2type=N'COLUMN',@level2name=N'ProjectID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name or title of the project as shown in a user interface (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProjectProxy', @level2type=N'COLUMN',@level2name=N'Project' GO /****** Objekt: Table [dbo].[LanguageCode_Enum] Skriptdatum: 11/01/2007 10:13:17 ******/ 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, [ParentCode] [nvarchar](50) 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 codes for the languages' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LanguageCode_Enum' GO /****** Objekt: Table [dbo].[CollCircumstances_Enum] Skriptdatum: 11/01/2007 10:07:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollCircumstances_Enum]( [Code] [nvarchar](50) NOT NULL, [Description] [nvarchar](500) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayOrder] [smallint] NULL, [DisplayEnable] [bit] NULL, [InternalNotes] [nvarchar](500) NULL, [ParentCode] [nvarchar](50) NULL, CONSTRAINT [PK_CollCircumstances_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'A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of enumerated object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the object, displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal development notes about usage, definition, etc. of an enumerated object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The code of the superior entry, if a hierarchy within the entries is necessary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Circumstances of the occurence of the organisms' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollCircumstances_Enum' GO /****** Objekt: Table [dbo].[UserProxy] Skriptdatum: 11/01/2007 10:14:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[UserProxy]( [LoginName] [nvarchar](50) NOT NULL, [CombinedNameCache] [nvarchar](255) NOT NULL CONSTRAINT [DF_UserProxy_InheritedName] DEFAULT (NULL), [UserURI] [varchar](255) NULL, CONSTRAINT [PK_UserProxy] PRIMARY KEY CLUSTERED ( [LoginName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc..' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserProxy', @level2type=N'COLUMN',@level2name=N'LoginName' GO EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserProxy', @level2type=N'COLUMN',@level2name=N'LoginName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserProxy', @level2type=N'COLUMN',@level2name=N'LoginName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The short name of the user, e.g. P. Smith' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserProxy', @level2type=N'COLUMN',@level2name=N'CombinedNameCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of a user in a remote module, e.g. refering to UserInfo.UserID in database DiversityUsers' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserProxy', @level2type=N'COLUMN',@level2name=N'UserURI' GO /****** Objekt: Table [dbo].[LocalisationSystem] Skriptdatum: 11/01/2007 10:13:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LocalisationSystem]( [LocalisationSystemID] [int] NOT NULL, [LocalisationSystemParentID] [int] NULL, [LocalisationSystemName] [nvarchar](100) NOT NULL, [DefaultAccuracyOfLocalisation] [nvarchar](50) NULL, [DefaultMeasurementUnit] [nvarchar](50) NULL, [ParsingMethodName] [nvarchar](50) NULL, [DisplayText] [nvarchar](50) NULL, [DisplayEnable] [bit] NULL, [DisplayOrder] [smallint] NULL, [Description] [nvarchar](255) NULL, [DisplayTextLocation1] [nvarchar](50) NULL, [DescriptionLocation1] [nvarchar](255) NULL, [DisplayTextLocation2] [nvarchar](50) NULL, [DescriptionLocation2] [nvarchar](255) NULL, [xx_DiversityModule] [nvarchar](50) NULL, [xx_ParsingMethod] [nvarchar](500) NULL, [xx_MeasurementUnit] [nvarchar](100) NULL, [xx_DefaultMeasurementUnit1] [nvarchar](50) NULL, CONSTRAINT [PK_LocalisationSystem_1] PRIMARY KEY CLUSTERED ( [LocalisationSystemID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique ID for the localisation system (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'LocalisationSystemID of the superior LocalisationSystem' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemName' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemName' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the system used for the determination of the place of the collection, e. g. Gauss-Krüger, MTB, GIS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'LocalisationSystemName' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DefaultAccuracyOfLocalisation' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DefaultAccuracyOfLocalisation' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DefaultAccuracyOfLocalisation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The default for the accuracy of values that can be reached with this method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DefaultAccuracyOfLocalisation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The default measurement unit for the localisation system, e.g. m, geograpic coordinates' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DefaultMeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionLocalisation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'ParsingMethodName' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the localisation system as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Specifies if this item is enabled to be used within the database. LocalisationSystems can be disabled to avoid seeing them, but to keep the definition for the future.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayEnable' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the localisation method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=3915 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the attribute Location1 in the table CollectionGeography as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=1620 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the attribute Location1 in the table CollectionGeography as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation1' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the attribute Location2 in the table CollectionGeography as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DisplayTextLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=1485 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the attribute Location2 in the table CollectionGeography as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'DescriptionLocation2' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_DiversityModule' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_DiversityModule' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_DiversityModule' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The module or component of the DiversityWorkbench, the localisation system is related to.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_DiversityModule' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_ParsingMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_ParsingMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_ParsingMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionGeography' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_ParsingMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_MeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_MeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=65535 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_MeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Measurement unit used within the localisation system, e.g. m, miles etc. Metric units should be preferred.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem', @level2type=N'COLUMN',@level2name=N'xx_MeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The geographic localisation systems, e.g. coordinates' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_Filter', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_OrderBy', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO EXEC sys.sp_addextendedproperty @name=N'MS_TableMaxRecords', @value=10000 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LocalisationSystem' GO /****** Objekt: Table [dbo].[Property] Skriptdatum: 11/01/2007 10:14:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Property]( [PropertyID] [int] NOT NULL, [PropertyParentID] [int] NULL, [PropertyName] [nvarchar](100) NOT NULL, [DefaultAccuracyOfProperty] [nvarchar](50) NULL, [DefaultMeasurementUnit] [nvarchar](50) NULL, [ParsingMethodName] [nvarchar](50) NOT NULL, [DisplayText] [nvarchar](50) NULL, [DisplayEnabled] [bit] NULL, [DisplayOrder] [smallint] NULL, [Description] [nvarchar](255) NULL, CONSTRAINT [PK_Descriptor] PRIMARY KEY CLUSTERED ( [PropertyID] 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'Unique ID for the localisation system (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'PropertyID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'LocalisationSystemID of the superior LocalisationSystem' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'PropertyParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the system used for the determination of the place of the collection, e. g. Gauss-Krüger, MTB, GIS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'PropertyName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The default for the accuracy of values that can be reached with this method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'DefaultAccuracyOfProperty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionLocalisation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'ParsingMethodName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Short abbreviated description of the localisation system as displayed in the user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Specifies if this item is enabled to be used within the database. LocalisationSystems can be disabled to avoid seeing them, but to keep the definition for the future.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'DisplayEnabled' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the localisation method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The list of the properties that can be specified for the collection site' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Property' GO /****** Objekt: Table [dbo].[Analysis] Skriptdatum: 11/01/2007 10:07:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Analysis]( [AnalysisID] [int] IDENTITY(1,1) NOT NULL, [AnalysisParentID] [int] NULL, [DisplayText] [nvarchar](50) NULL, [Description] [nvarchar](max) NULL, [MeasurementUnit] [nvarchar](50) NULL, [Notes] [nvarchar](max) NULL, [AnalysisURI] [varchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_Analysis_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Analysis_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_Analysis_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Analysis_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_IdentificationAnalysis] PRIMARY KEY CLUSTERED ( [AnalysisID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the analysis (Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'AnalysisID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Analysis ID of the parent analysis if it belongs to a certain type documented in this table' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'AnalysisParentID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the analysis as e.g. shown in user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The measurement unit used for the analysis, e.g. mm, µmol, kg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'MeasurementUnit' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes concerning this analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI referring to an external documentation of the analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'AnalysisURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Analysis types used within the database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Analysis' GO /****** Objekt: Table [dbo].[CollectionSpecimenRelation] Skriptdatum: 11/01/2007 10:10:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionSpecimenRelation]( [CollectionSpecimenID] [int] NOT NULL, [RelatedSpecimenURI] [varchar](255) NOT NULL, [RelatedSpecimenDisplayText] [varchar](255) NOT NULL, [RelationType] [nvarchar](50) NULL, [RelatedSpecimenCollectionID] [int] NULL, [RelatedSpecimenDescription] [nvarchar](max) NULL, [Notes] [nvarchar](max) NULL, [IsInternalRelationCache] [bit] NOT NULL CONSTRAINT [DF_CollectionSpecimenRelation_IsInternalRelationCache] DEFAULT ((1)), [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenRelation_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenRelation_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenRelation_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenRelation_LogUpdatedBy] DEFAULT (user_name()), [xx_ExchangeID] [int] NULL, [xx_ExternalAgentName] [nvarchar](255) NULL, [xx_ExternalAgentURI] [varchar](255) NULL, CONSTRAINT [PK_CollectionSpecimenRelation] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [RelatedSpecimenURI] 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'Unique reference ID for the collection specimen record (primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the related specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'RelatedSpecimenURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of a related specimen as shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'RelatedSpecimenDisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Type of the relation between the specimen (= foreign key, see table CollRelationType_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'RelationType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the Collection as stored in table Collection (= foreign key, see table Collection)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'RelatedSpecimenCollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the related specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'RelatedSpecimenDescription' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes on the relation to the specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the relation represents a connection between specimen in this database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'IsInternalRelationCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionEchange (= Foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'xx_ExchangeID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution involved in the exchange' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'xx_ExternalAgentName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the person, team or organisation responsible for the data (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation', @level2type=N'COLUMN',@level2name=N'xx_ExternalAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The relations of a collection specimen to other collection specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenRelation' GO /****** Objekt: Table [dbo].[CollectionSpecimenImage] Skriptdatum: 11/01/2007 10:10:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionSpecimenImage]( [CollectionSpecimenID] [int] NOT NULL, [URI] [varchar](255) NOT NULL, [ResourceURI] [varchar](255) NULL, [SpecimenPartID] [int] NULL, [IdentificationUnitID] [int] NULL, [ImageType] [nvarchar](50) NULL, [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenImage_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenImage_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenImage_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenImage_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionSpecimenImage] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [URI] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'URI' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'URI' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=4125 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'URI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'URI' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the image, e.g. as stored in the module DiversityResources. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optional: If the dataset is not related to a part of a specimen, the ID of a related part (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If image refers to only on out of several identification units for a specimen, refers to the ID of an IdentificationUnit for a CollectionSpecimen (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ImageType' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ImageType' GO EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ImageType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Type of the image, e.g. label' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'ImageType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the specimen image' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=0x02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The images of a collection specimen or of an identification unit within this specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_Filter', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_OrderBy', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=False , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=0x00 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO EXEC sys.sp_addextendedproperty @name=N'MS_TableMaxRecords', @value=10000 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenImage' GO /****** Objekt: Table [dbo].[CollectionAgent] Skriptdatum: 11/01/2007 10:08:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionAgent]( [CollectionSpecimenID] [int] NOT NULL, [CollectorsName] [nvarchar](255) NOT NULL, [CollectorsAgentURI] [varchar](255) NULL, [CollectorsSequence] [datetime] NULL CONSTRAINT [DF_CollectionAgent2_CollectorsSequence] DEFAULT (getdate()), [CollectorsNumber] [nvarchar](50) NULL, [Notes] [nvarchar](max) NULL, [DataWithholdingReason] [nvarchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionAgent_LogCreatedWhen_1] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionAgent_LogCreatedBy_1] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionAgent_LogUpdatedWhen_1] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionAgent_LogUpdatedBy_1] DEFAULT (user_name()), [xx_IsAvailable] [bit] NOT NULL CONSTRAINT [DF_CollectionAgent_IsAvailable] DEFAULT ((1)), CONSTRAINT [PK_CollectionAgent2] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [CollectorsName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to ID of CollectionEvent (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the Collector' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'CollectorsName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the Agent, e.g. as stored within the module DiversityAgents' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'CollectorsAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The order of collectors in a team. Automatically set by the database system' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'CollectorsSequence' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number assigned to a specimen or a batch of specimens by the collector during the collection event (= ''field number'')' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'CollectorsNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the collector, e.g. if the name is uncertain' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is withhold, the reason for withholding the data, otherwise null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'DataWithholdingReason' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is available resp. if the data can be published e.g. in the internet' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent', @level2type=N'COLUMN',@level2name=N'xx_IsAvailable' GO EXEC sys.sp_addextendedproperty @name=N'Caption', @value=N'The collector(s) of collection specimens' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The collector(s) of collection specimens' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionAgent' GO /****** Objekt: Table [dbo].[CollectionSpecimenPart] Skriptdatum: 11/01/2007 10:10:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollectionSpecimenPart]( [CollectionSpecimenID] [int] NOT NULL, [SpecimenPartID] [int] NOT NULL, [DerivedFromSpecimenPartID] [int] NULL, [PreparationMethod] [nvarchar](max) NULL, [PreparationDate] [datetime] NULL, [AccessionNumber] [nvarchar](50) NULL, [PartSublabel] [nvarchar](50) NULL, [CollectionID] [int] NOT NULL, [MaterialCategory] [nvarchar](50) NOT NULL CONSTRAINT [DF_CollectionSpecimenPart_MaterialCategory] DEFAULT (N'specimen'), [StorageLocation] [nvarchar](255) NULL, [Stock] [tinyint] NULL, [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenPart_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenPart_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenPart_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenPart_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionSpecimenPart] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [SpecimenPartID] 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'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID for a part of a specimen (part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SpecimenPartID of the specimen from which the current specimen is derived from' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'DerivedFromSpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The method used for the preparation of the part of the specimen, e.g. the inoculation method for cultures' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'PreparationMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date and time when the part was preparated e.g when it was separated from the source object' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'PreparationDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Accession number of the part of the specimen within the collection if it is different from the accession number of the specimen as stored in the table CollectionSpecimen, e.g. "M-29834752"' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'AccessionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The label for a part of a specimen, e.g. if duplicats of a specimen have a separate number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'PartSublabel' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the Collection as stored in table Collection (= foreign key, see table Collection)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'CollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Material category of specimen. Examples: ''herbarium sheets'', ''drawings'', ''microscopic slides'' etc. (= foreign key, see table CollMaterialCategory_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'MaterialCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A code identifying the place where the specimen is stored within the collection. Frequently the accepted scientific name is used as storage location code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'StorageLocation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of stock units if the specimen is stored in separated units e.g. several boxes or vessels' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'Stock' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes concerning the storage of the sample' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Parts of a collection specimen. Includes a possible hierarchy of the parts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenPart' GO /****** Objekt: Table [dbo].[CollectionProject] Skriptdatum: 11/01/2007 10:09:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollectionProject]( [CollectionSpecimenID] [int] NOT NULL, [ProjectID] [int] NOT NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionProject_LogCreatedWhen_1] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionProject_LogCreatedBy_1] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionProject_LogUpdatedWhen_1] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionProject_LogUpdatedBy_1] DEFAULT (user_name()), CONSTRAINT [PK_CollectionProject] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [ProjectID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'ProjectID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The projects within which the collection specimen were placed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionProject' GO /****** Objekt: Table [dbo].[IdentificationUnit] Skriptdatum: 11/01/2007 10:12:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IdentificationUnit]( [CollectionSpecimenID] [int] NOT NULL, [IdentificationUnitID] [int] IDENTITY(1,1) NOT NULL, [LastIdentificationCache] [nvarchar](255) NOT NULL, [FamilyCache] [nvarchar](255) NULL, [OrderCache] [nvarchar](255) NULL, [TaxonomicGroup] [nvarchar](50) NOT NULL, [OnlyObserved] [bit] NULL CONSTRAINT [DF_IdentificationUnit_OnlyObserved] DEFAULT ((0)), [RelatedUnitID] [int] NULL, [RelationType] [nvarchar](50) NULL, [ColonisedSubstratePart] [nvarchar](255) NULL, [LifeStage] [nvarchar](255) NULL, [Gender] [nvarchar](50) NULL, [NumberOfUnits] [smallint] NULL, [ExsiccataNumber] [nvarchar](50) NULL, [ExsiccataIdentification] [smallint] NULL, [Circumstances] [nvarchar](50) NULL, [DisplayOrder] [smallint] NOT NULL CONSTRAINT [DF_IdentificationUnit_DisplayOrder] DEFAULT ((1)), [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_IdentificationUnit_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnit_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_IdentificationUnit_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnit_LogUpdatedBy] DEFAULT (user_name()), [xx_SubstrateID] [int] NULL, [xx_SubstrateRelationType] [nvarchar](50) NULL, [xx_SpecimenPartID] [int] NULL, [xx_NewUnitID] [int] NULL, [xx_AlteUnitID] [int] NULL, CONSTRAINT [PK_IdentificationUnit] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [IdentificationUnitID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the identification unit (= part of Primary key). Usually one of possibly several organisms present on the collection specimen. Example: parasite with hyperparasite on plant leaf = 3 units,' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last identification as entered in table Identification' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LastIdentificationCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A cached value of the family of the taxon of the last identification. Can be set by the editor if NameURI in table Identification is NULL, otherwise set by the system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'FamilyCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A cached value of the order of the taxon of the last identification. Can be set by the editor if NameURI in table Identification is NULL, otherwise set by the system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'OrderCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Taxonomic group the organism identified by this unit belongs to. Groups listed in table CollTaxonomicGroup_Enum (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'TaxonomicGroup' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True if the organism was only observed rather than collected. It is therefore not present on the preserved specimen. Example: Tree under which the collected mycorrhizal fungus grew.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'OnlyObserved' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The IdentificationUnitID of the organism or substrate, on which this organism is growing (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'RelatedUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The relation of an unit to its substrate, e.g. parasitism, symbiosis etc. as stored in CollRelationType_Enum (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'RelationType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If a substrate association exists: part of the substrate that is affected in the interaction (e.g. ''leaves'' if a fungus is growing on the leaves of an infected plant)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'ColonisedSubstratePart' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Examples: ''II, III'' for spore generations of rusts or ''seed'', ''seedling'' etc. for higher plants' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LifeStage' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The gender of the identification unit, e.g. ''male''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'Gender' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of units of this identification unit, e.g. 400 beetle in a bottle' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'NumberOfUnits' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If specimen is an exsiccata: Number of current specimen within the exsiccata series' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'ExsiccataNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the IdentificationSequence in Identification (= foreign key). The name under which the collection specimen resp. this unit is published within an exsiccate.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'ExsiccataIdentification' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Circumstances of the occurence of the organism' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'Circumstances' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sequence in which the units within this specimen will appear on e.g. a label where the first unit may be printed in the header and others in the text below. 0 means the unit should not appear on a label.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Further information on the identification unit or interaction, e. g. infection symptoms like ''producing galls''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The IdentificationUnitID of the organism or substrate, on which this organism is growing (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'xx_SubstrateID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The relation of an unit to its substrate, e.g. parasitism, symbiosis etc. as stored in CollRelationType_Enum (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'xx_SubstrateRelationType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the part of a specimen (optional, Foreign key) if the identification unit is located on a part of the specimen (see table CollectionSpecimenPart).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit', @level2type=N'COLUMN',@level2name=N'xx_SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Organism that is present in or on a collection specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnit' GO /****** Objekt: Table [dbo].[ProcessingMaterialCategory] Skriptdatum: 11/01/2007 10:13:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProcessingMaterialCategory]( [ProcessingID] [int] NOT NULL CONSTRAINT [DF_ProcessingMaterialCategory_ProcessingID] DEFAULT ((1)), [MaterialCategory] [nvarchar](50) NOT NULL CONSTRAINT [DF_ProcessingMaterialCategory_MaterialCategory] DEFAULT (N'specimen'), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_ProcessingMaterialCategory_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_ProcessingMaterialCategory_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_ProcessingMaterialCategory] PRIMARY KEY CLUSTERED ( [ProcessingID] ASC, [MaterialCategory] 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 processing. Refers to ProcessingID in table Processing (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProcessingMaterialCategory', @level2type=N'COLUMN',@level2name=N'ProcessingID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Material category of specimen. Examples: ''herbarium sheets'', ''drawings'', ''microscopic slides'' etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProcessingMaterialCategory', @level2type=N'COLUMN',@level2name=N'MaterialCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProcessingMaterialCategory', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProcessingMaterialCategory', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The processings that are possible for a certain material category' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProcessingMaterialCategory' GO /****** Objekt: Table [dbo].[CollectionSpecimenProcessing] Skriptdatum: 11/01/2007 10:10:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionSpecimenProcessing]( [CollectionSpecimenID] [int] NOT NULL, [ProcessingDate] [datetime] NOT NULL CONSTRAINT [DF_CollectionSpecimenPreparation_CollectorsSequence] DEFAULT (getdate()), [ProcessingID] [int] NOT NULL CONSTRAINT [DF_CollectionSpecimenProcessing_ProcessingID] DEFAULT ((1)), [Protocoll] [nvarchar](100) NULL, [SpecimenPartID] [int] NULL, [ProcessingDuration] [varchar](50) NULL, [ResponsibleName] [nvarchar](255) NULL CONSTRAINT [DF_CollectionSpecimenProcessing_ResponsibleName] DEFAULT ([dbo].[CurrentUserName]()), [ResponsibleAgentURI] [varchar](255) NULL, [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenPreparation_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenPreparation_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimenPreparation_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenPreparation_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionSpecimenProcessing] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [ProcessingDate] 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'Refers to ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time of the start of the processing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'ProcessingDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the processing. Refers to ProcessingID in table Processing (foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'ProcessingID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The label of the processing protocoll' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'Protocoll' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optional: If the dataset is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The duration of the processing in seconds' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'ProcessingDuration' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution responsible for the determination' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the processing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The processing that was applied to a collection specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenProcessing' GO /****** Objekt: Table [dbo].[CollectionSpecimen] Skriptdatum: 11/01/2007 10:09:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionSpecimen]( [CollectionSpecimenID] [int] IDENTITY(1,1) NOT NULL, [Version] [int] NOT NULL CONSTRAINT [DF_CollectionSpecimen_Version] DEFAULT ((1)), [CollectionEventID] [int] NULL, [CollectionID] [int] NULL, [AccessionNumber] [nvarchar](50) NULL, [AccessionDate] [datetime] NULL, [AccessionDay] [tinyint] NULL, [AccessionMonth] [tinyint] NULL, [AccessionYear] [smallint] NULL, [AccessionDateSupplement] [nvarchar](255) NULL, [AccessionDateCategory] [nvarchar](50) NULL, [DepositorsName] [nvarchar](255) NULL, [DepositorsAgentURI] [varchar](255) NULL, [DepositorsAccessionNumber] [nvarchar](50) NULL, [LabelTitle] [nvarchar](255) NULL, [LabelType] [nvarchar](50) NULL, [LabelTranscriptionState] [nvarchar](50) NULL, [LabelTranscriptionNotes] [nvarchar](255) NULL, [ExsiccataURI] [varchar](255) NULL, [ExsiccataAbbreviation] [nvarchar](255) NULL, [OriginalNotes] [nvarchar](max) NULL, [AdditionalNotes] [nvarchar](max) NULL, [ReferenceTitle] [nvarchar](255) NULL, [ReferenceURI] [varchar](255) NULL, [Problems] [nvarchar](255) NULL, [DataWithholdingReason] [nvarchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimen_LogCreatedWhen_1] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimen_LogCreatedBy_1] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionSpecimen_LogUpdatedWhen_1] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimen_LogUpdatedBy_1] DEFAULT (user_name()), [xx_IsAvailable] [bit] NOT NULL CONSTRAINT [DF_CollectionSpecimen_IsAvailable] DEFAULT ((1)), CONSTRAINT [PK_CollectionSpecimen_1] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique reference ID for the collection specimen record (primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The version of the dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'Version' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionEvent (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'CollectionEventID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the Collection as stored in table Collection (= foreign key, see table Collection)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'CollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Accession number of the specimen within the collection, e.g. "M-29834752"' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of the accession calculated from the entries in AccessionDay, -Month and -Year' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day of the date when the specimen was acquired in the collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionDay' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The month of the date when the specimen was acquired in the collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionMonth' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The year of the date when the specimen was acquired in the collection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionYear' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Verbal or additional accession date information, e.g. ''end of summer 1985'', ''first quarter'', ''1888-1892''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionDateSupplement' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Category of the date of the identification e.g. "system", "estimated" (= foreign key, see in table xColl_DateCategory_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AccessionDateCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the depositor(s) (person or organization responsible for deposition). Where entire collections are deposited, this should also contain the collection name (e.g. ''Herbarium P. Döbbler'')' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'DepositorsName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the depositor(s) (person or organization responsible for deposition)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'DepositorsAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Accession number of the specimen within the previous or original collection, e.g. ''D-23948''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'DepositorsAccessionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the label e.g. for printing labels.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LabelTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Printed, typewritten, typewritten with handwriting added, entirely in handwriting, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LabelType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The state of the transcription of a label into the database: ''Not started'', ''incomplete'', ''complete''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LabelTranscriptionState' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'User defined notes concerning the transcription of the label into the database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LabelTranscriptionNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If specimen is an exsiccata: The URI of the Exsiccata series, e.g. as stored within the DiversityExsiccata module' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'ExsiccataURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If specimen is an exsiccata: Standard abbreviation of the exsiccata (not necessarily a unique identifier; editors or publication places may change over time)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'ExsiccataAbbreviation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes found on the label of the specimen, by the original collector or from a later revision' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'OriginalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Additional notes made by the editor of the specimen record, e. g. ''doubtful identification/locality''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'AdditionalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the publication where the specimen was published. Note this is only a cached value where ReferenceURI is present' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'ReferenceTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI (e.g. LSID) of reference where specimen is published, e.g. referring to the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'ReferenceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of a problem that occurred during data editing. Typically these entries should be deleted after help has been obtained. Do not enter scientific problems here; use AdditionalNotes for such permanent problems!' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'Problems' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is withhold, the reason for withholding the data, otherwise null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'DataWithholdingReason' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is available' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen', @level2type=N'COLUMN',@level2name=N'xx_IsAvailable' GO EXEC sys.sp_addextendedproperty @name=N'Caption', @value=N'A specimen (= collection unit) within a collection. This is the central object of the DiversityCollection database.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The data directly attributed to the collection specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimen' GO /****** Objekt: Table [dbo].[Transaction] Skriptdatum: 11/01/2007 10:14:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Transaction]( [TransactionID] [int] IDENTITY(1,1) NOT NULL, [ParentTransactionID] [int] NULL, [TransactionType] [nvarchar](50) NOT NULL CONSTRAINT [DF_Table_1_ExchangeType] DEFAULT (N'exchange'), [TransactionTitle] [nvarchar](200) NOT NULL, [ReportingCategory] [nvarchar](50) NULL, [AdministratingCollectionID] [int] NULL, [MaterialDescription] [nvarchar](max) NULL CONSTRAINT [DF_Transaction_MaterialDescription] DEFAULT (''), [MaterialCategory] [nvarchar](50) NULL CONSTRAINT [DF_Transaction_MaterialCategory] DEFAULT (N'specimen'), [MaterialCollectors] [nvarchar](max) NULL, [FromCollectionID] [int] NULL, [FromTransactionPartnerName] [nvarchar](255) NULL, [FromTransactionPartnerAgentURI] [varchar](255) NULL, [FromTransactionNumber] [nvarchar](50) NULL, [ToCollectionID] [int] NULL, [ToTransactionPartnerName] [nvarchar](255) NULL, [ToTransactionPartnerAgentURI] [varchar](255) NULL, [ToTransactionNumber] [nvarchar](50) NULL, [NumberOfUnits] [smallint] NULL, [Investigator] [nvarchar](50) NULL, [TransactionComment] [nvarchar](max) NULL, [BeginDate] [datetime] NULL, [AgreedEndDate] [datetime] NULL, [ActualEndDate] [datetime] NULL, [InternalNotes] [nvarchar](max) NULL, [ResponsibleName] [nvarchar](255) NULL, [ResponsibleAgentURI] [varchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_Transaction_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Transaction_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_Transaction_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Transaction_LogUpdatedBy] DEFAULT (user_name()), [xx_ProjectID] [int] NULL, CONSTRAINT [PK_Transaction] PRIMARY KEY CLUSTERED ( [TransactionID] 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'Unique ID for the transaction (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'TransactionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of a preceeding transaction of a superior transaction if transactions are organized in a hierarchy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ParentTransactionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Type of the transaction e.g. gift in or out, exchange in or out, purchase in or out' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'TransactionType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the transaction as e.g. shown in an user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'TransactionTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A group defined for the transaction, e. g. a taxonomic group as used for exchange balancing' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ReportingCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the collection thas is responsible for the administration of the transaction.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'AdministratingCollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the project to which the transaction belongs (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'MaterialDescription' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Material category of specimen. Examples: ''herbarium sheets'', ''drawings'', ''microscopic slides'' etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'MaterialCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The collectors of the material' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'MaterialCollectors' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the collection from which the specimen were transfered, e.g. the donating collection of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'FromCollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution from which the specimen were transfered, e.g. the donator of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'FromTransactionPartnerName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the transaction partner (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'FromTransactionPartnerAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number or code by which a transaction may be recorded by the administration of the source of the specimen, e.g. the donating collection of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'FromTransactionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the collection to which the specimen were transfered, e.g. the receiver of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ToCollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution to which the specimen were transfered, e.g. the receiver of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ToTransactionPartnerName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the transaction partner (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ToTransactionPartnerAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number or code by which a transaction may be recorded by the administration of the destination of the specimen, e.g. the receiving collection of a gift' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ToTransactionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number of units that were (initially) included in the transaction' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'NumberOfUnits' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The investigator for whose study a transacted material was sent' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'Investigator' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Comments about the exchanged material addressed to the transaction partner' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'TransactionComment' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date when the transaction started' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'BeginDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'End of the transaction period, e.g. if the time for borrowing the specimen is restricted' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'AgreedEndDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Actual end of the transaction when e.g. the borrowed specimen were returned to the owner' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ActualEndDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes about this transaction, not to be published e.g. on a web page' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The person responsible for this transaction' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the person, team or organisation responsible for the data (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the project to which the transaction belongs (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction', @level2type=N'COLUMN',@level2name=N'xx_ProjectID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Transactions like loan, borrow, gift, exchange etc. of specimen if they are e.g. permanently or temporary transfered from one collection to another' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transaction' GO /****** Objekt: Table [dbo].[CollectionEventImage] Skriptdatum: 11/01/2007 10:08:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionEventImage]( [CollectionEventID] [int] NOT NULL, [URI] [varchar](255) NOT NULL, [ResourceURI] [varchar](255) NULL, [ImageType] [nvarchar](50) NULL, [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventImage_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventImage_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventImage_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventImage_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionEventImage] PRIMARY KEY CLUSTERED ( [CollectionEventID] ASC, [URI] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique ID for the collection event (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'CollectionEventID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'URI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the resource (e.g. see module DiversityResources)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'ResourceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Type of the image, e.g. map' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'ImageType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes to this image concerning the collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The images showing the site of the collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventImage' GO /****** Objekt: Table [dbo].[Identification] Skriptdatum: 11/01/2007 10:12:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Identification]( [CollectionSpecimenID] [int] NOT NULL, [IdentificationUnitID] [int] NOT NULL, [IdentificationSequence] [smallint] NOT NULL CONSTRAINT [DF_Identification_IdentificationSequ] DEFAULT ((1)), [IdentificationDate] [datetime] NULL, [IdentificationDay] [tinyint] NULL, [IdentificationMonth] [tinyint] NULL, [IdentificationYear] [smallint] NULL, [IdentificationDateSupplement] [nvarchar](255) NULL, [IdentificationDateCategory] [nvarchar](50) NULL, [VernacularTerm] [nvarchar](255) NULL, [TaxonomicName] [nvarchar](255) NULL, [NameURI] [varchar](255) NULL, [IdentificationCategory] [nvarchar](50) NULL, [IdentificationQualifier] [nvarchar](50) NULL, [TypeStatus] [nvarchar](50) NULL, [TypeNotes] [nvarchar](max) NULL, [ReferenceTitle] [nvarchar](255) NULL, [ReferenceURI] [varchar](255) NULL, [Notes] [nvarchar](max) NULL, [ResponsibleName] [nvarchar](255) NULL CONSTRAINT [DF_Identification_ResponsibleName] DEFAULT ([dbo].[CurrentUserName]()), [ResponsibleAgentURI] [varchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_Identification_IdentificationSequence] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Identification_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_Identification_LogChangedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_Identification_LogChangedBy] DEFAULT (user_name()), CONSTRAINT [PK_Identification] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [IdentificationUnitID] ASC, [IdentificationSequence] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of IdentficationUnit (= foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sequence of the identifications. The last identification (having the highest sequence) is regarded as valid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationSequence' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of the identification calculated from the entries in IdentificationDay, -Month and -Year' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day of the identification event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationDay' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The month of the identification event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationMonth' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The year of the identification event. The year may be empty if only the day or month are known.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationYear' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Verbal or additional identification date information, e.g. ''end of summer 1985'', ''first quarter'', ''1888-1892''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationDateSupplement' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Category of the date of the identification e.g. "system", "estimated" (= foreign key, see in table CollDateCategory_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationDateCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name or term other than a taxonomic (= scientific) name, e.g. ''pine'', ''limestone'', ''conifer'', ''hardwood''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'VernacularTerm' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Valid name of the species (including the taxonomic author where available. Example: ''Rosa canina L.''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'TaxonomicName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the taxonomic name, e.g. as provided by the module DiversityTaxonNames.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'NameURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Category of the identification e.g. ''determination'', ''confirmation'', ''absence'' (= foreign key, see table CollIdentificationCategory_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Qualification of the identification e.g. "cf."," aff.", "sp. nov." (= foreign key, see table CollIdentificationQualifier_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'IdentificationQualifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If identification unit is type of a taxonomic name: holotype, syntype, etc. (= foreign key, see table CollTypeStatus_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'TypeStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes concerning the typification of this specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'TypeNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Publications or authoritative opinions of scientist used during the identification process. Example: enter ''Schmeil-Fitschen 1995'' if this field flora was used.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'ReferenceTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The URI of the reference e.g. as provided by the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'ReferenceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'ReferenceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'User defined notes, e.g. the reason for a re-determination / change of the name, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution responsible for the determination' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Login of the user who created the dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the dataset was changed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Login of the user who changed the dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'Caption', @value=N'Identifications of the identification units' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The identifications of the organisms within a specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Identification' GO /****** Objekt: Table [dbo].[IdentificationUnitAnalysis] Skriptdatum: 11/01/2007 10:13:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[IdentificationUnitAnalysis]( [CollectionSpecimenID] [int] NOT NULL, [IdentificationUnitID] [int] NOT NULL, [AnalysisID] [int] NOT NULL, [AnalysisNumber] [nvarchar](50) NOT NULL, [AnalysisResult] [nvarchar](max) NULL, [ExternalAnalysisURI] [varchar](255) NULL, [ResponsibleName] [nvarchar](255) NULL CONSTRAINT [DF_IdentificationUnitAnalysis_ResponsibleName] DEFAULT ([dbo].[CurrentUserName]()), [ResponsibleAgentURI] [varchar](255) NULL, [Notes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_IdentificationUnitAnalysis_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnitAnalysis_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_IdentificationUnitAnalysis_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnitAnalysis_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_ProvisionalDescriptionData] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [IdentificationUnitID] ASC, [AnalysisID] ASC, [AnalysisNumber] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of IdentficationUnit (= foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Analysis ID, foreign key of table Analysis.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'AnalysisID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of the analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'AnalysisNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The result of the analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'AnalysisResult' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An URI for an analysis as defined in an external datasoure' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'ExternalAnalysisURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'ExternalAnalysisURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of the person or institution responsible for the determination' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the person or institution responsible for the determination (= foreign key) as stored in the module DiversityAgents.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes concerning this analysis' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The analysis values taken from an identification unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitAnalysis' GO /****** Objekt: Table [dbo].[IdentificationUnitInPart] Skriptdatum: 11/01/2007 10:13:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IdentificationUnitInPart]( [CollectionSpecimenID] [int] NOT NULL, [IdentificationUnitID] [int] NOT NULL, [SpecimenPartID] [int] NOT NULL, [DisplayOrder] [smallint] NOT NULL CONSTRAINT [DF_IdentificationUnitInPart_DisplayOrder] DEFAULT ((1)), [LogInsertedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnitInPart_LogInsertedBy] DEFAULT (user_name()), [LogInsertedWhen] [smalldatetime] NULL CONSTRAINT [DF_IdentificationUnitInPart_LogInsertedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_IdentificationUnitInPart_LogUpdatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [smalldatetime] NULL CONSTRAINT [DF_IdentificationUnitInPart_LogUpdatedWhen] DEFAULT (getdate()), CONSTRAINT [PK_IdentificationUnitInPart] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [IdentificationUnitID] ASC, [SpecimenPartID] 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'Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the identification unit (= part of Primary key). Usually one of possibly several organisms present on the collection specimen. Example: parasite with hyperparasite on plant leaf = 3 units,' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'IdentificationUnitID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the part of a specimen (optional, Foreign key) if the identification unit is located on a part of the specimen (see table CollectionSpecimenPart).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sequence in which the units within this part will appear on e.g. a label where the first unit may be printed in the header and others in the text below. 0 means the unit should not appear on a label.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'DisplayOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'LogInsertedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the data were first entered (typed or imported) into this database.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @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.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the data were last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The list of the organisms that are found in a part of the specimen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IdentificationUnitInPart' GO /****** Objekt: Table [dbo].[CollectionCurator] Skriptdatum: 11/01/2007 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollectionCurator]( [LoginName] [nvarchar](50) NOT NULL, [AdministratingCollectionID] [int] NOT NULL, CONSTRAINT [PK_CollectionCurator] PRIMARY KEY CLUSTERED ( [LoginName] ASC, [AdministratingCollectionID] 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'A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc..' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionCurator', @level2type=N'COLUMN',@level2name=N'LoginName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID for the collection for which the curator has the right to administrate the transaction. Corresponds to AdministratingCollectionID in table Transaction.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionCurator', @level2type=N'COLUMN',@level2name=N'AdministratingCollectionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Curators within DiversityCollection, responsible of specimen transactions' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionCurator' GO /****** Objekt: Table [dbo].[CollectionSpecimenTransaction] Skriptdatum: 11/01/2007 10:10:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CollectionSpecimenTransaction]( [CollectionSpecimenID] [int] NOT NULL, [TransactionID] [int] NOT NULL, [SpecimenPartID] [int] NOT NULL, [IsOnLoan] [bit] NULL, [LogInsertedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenTransaction_LogInsertedBy] DEFAULT (user_name()), [LogInsertedWhen] [smalldatetime] NULL CONSTRAINT [DF_CollectionSpecimenTransaction_LogInsertedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionSpecimenTransaction_LogUpdatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [smalldatetime] NULL CONSTRAINT [DF_CollectionSpecimenTransaction_LogUpdatedWhen] DEFAULT (getdate()), CONSTRAINT [PK_CollectionSpecimenTransaction] PRIMARY KEY CLUSTERED ( [CollectionSpecimenID] ASC, [TransactionID] ASC, [SpecimenPartID] 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'Refers to ID of CollectionSpecimen (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique ID for the transaction (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'TransactionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optional: If the dataset is related to a part of a specimen, the ID of a related part (= foreign key, see table CollectionSpecimenPart)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'SpecimenPartID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'True if a specimen is on loan' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'IsOnLoan' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of user who first entered (typed or imported) the data.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'LogInsertedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the data were first entered (typed or imported) into this database.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @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.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time when the data were last updated.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The transactions in which a specimen was involved' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionSpecimenTransaction' GO /****** Objekt: Table [dbo].[ProjectUser] Skriptdatum: 11/01/2007 10:13:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProjectUser]( [LoginName] [nvarchar](50) NOT NULL, [ProjectID] [int] NOT NULL, CONSTRAINT [PK_ProjectUser] PRIMARY KEY CLUSTERED ( [LoginName] ASC, [ProjectID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc..' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProjectUser', @level2type=N'COLUMN',@level2name=N'LoginName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ProjectUser', @level2type=N'COLUMN',@level2name=N'ProjectID' GO /****** Objekt: Table [dbo].[CollectionEventLocalisation] Skriptdatum: 11/01/2007 10:08:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionEventLocalisation]( [CollectionEventID] [int] NOT NULL, [LocalisationSystemID] [int] NOT NULL, [Location1] [nvarchar](255) NULL, [Location2] [nvarchar](255) NULL, [LocationAccuracy] [nvarchar](50) NULL, [LocationNotes] [nvarchar](max) NULL, [DeterminationDate] [smalldatetime] NULL, [DistanceToLocation] [varchar](50) NULL, [DirectionToLocation] [varchar](50) NULL, [ResponsibleName] [nvarchar](255) NULL CONSTRAINT [DF_CollectionEventLocalisation_ResponsibleName] DEFAULT ([dbo].[CurrentUserName]()), [ResponsibleAgentURI] [varchar](255) NULL, [AverageAltitudeCache] [real] NULL, [AverageLatitudeCache] [real] NULL, [AverageLongitudeCache] [real] NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionLocalisation_2_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionLocalisation_2_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionLocalisation_2_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionLocalisation_2_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionLocalisation] PRIMARY KEY CLUSTERED ( [CollectionEventID] ASC, [LocalisationSystemID] 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'Refers to the ID of CollectionEvent (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'CollectionEventID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Refers to the ID of LocalisationSystem (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LocalisationSystemID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Either a named location selected from a thesaurus (e. g. ''Germany, Bavaria, Kleindingharting'') or altitude range or other values (e. g. 100-200 m)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'Location1' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Corresponding value to Location1 e.g. ID or URI of gazetteer or thesaurus' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'Location2' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The accuracy of the determination of this locality' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LocationAccuracy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes on the location' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LocationNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date of the determination of the geographical localisation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'DeterminationDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Distance from the specified place to the real location of the collection event (m)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'DistanceToLocation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Direction from the specified place to the real location of the collection event (Degrees rel. to north)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'DirectionToLocation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the agent (person or organization) responsible for this entry.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the person or organisation responsible for the data (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated altitude as parsed from the location fields' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'AverageAltitudeCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated latitude as parsed from the location fields' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'AverageLatitudeCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated longitude as parsed from the location fields' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'AverageLongitudeCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The geographic localisation of a collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventLocalisation' GO /****** Objekt: Table [dbo].[TransactionDocument] Skriptdatum: 11/01/2007 10:14:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TransactionDocument]( [TransactionID] [int] NOT NULL, [Date] [datetime] NOT NULL, [TransactionText] [nvarchar](max) NULL, [TransactionDocument] [image] NULL, [InternalNotes] [nvarchar](max) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_TransactionDocuments_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_TransactionDocuments_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_TransactionDocuments_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_TransactionDocuments_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_TransactionDocuments] PRIMARY KEY CLUSTERED ( [TransactionID] ASC, [Date] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique ID for the Transaction, refers to table Transaction (= Part of primary key and foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'TransactionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of the event of a transaction' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'Date' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The text of a transaction document' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'TransactionText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A scanned document connected to this transaction event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'TransactionDocument' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal notes about this transaction event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'InternalNotes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The history of transactions resp. the documents connected to the transactions' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TransactionDocument' GO /****** Objekt: Table [dbo].[CollectionEventProperty] Skriptdatum: 11/01/2007 10:09:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionEventProperty]( [CollectionEventID] [int] NOT NULL, [PropertyID] [int] NOT NULL, [DisplayText] [nvarchar](255) NULL, [PropertyURI] [varchar](255) NULL, [PropertyHierarchyCache] [nvarchar](max) NULL, [PropertyValue] [nvarchar](255) NULL, [ResponsibleName] [nvarchar](255) NULL CONSTRAINT [DF_CollectionEventProperty_ResponsibleName] DEFAULT ([dbo].[CurrentUserName]()), [ResponsibleAgentURI] [varchar](255) NULL, [Notes] [nvarchar](max) NULL, [AverageValueCache] [float] NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventCharacter_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventCharacter_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEventCharacter_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEventCharacter_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_CollectionEventCharacter] PRIMARY KEY CLUSTERED ( [CollectionEventID] ASC, [PropertyID] 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'Refers to the ID of CollectionEvent (= Foreign key and part of primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'CollectionEventID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the descriptor of the collection event, foreign key, see table Descriptor' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'PropertyID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The text for the property as shown e.g. in a user interface' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'DisplayText' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI referring to an external datasource e.g. DiversityTerminology' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'PropertyURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A cached text of the complete name of the descriptor including superior categories if present' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'PropertyHierarchyCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The value of a captured feature e.g. temperature, pH, vegetation etc. If there is a range this is the lower or first value' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'PropertyValue' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the agent (person or organization) responsible for this entry.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'ResponsibleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI of the person or organisation responsible for the data (see e.g. module DiversityAgents)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'ResponsibleAgentURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the property of the colletion site.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'For numeric values - a cached average value according to the' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'AverageValueCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A property of a collection site, e.g. exposition, slope, vegetation. May refer to Diversity Workbench module DiversityScientificTerms' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEventProperty' GO /****** Objekt: Table [dbo].[AnalysisTaxonomicGroup] Skriptdatum: 11/01/2007 10:07:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AnalysisTaxonomicGroup]( [AnalysisID] [int] NOT NULL, [TaxonomicGroup] [nvarchar](50) NOT NULL, [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_AnalysisTaxonomicGroup_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_AnalysisTaxonomicGroup_LogUpdatedBy] DEFAULT (user_name()), CONSTRAINT [PK_AnalysisTaxonomicGroup] PRIMARY KEY CLUSTERED ( [AnalysisID] ASC, [TaxonomicGroup] 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'Analysis ID, foreign key of table Analysis.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnalysisTaxonomicGroup', @level2type=N'COLUMN',@level2name=N'AnalysisID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Taxonomic group the organism identified by this unit belongs to. Groups listed in table CollTaxonomicGroup_Enum (= foreign key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnalysisTaxonomicGroup', @level2type=N'COLUMN',@level2name=N'TaxonomicGroup' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnalysisTaxonomicGroup', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnalysisTaxonomicGroup', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The types of analysis that are available for a taxonomic group' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AnalysisTaxonomicGroup' GO /****** Objekt: Table [dbo].[CollectionEvent] Skriptdatum: 11/01/2007 10:08:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CollectionEvent]( [CollectionEventID] [int] IDENTITY(1,1) NOT NULL, [Version] [int] NOT NULL CONSTRAINT [DF_CollectionEvent_Version] DEFAULT ((1)), [SeriesID] [int] NULL, [CollectorsEventNumber] [nvarchar](50) NULL, [CollectionDate] [datetime] NULL, [CollectionDay] [dbo].[dtDay] NULL, [CollectionMonth] [dbo].[dtMonth] NULL, [CollectionYear] [dbo].[dtYear] NULL, [CollectionDateSupplement] [nvarchar](100) NULL, [CollectionDateCategory] [nvarchar](50) NULL, [CollectionTime] [varchar](50) NULL, [CollectionTimeSpan] [varchar](50) NULL, [LocalityDescription] [nvarchar](max) NULL, [HabitatDescription] [nvarchar](max) NULL, [ReferenceTitle] [nvarchar](255) NULL, [ReferenceURI] [varchar](255) NULL, [CollectingMethod] [nvarchar](max) NULL, [Notes] [nvarchar](max) NULL, [CountryCache] [nvarchar](50) NULL, [DataWithholdingReason] [nvarchar](255) NULL, [LogCreatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEvent_LogCreatedWhen] DEFAULT (getdate()), [LogCreatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEvent_LogCreatedBy] DEFAULT (user_name()), [LogUpdatedWhen] [datetime] NULL CONSTRAINT [DF_CollectionEvent_LogUpdatedWhen] DEFAULT (getdate()), [LogUpdatedBy] [nvarchar](50) NULL CONSTRAINT [DF_CollectionEvent_LogUpdatedBy] DEFAULT (user_name()), [xx_IsAvailable] [bit] NOT NULL CONSTRAINT [DF_CollectionEvent_IsAvailable] DEFAULT ((1)), [xx_ExpeditionID] [int] NULL, CONSTRAINT [PK_CollectionEvent] PRIMARY KEY CLUSTERED ( [CollectionEventID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_bindrule @rulename=N'[dbo].[ruleDay]', @objname=N'[dbo].[CollectionEvent].[CollectionDay]' , @futureonly='futureonly' GO EXEC sys.sp_bindrule @rulename=N'[dbo].[ruleMonth]', @objname=N'[dbo].[CollectionEvent].[CollectionMonth]' , @futureonly='futureonly' GO EXEC sys.sp_bindrule @rulename=N'[dbo].[ruleYear]', @objname=N'[dbo].[CollectionEvent].[CollectionYear]' , @futureonly='futureonly' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique ID for the collection event (= Primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionEventID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The version of the dataset. Automatically set by the system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'Version' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the related expedition. Relates to the PK of the table CollectionExpedition (Foreign key). ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'SeriesID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number assigned to a collection event by the collector (= ''field number'')' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectorsEventNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date of the event calulated from the entries in CollectionDay, -Month and -Year.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The day of the date of the event or when the collection event started' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionDay' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The month of the date of the event or when the collection event started' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionMonth' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The year of the date of the event or when the collection event started' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionYear' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Verbal or additional collection date information, e.g. ''end of summer 1985'', ''first quarter'', ''1888-1892''. The end date if the collection event comprises a period. The time of the event if necessary.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionDateSupplement' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Category of the date of the identification e.g. "system", "estimated" (= foreign key, see in table CollEventDateCategory_Enum)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionDateCategory' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time of the event or when the collection event started' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time span in seconds of the collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectionTimeSpan' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Locality description of the locality, exactly as written on the original label (i.e. without corrections during data entry)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'LocalityDescription' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Geo-ecological description of the locality, exactly as written on the original label (i.e. without corrections during data entry)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'HabitatDescription' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'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'CollectionEvent', @level2type=N'COLUMN',@level2name=N'ReferenceTitle' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI (e.g. LSID) of the source publication where the collection event is published, may e.g. refer to the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'ReferenceURI' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the method used for collecting the samples, e.g. traps, moist chambers, drag net' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CollectingMethod' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Notes about the collection event' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'Notes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The country where the collection event took place. Cached value derived from an entry in CollectionGeography' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'CountryCache' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is withhold, the reason for withholding the data, otherwise null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'DataWithholdingReason' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The time when this dataset was created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'LogCreatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who created this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'LogCreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last time when this dataset was updated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'LogUpdatedWhen' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Who was the last to update this dataset' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If the dataset is available, e.g. if the data can be published' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'xx_IsAvailable' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the related expedition. Relates to the PK of the table CollectionExpedition (Foreign key). ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent', @level2type=N'COLUMN',@level2name=N'xx_ExpeditionID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The collection event where the specimen was collected' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollectionEvent' GO /****** Objekt: Check [CK_IdentificationName] Skriptdatum: 11/01/2007 10:12:31 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [CK_IdentificationName] CHECK ((len([TaxonomicName])>(0) AND [TaxonomicName] IS NOT NULL OR len([VernacularTerm])>(0) AND [VernacularTerm] IS NOT NULL)) GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [CK_IdentificationName] GO /****** Objekt: Check [CK_IdentificationResponsible] Skriptdatum: 11/01/2007 10:12:31 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [CK_IdentificationResponsible] CHECK (([ResponsibleAgentURI] IS NULL OR len([ResponsibleName])>(0) AND [ResponsibleAgentURI] IS NOT NULL AND [ResponsibleName] IS NOT NULL)) GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [CK_IdentificationResponsible] GO /****** Objekt: Check [CK_TaxonmicName] Skriptdatum: 11/01/2007 10:12:31 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [CK_TaxonmicName] CHECK (([NameURI] IS NULL OR len([TaxonomicName])>(0) AND [NameURI] IS NOT NULL AND [TaxonomicName] IS NOT NULL)) GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [CK_TaxonmicName] GO /****** Objekt: ForeignKey [FK_IdentificationAnalysis_IdentificationAnalysis] Skriptdatum: 11/01/2007 10:07:35 ******/ ALTER TABLE [dbo].[Analysis] WITH NOCHECK ADD CONSTRAINT [FK_IdentificationAnalysis_IdentificationAnalysis] FOREIGN KEY([AnalysisParentID]) REFERENCES [dbo].[Analysis] ([AnalysisID]) GO ALTER TABLE [dbo].[Analysis] CHECK CONSTRAINT [FK_IdentificationAnalysis_IdentificationAnalysis] GO /****** Objekt: ForeignKey [FK_AnalysisTaxonomicGroup_Analysis] Skriptdatum: 11/01/2007 10:07:39 ******/ ALTER TABLE [dbo].[AnalysisTaxonomicGroup] WITH CHECK ADD CONSTRAINT [FK_AnalysisTaxonomicGroup_Analysis] FOREIGN KEY([AnalysisID]) REFERENCES [dbo].[Analysis] ([AnalysisID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[AnalysisTaxonomicGroup] CHECK CONSTRAINT [FK_AnalysisTaxonomicGroup_Analysis] GO /****** Objekt: ForeignKey [FK_Collection_Collection] Skriptdatum: 11/01/2007 10:08:01 ******/ ALTER TABLE [dbo].[Collection] WITH NOCHECK ADD CONSTRAINT [FK_Collection_Collection] FOREIGN KEY([CollectionParentID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[Collection] CHECK CONSTRAINT [FK_Collection_Collection] GO /****** Objekt: ForeignKey [FK_CollectionAgent_CollectionSpecimen] Skriptdatum: 11/01/2007 10:08:12 ******/ ALTER TABLE [dbo].[CollectionAgent] WITH NOCHECK ADD CONSTRAINT [FK_CollectionAgent_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionAgent] CHECK CONSTRAINT [FK_CollectionAgent_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_CollectionCurator_Collection] Skriptdatum: 11/01/2007 10:08:15 ******/ ALTER TABLE [dbo].[CollectionCurator] WITH CHECK ADD CONSTRAINT [FK_CollectionCurator_Collection] FOREIGN KEY([AdministratingCollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[CollectionCurator] CHECK CONSTRAINT [FK_CollectionCurator_Collection] GO /****** Objekt: ForeignKey [FK_CollectionEvent_CollectionEventSeries] Skriptdatum: 11/01/2007 10:08:35 ******/ ALTER TABLE [dbo].[CollectionEvent] WITH CHECK ADD CONSTRAINT [FK_CollectionEvent_CollectionEventSeries] FOREIGN KEY([SeriesID]) REFERENCES [dbo].[CollectionEventSeries] ([SeriesID]) GO ALTER TABLE [dbo].[CollectionEvent] CHECK CONSTRAINT [FK_CollectionEvent_CollectionEventSeries] GO /****** Objekt: ForeignKey [FK_CollectionEvent_CollEventDateCategory_Enum] Skriptdatum: 11/01/2007 10:08:35 ******/ ALTER TABLE [dbo].[CollectionEvent] WITH NOCHECK ADD CONSTRAINT [FK_CollectionEvent_CollEventDateCategory_Enum] FOREIGN KEY([CollectionDateCategory]) REFERENCES [dbo].[CollEventDateCategory_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionEvent] CHECK CONSTRAINT [FK_CollectionEvent_CollEventDateCategory_Enum] GO /****** Objekt: ForeignKey [FK_CollectionEventImage_CollectionEvent] Skriptdatum: 11/01/2007 10:08:43 ******/ ALTER TABLE [dbo].[CollectionEventImage] WITH NOCHECK ADD CONSTRAINT [FK_CollectionEventImage_CollectionEvent] FOREIGN KEY([CollectionEventID]) REFERENCES [dbo].[CollectionEvent] ([CollectionEventID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionEventImage] CHECK CONSTRAINT [FK_CollectionEventImage_CollectionEvent] GO /****** Objekt: ForeignKey [FK_CollectionEventImage_CollEventImageType_Enum] Skriptdatum: 11/01/2007 10:08:43 ******/ ALTER TABLE [dbo].[CollectionEventImage] WITH NOCHECK ADD CONSTRAINT [FK_CollectionEventImage_CollEventImageType_Enum] FOREIGN KEY([ImageType]) REFERENCES [dbo].[CollEventImageType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionEventImage] CHECK CONSTRAINT [FK_CollectionEventImage_CollEventImageType_Enum] GO /****** Objekt: ForeignKey [FK_CollectionLocalisation_CollectionEvent] Skriptdatum: 11/01/2007 10:08:58 ******/ ALTER TABLE [dbo].[CollectionEventLocalisation] WITH CHECK ADD CONSTRAINT [FK_CollectionLocalisation_CollectionEvent] FOREIGN KEY([CollectionEventID]) REFERENCES [dbo].[CollectionEvent] ([CollectionEventID]) GO ALTER TABLE [dbo].[CollectionEventLocalisation] CHECK CONSTRAINT [FK_CollectionLocalisation_CollectionEvent] GO /****** Objekt: ForeignKey [FK_CollectionLocalisation_LocalisationSystem] Skriptdatum: 11/01/2007 10:08:58 ******/ ALTER TABLE [dbo].[CollectionEventLocalisation] WITH CHECK ADD CONSTRAINT [FK_CollectionLocalisation_LocalisationSystem] FOREIGN KEY([LocalisationSystemID]) REFERENCES [dbo].[LocalisationSystem] ([LocalisationSystemID]) GO ALTER TABLE [dbo].[CollectionEventLocalisation] CHECK CONSTRAINT [FK_CollectionLocalisation_LocalisationSystem] GO /****** Objekt: ForeignKey [FK_CollectionEventDescriptor_Descriptor] Skriptdatum: 11/01/2007 10:09:10 ******/ ALTER TABLE [dbo].[CollectionEventProperty] WITH CHECK ADD CONSTRAINT [FK_CollectionEventDescriptor_Descriptor] FOREIGN KEY([PropertyID]) REFERENCES [dbo].[Property] ([PropertyID]) GO ALTER TABLE [dbo].[CollectionEventProperty] CHECK CONSTRAINT [FK_CollectionEventDescriptor_Descriptor] GO /****** Objekt: ForeignKey [FK_CollectionEventProperty_CollectionEvent] Skriptdatum: 11/01/2007 10:09:10 ******/ ALTER TABLE [dbo].[CollectionEventProperty] WITH CHECK ADD CONSTRAINT [FK_CollectionEventProperty_CollectionEvent] FOREIGN KEY([CollectionEventID]) REFERENCES [dbo].[CollectionEvent] ([CollectionEventID]) GO ALTER TABLE [dbo].[CollectionEventProperty] CHECK CONSTRAINT [FK_CollectionEventProperty_CollectionEvent] GO /****** Objekt: ForeignKey [FK_CollectionEventSeries_CollectionEventSeries] Skriptdatum: 11/01/2007 10:09:19 ******/ ALTER TABLE [dbo].[CollectionEventSeries] WITH NOCHECK ADD CONSTRAINT [FK_CollectionEventSeries_CollectionEventSeries] FOREIGN KEY([SeriesParentID]) REFERENCES [dbo].[CollectionEventSeries] ([SeriesID]) GO ALTER TABLE [dbo].[CollectionEventSeries] CHECK CONSTRAINT [FK_CollectionEventSeries_CollectionEventSeries] GO /****** Objekt: ForeignKey [FK_CollectionProject_CollectionSpecimen] Skriptdatum: 11/01/2007 10:09:25 ******/ ALTER TABLE [dbo].[CollectionProject] WITH NOCHECK ADD CONSTRAINT [FK_CollectionProject_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionProject] CHECK CONSTRAINT [FK_CollectionProject_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_CollectionProject_DiversityProjectProxy] Skriptdatum: 11/01/2007 10:09:25 ******/ ALTER TABLE [dbo].[CollectionProject] WITH NOCHECK ADD CONSTRAINT [FK_CollectionProject_DiversityProjectProxy] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[ProjectProxy] ([ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionProject] CHECK CONSTRAINT [FK_CollectionProject_DiversityProjectProxy] GO /****** Objekt: ForeignKey [FK_CollectionSpecimen_CollDateCategory_Enum] Skriptdatum: 11/01/2007 10:09:48 ******/ ALTER TABLE [dbo].[CollectionSpecimen] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimen_CollDateCategory_Enum] FOREIGN KEY([AccessionDateCategory]) REFERENCES [dbo].[CollDateCategory_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimen] CHECK CONSTRAINT [FK_CollectionSpecimen_CollDateCategory_Enum] GO /****** Objekt: ForeignKey [FK_CollectionSpecimen_Collection] Skriptdatum: 11/01/2007 10:09:49 ******/ ALTER TABLE [dbo].[CollectionSpecimen] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimen_Collection] FOREIGN KEY([CollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[CollectionSpecimen] CHECK CONSTRAINT [FK_CollectionSpecimen_Collection] GO /****** Objekt: ForeignKey [FK_CollectionSpecimen_CollectionEvent] Skriptdatum: 11/01/2007 10:09:49 ******/ ALTER TABLE [dbo].[CollectionSpecimen] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimen_CollectionEvent] FOREIGN KEY([CollectionEventID]) REFERENCES [dbo].[CollectionEvent] ([CollectionEventID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimen] CHECK CONSTRAINT [FK_CollectionSpecimen_CollectionEvent] GO /****** Objekt: ForeignKey [FK_CollectionSpecimen_CollLabelTranscritionState_Enum] Skriptdatum: 11/01/2007 10:09:49 ******/ ALTER TABLE [dbo].[CollectionSpecimen] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimen_CollLabelTranscritionState_Enum] FOREIGN KEY([LabelTranscriptionState]) REFERENCES [dbo].[CollLabelTranscriptionState_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimen] CHECK CONSTRAINT [FK_CollectionSpecimen_CollLabelTranscritionState_Enum] GO /****** Objekt: ForeignKey [FK_CollectionSpecimen_CollLabelType_Enum] Skriptdatum: 11/01/2007 10:09:50 ******/ ALTER TABLE [dbo].[CollectionSpecimen] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimen_CollLabelType_Enum] FOREIGN KEY([LabelType]) REFERENCES [dbo].[CollLabelType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimen] CHECK CONSTRAINT [FK_CollectionSpecimen_CollLabelType_Enum] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenImage_CollectionSpecimen] Skriptdatum: 11/01/2007 10:10:01 ******/ ALTER TABLE [dbo].[CollectionSpecimenImage] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimenImage_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimenImage] CHECK CONSTRAINT [FK_CollectionSpecimenImage_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenImage_CollSpecimenImageType_Enum] Skriptdatum: 11/01/2007 10:10:01 ******/ ALTER TABLE [dbo].[CollectionSpecimenImage] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimenImage_CollSpecimenImageType_Enum] FOREIGN KEY([ImageType]) REFERENCES [dbo].[CollSpecimenImageType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimenImage] CHECK CONSTRAINT [FK_CollectionSpecimenImage_CollSpecimenImageType_Enum] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenImage_IdentificationUnit] Skriptdatum: 11/01/2007 10:10:02 ******/ ALTER TABLE [dbo].[CollectionSpecimenImage] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimenImage_IdentificationUnit] FOREIGN KEY([CollectionSpecimenID], [IdentificationUnitID]) REFERENCES [dbo].[IdentificationUnit] ([CollectionSpecimenID], [IdentificationUnitID]) NOT FOR REPLICATION GO ALTER TABLE [dbo].[CollectionSpecimenImage] NOCHECK CONSTRAINT [FK_CollectionSpecimenImage_IdentificationUnit] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenPart_CollectionSpecimenPart1] Skriptdatum: 11/01/2007 10:10:15 ******/ ALTER TABLE [dbo].[CollectionSpecimenPart] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimenPart_CollectionSpecimenPart1] FOREIGN KEY([CollectionSpecimenID], [DerivedFromSpecimenPartID]) REFERENCES [dbo].[CollectionSpecimenPart] ([CollectionSpecimenID], [SpecimenPartID]) GO ALTER TABLE [dbo].[CollectionSpecimenPart] CHECK CONSTRAINT [FK_CollectionSpecimenPart_CollectionSpecimenPart1] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenPart_CollMaterialCategory_Enum] Skriptdatum: 11/01/2007 10:10:15 ******/ ALTER TABLE [dbo].[CollectionSpecimenPart] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimenPart_CollMaterialCategory_Enum] FOREIGN KEY([MaterialCategory]) REFERENCES [dbo].[CollMaterialCategory_Enum] ([Code]) GO ALTER TABLE [dbo].[CollectionSpecimenPart] CHECK CONSTRAINT [FK_CollectionSpecimenPart_CollMaterialCategory_Enum] GO /****** Objekt: ForeignKey [FK_CollectionStorage_Collection] Skriptdatum: 11/01/2007 10:10:15 ******/ ALTER TABLE [dbo].[CollectionSpecimenPart] WITH CHECK ADD CONSTRAINT [FK_CollectionStorage_Collection] FOREIGN KEY([CollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[CollectionSpecimenPart] CHECK CONSTRAINT [FK_CollectionStorage_Collection] GO /****** Objekt: ForeignKey [FK_CollectionStorage_CollectionSpecimen] Skriptdatum: 11/01/2007 10:10:16 ******/ ALTER TABLE [dbo].[CollectionSpecimenPart] WITH CHECK ADD CONSTRAINT [FK_CollectionStorage_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimenPart] CHECK CONSTRAINT [FK_CollectionStorage_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenProcessing_Processing] Skriptdatum: 11/01/2007 10:10:27 ******/ ALTER TABLE [dbo].[CollectionSpecimenProcessing] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimenProcessing_Processing] FOREIGN KEY([ProcessingID]) REFERENCES [dbo].[Processing] ([ProcessingID]) GO ALTER TABLE [dbo].[CollectionSpecimenProcessing] CHECK CONSTRAINT [FK_CollectionSpecimenProcessing_Processing] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenRelation_CollectionSpecimen] Skriptdatum: 11/01/2007 10:10:39 ******/ ALTER TABLE [dbo].[CollectionSpecimenRelation] WITH NOCHECK ADD CONSTRAINT [FK_CollectionSpecimenRelation_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimenRelation] CHECK CONSTRAINT [FK_CollectionSpecimenRelation_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenRelation_CollSpecimenRelationType_Enum] Skriptdatum: 11/01/2007 10:10:40 ******/ ALTER TABLE [dbo].[CollectionSpecimenRelation] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimenRelation_CollSpecimenRelationType_Enum] FOREIGN KEY([RelationType]) REFERENCES [dbo].[CollSpecimenRelationType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CollectionSpecimenRelation] CHECK CONSTRAINT [FK_CollectionSpecimenRelation_CollSpecimenRelationType_Enum] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenTransaction_CollectionSpecimenPart] Skriptdatum: 11/01/2007 10:10:48 ******/ ALTER TABLE [dbo].[CollectionSpecimenTransaction] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimenTransaction_CollectionSpecimenPart] FOREIGN KEY([CollectionSpecimenID], [SpecimenPartID]) REFERENCES [dbo].[CollectionSpecimenPart] ([CollectionSpecimenID], [SpecimenPartID]) GO ALTER TABLE [dbo].[CollectionSpecimenTransaction] CHECK CONSTRAINT [FK_CollectionSpecimenTransaction_CollectionSpecimenPart] GO /****** Objekt: ForeignKey [FK_CollectionSpecimenTransaction_Transaction] Skriptdatum: 11/01/2007 10:10:48 ******/ ALTER TABLE [dbo].[CollectionSpecimenTransaction] WITH CHECK ADD CONSTRAINT [FK_CollectionSpecimenTransaction_Transaction] FOREIGN KEY([TransactionID]) REFERENCES [dbo].[Transaction] ([TransactionID]) GO ALTER TABLE [dbo].[CollectionSpecimenTransaction] CHECK CONSTRAINT [FK_CollectionSpecimenTransaction_Transaction] GO /****** Objekt: ForeignKey [FK_Identification_CollIdentificationCategory_Enum] Skriptdatum: 11/01/2007 10:12:29 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [FK_Identification_CollIdentificationCategory_Enum] FOREIGN KEY([IdentificationCategory]) REFERENCES [dbo].[CollIdentificationCategory_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [FK_Identification_CollIdentificationCategory_Enum] GO /****** Objekt: ForeignKey [FK_Identification_CollIdentificationDateCategory_Enum] Skriptdatum: 11/01/2007 10:12:29 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [FK_Identification_CollIdentificationDateCategory_Enum] FOREIGN KEY([IdentificationDateCategory]) REFERENCES [dbo].[CollIdentificationDateCategory_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [FK_Identification_CollIdentificationDateCategory_Enum] GO /****** Objekt: ForeignKey [FK_Identification_CollIdentificationQualifier_Enum] Skriptdatum: 11/01/2007 10:12:30 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [FK_Identification_CollIdentificationQualifier_Enum] FOREIGN KEY([IdentificationQualifier]) REFERENCES [dbo].[CollIdentificationQualifier_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [FK_Identification_CollIdentificationQualifier_Enum] GO /****** Objekt: ForeignKey [FK_Identification_CollTypeStatus_Enum] Skriptdatum: 11/01/2007 10:12:30 ******/ ALTER TABLE [dbo].[Identification] WITH NOCHECK ADD CONSTRAINT [FK_Identification_CollTypeStatus_Enum] FOREIGN KEY([TypeStatus]) REFERENCES [dbo].[CollTypeStatus_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [FK_Identification_CollTypeStatus_Enum] GO /****** Objekt: ForeignKey [FK_Identification_IdentificationUnit] Skriptdatum: 11/01/2007 10:12:30 ******/ ALTER TABLE [dbo].[Identification] WITH CHECK ADD CONSTRAINT [FK_Identification_IdentificationUnit] FOREIGN KEY([CollectionSpecimenID], [IdentificationUnitID]) REFERENCES [dbo].[IdentificationUnit] ([CollectionSpecimenID], [IdentificationUnitID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[Identification] CHECK CONSTRAINT [FK_Identification_IdentificationUnit] GO /****** Objekt: ForeignKey [FK_IdentificationUnit_CollCircumstances_Enum] Skriptdatum: 11/01/2007 10:12:52 ******/ ALTER TABLE [dbo].[IdentificationUnit] WITH CHECK ADD CONSTRAINT [FK_IdentificationUnit_CollCircumstances_Enum] FOREIGN KEY([Circumstances]) REFERENCES [dbo].[CollCircumstances_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IdentificationUnit] CHECK CONSTRAINT [FK_IdentificationUnit_CollCircumstances_Enum] GO /****** Objekt: ForeignKey [FK_IdentificationUnit_CollectionSpecimen] Skriptdatum: 11/01/2007 10:12:52 ******/ ALTER TABLE [dbo].[IdentificationUnit] WITH NOCHECK ADD CONSTRAINT [FK_IdentificationUnit_CollectionSpecimen] FOREIGN KEY([CollectionSpecimenID]) REFERENCES [dbo].[CollectionSpecimen] ([CollectionSpecimenID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[IdentificationUnit] CHECK CONSTRAINT [FK_IdentificationUnit_CollectionSpecimen] GO /****** Objekt: ForeignKey [FK_IdentificationUnit_CollTaxonomicGroup_Enum] Skriptdatum: 11/01/2007 10:12:52 ******/ ALTER TABLE [dbo].[IdentificationUnit] WITH NOCHECK ADD CONSTRAINT [FK_IdentificationUnit_CollTaxonomicGroup_Enum] FOREIGN KEY([TaxonomicGroup]) REFERENCES [dbo].[CollTaxonomicGroup_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IdentificationUnit] CHECK CONSTRAINT [FK_IdentificationUnit_CollTaxonomicGroup_Enum] GO /****** Objekt: ForeignKey [FK_IdentificationUnit_CollUnitRelationType_Enum] Skriptdatum: 11/01/2007 10:12:53 ******/ ALTER TABLE [dbo].[IdentificationUnit] WITH CHECK ADD CONSTRAINT [FK_IdentificationUnit_CollUnitRelationType_Enum] FOREIGN KEY([RelationType]) REFERENCES [dbo].[CollUnitRelationType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IdentificationUnit] CHECK CONSTRAINT [FK_IdentificationUnit_CollUnitRelationType_Enum] GO /****** Objekt: ForeignKey [FK_IdentificationUnitAnalysis_IdentificationAnalysis] Skriptdatum: 11/01/2007 10:13:04 ******/ ALTER TABLE [dbo].[IdentificationUnitAnalysis] WITH NOCHECK ADD CONSTRAINT [FK_IdentificationUnitAnalysis_IdentificationAnalysis] FOREIGN KEY([AnalysisID]) REFERENCES [dbo].[Analysis] ([AnalysisID]) GO ALTER TABLE [dbo].[IdentificationUnitAnalysis] CHECK CONSTRAINT [FK_IdentificationUnitAnalysis_IdentificationAnalysis] GO /****** Objekt: ForeignKey [FK_IdentificationUnitAnalysis_IdentificationUnit] Skriptdatum: 11/01/2007 10:13:04 ******/ ALTER TABLE [dbo].[IdentificationUnitAnalysis] WITH CHECK ADD CONSTRAINT [FK_IdentificationUnitAnalysis_IdentificationUnit] FOREIGN KEY([CollectionSpecimenID], [IdentificationUnitID]) REFERENCES [dbo].[IdentificationUnit] ([CollectionSpecimenID], [IdentificationUnitID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[IdentificationUnitAnalysis] CHECK CONSTRAINT [FK_IdentificationUnitAnalysis_IdentificationUnit] GO /****** Objekt: ForeignKey [FK_IdentificationUnitInPart_IdentificationUnit1] Skriptdatum: 11/01/2007 10:13:12 ******/ ALTER TABLE [dbo].[IdentificationUnitInPart] WITH CHECK ADD CONSTRAINT [FK_IdentificationUnitInPart_IdentificationUnit1] FOREIGN KEY([CollectionSpecimenID], [IdentificationUnitID]) REFERENCES [dbo].[IdentificationUnit] ([CollectionSpecimenID], [IdentificationUnitID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[IdentificationUnitInPart] CHECK CONSTRAINT [FK_IdentificationUnitInPart_IdentificationUnit1] GO /****** Objekt: ForeignKey [FK_IdentificationUnitOnPart_CollectionSpecimenPart] Skriptdatum: 11/01/2007 10:13:12 ******/ ALTER TABLE [dbo].[IdentificationUnitInPart] WITH CHECK ADD CONSTRAINT [FK_IdentificationUnitOnPart_CollectionSpecimenPart] FOREIGN KEY([CollectionSpecimenID], [SpecimenPartID]) REFERENCES [dbo].[CollectionSpecimenPart] ([CollectionSpecimenID], [SpecimenPartID]) GO ALTER TABLE [dbo].[IdentificationUnitInPart] CHECK CONSTRAINT [FK_IdentificationUnitOnPart_CollectionSpecimenPart] GO /****** Objekt: ForeignKey [FK_LocalisationSystem_LocalisationSystem] Skriptdatum: 11/01/2007 10:13:34 ******/ ALTER TABLE [dbo].[LocalisationSystem] WITH CHECK ADD CONSTRAINT [FK_LocalisationSystem_LocalisationSystem] FOREIGN KEY([LocalisationSystemParentID]) REFERENCES [dbo].[LocalisationSystem] ([LocalisationSystemID]) GO ALTER TABLE [dbo].[LocalisationSystem] CHECK CONSTRAINT [FK_LocalisationSystem_LocalisationSystem] GO /****** Objekt: ForeignKey [FK_CollectionProcessing_CollectionProcessing] Skriptdatum: 11/01/2007 10:13:48 ******/ ALTER TABLE [dbo].[Processing] WITH NOCHECK ADD CONSTRAINT [FK_CollectionProcessing_CollectionProcessing] FOREIGN KEY([ProcessingParentID]) REFERENCES [dbo].[Processing] ([ProcessingID]) GO ALTER TABLE [dbo].[Processing] CHECK CONSTRAINT [FK_CollectionProcessing_CollectionProcessing] GO /****** Objekt: ForeignKey [FK_ProcessingMaterialCategory_Processing] Skriptdatum: 11/01/2007 10:13:53 ******/ ALTER TABLE [dbo].[ProcessingMaterialCategory] WITH CHECK ADD CONSTRAINT [FK_ProcessingMaterialCategory_Processing] FOREIGN KEY([ProcessingID]) REFERENCES [dbo].[Processing] ([ProcessingID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ProcessingMaterialCategory] CHECK CONSTRAINT [FK_ProcessingMaterialCategory_Processing] GO /****** Objekt: ForeignKey [FK_DiversityProjectUser_DiversityProjectProxy] Skriptdatum: 11/01/2007 10:13:58 ******/ ALTER TABLE [dbo].[ProjectUser] WITH CHECK ADD CONSTRAINT [FK_DiversityProjectUser_DiversityProjectProxy] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[ProjectProxy] ([ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[ProjectUser] CHECK CONSTRAINT [FK_DiversityProjectUser_DiversityProjectProxy] GO /****** Objekt: ForeignKey [FK_ProjectUser_UserProxy] Skriptdatum: 11/01/2007 10:13:58 ******/ ALTER TABLE [dbo].[ProjectUser] WITH NOCHECK ADD CONSTRAINT [FK_ProjectUser_UserProxy] FOREIGN KEY([LoginName]) REFERENCES [dbo].[UserProxy] ([LoginName]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ProjectUser] CHECK CONSTRAINT [FK_ProjectUser_UserProxy] GO /****** Objekt: ForeignKey [FK_Descriptor_Descriptor] Skriptdatum: 11/01/2007 10:14:06 ******/ ALTER TABLE [dbo].[Property] WITH CHECK ADD CONSTRAINT [FK_Descriptor_Descriptor] FOREIGN KEY([PropertyParentID]) REFERENCES [dbo].[Property] ([PropertyID]) GO ALTER TABLE [dbo].[Property] CHECK CONSTRAINT [FK_Descriptor_Descriptor] GO /****** Objekt: ForeignKey [FK_Transaction_Collection] Skriptdatum: 11/01/2007 10:14:29 ******/ ALTER TABLE [dbo].[Transaction] WITH CHECK ADD CONSTRAINT [FK_Transaction_Collection] FOREIGN KEY([FromCollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_Transaction_Collection] GO /****** Objekt: ForeignKey [FK_Transaction_Collection1] Skriptdatum: 11/01/2007 10:14:30 ******/ ALTER TABLE [dbo].[Transaction] WITH CHECK ADD CONSTRAINT [FK_Transaction_Collection1] FOREIGN KEY([ToCollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_Transaction_Collection1] GO /****** Objekt: ForeignKey [FK_Transaction_Collection2] Skriptdatum: 11/01/2007 10:14:30 ******/ ALTER TABLE [dbo].[Transaction] WITH CHECK ADD CONSTRAINT [FK_Transaction_Collection2] FOREIGN KEY([AdministratingCollectionID]) REFERENCES [dbo].[Collection] ([CollectionID]) GO ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_Transaction_Collection2] GO /****** Objekt: ForeignKey [FK_Transaction_CollTransactionType_Enum] Skriptdatum: 11/01/2007 10:14:30 ******/ ALTER TABLE [dbo].[Transaction] WITH CHECK ADD CONSTRAINT [FK_Transaction_CollTransactionType_Enum] FOREIGN KEY([TransactionType]) REFERENCES [dbo].[CollTransactionType_Enum] ([Code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_Transaction_CollTransactionType_Enum] GO /****** Objekt: ForeignKey [FK_Transaction_Transaction] Skriptdatum: 11/01/2007 10:14:31 ******/ ALTER TABLE [dbo].[Transaction] WITH CHECK ADD CONSTRAINT [FK_Transaction_Transaction] FOREIGN KEY([ParentTransactionID]) REFERENCES [dbo].[Transaction] ([TransactionID]) GO ALTER TABLE [dbo].[Transaction] CHECK CONSTRAINT [FK_Transaction_Transaction] GO /****** Objekt: ForeignKey [FK_TransactionDocuments_Transaction] Skriptdatum: 11/01/2007 10:14:39 ******/ ALTER TABLE [dbo].[TransactionDocument] WITH CHECK ADD CONSTRAINT [FK_TransactionDocuments_Transaction] FOREIGN KEY([TransactionID]) REFERENCES [dbo].[Transaction] ([TransactionID]) GO ALTER TABLE [dbo].[TransactionDocument] CHECK CONSTRAINT [FK_TransactionDocuments_Transaction] GO