/****** Object:  Table [dbo].[Exsiccata]    Script Date: 17.06.2019 13:45:41 ******/
CREATE TABLE [dbo].[Exsiccata](
	[ExsiccataID] [int] IDENTITY(1,1) NOT NULL,
	[Version] [int] NULL,
	[ExsAbbreviation] [nvarchar](255) NOT NULL,
	[ExsTitle] [nvarchar](255) NOT NULL,
	[EditingInstitution] [nvarchar](255) NULL,
	[EditingLocationOri] [nvarchar](255) NULL,
	[EditingLocationCurrent] [nvarchar](255) NULL,
	[EditingLocationEnglish] [nvarchar](255) NULL,
	[PrecededBy] [int] NULL,
	[ExsNumberFirst] [nvarchar](20) NULL,
	[ExsNumberLast] [nvarchar](20) NULL,
	[ExsPublYearFirst] [nvarchar](20) NULL,
	[ExsPublYearLast] [nvarchar](80) NULL,
	[Notes] [nvarchar](2000) NULL,
	[Problems] [nvarchar](max) NULL,
	[Bacteria] [smallint] NULL,
	[Fungi] [smallint] NULL,
	[Algae] [smallint] NULL,
	[Bryophytes] [smallint] NULL,
	[Pteridophytes] [smallint] NULL,
	[HigherPlants] [smallint] NULL,
	[Zoocecidia] [smallint] NULL,
	[Educational] [smallint] NULL,
	[Scientific] [smallint] NULL,
	[GroupSpecific] [smallint] NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_Exsiccata] PRIMARY KEY CLUSTERED 
(
	[ExsiccataID] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ExsiccataEditor]    Script Date: 17.06.2019 13:45:42 ******/
CREATE TABLE [dbo].[ExsiccataEditor](
	[ExsiccataID] [int] NOT NULL,
	[Name] [nvarchar](255) NOT NULL,
	[EditorAgentURI] [varchar](255) NULL,
	[Sequence] [datetime] NOT NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_ExsiccataEditor] PRIMARY KEY CLUSTERED 
(
	[Name] ASC,
	[ExsiccataID] 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
/****** Object:  Table [dbo].[ExsiccataExamples]    Script Date: 17.06.2019 13:45:42 ******/
CREATE TABLE [dbo].[ExsiccataExamples](
	[ExsiccataID] [int] NOT NULL,
	[ExampleID] [int] NOT NULL,
	[ImageFile] [nvarchar](255) NULL,
	[ResourceURI] [varchar](255) NULL,
	[PublishedName] [nvarchar](255) NULL,
	[CollectionName] [nvarchar](255) NULL,
	[Number] [nvarchar](50) NULL,
	[StorageLocation] [nvarchar](255) NULL,
	[CollectionSpecimen] [varchar](255) NULL,
	[CollectionSpecimenURI] [varchar](255) NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_ExsiccataExamples] PRIMARY KEY CLUSTERED 
(
	[ExsiccataID] ASC,
	[ExampleID] 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
/****** Object:  Table [dbo].[ExsiccataReference]    Script Date: 17.06.2019 13:45:42 ******/
CREATE TABLE [dbo].[ExsiccataReference](
	[ExsiccataID] [int] NOT NULL,
	[ReferenceTitle] [nvarchar](255) NOT NULL,
	[ReferenceURI] [varchar](255) NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_ExsiccataReference] PRIMARY KEY CLUSTERED 
(
	[ExsiccataID] ASC,
	[ReferenceTitle] 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
/****** Object:  Table [dbo].[ExsiccataRegion]    Script Date: 17.06.2019 13:45:42 ******/
CREATE TABLE [dbo].[ExsiccataRegion](
	[ExsiccataID] [int] NOT NULL,
	[Region] [nvarchar](50) NOT NULL,
	[LogUpdatedWhen] [datetime] NULL,
	[LogUpdatedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_ExsiccataRegion] PRIMARY KEY CLUSTERED 
(
	[ExsiccataID] ASC,
	[Region] 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
ALTER TABLE [dbo].[Exsiccata] ADD  CONSTRAINT [DF_Exsiccata_Version]  DEFAULT ((1)) FOR [Version]
GO
ALTER TABLE [dbo].[Exsiccata] ADD  CONSTRAINT [DF_Exsiccata_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
ALTER TABLE [dbo].[Exsiccata] ADD  CONSTRAINT [DF_Exsiccata_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
ALTER TABLE [dbo].[ExsiccataEditor] ADD  CONSTRAINT [DF_ExsiccataEditor_Sequence]  DEFAULT (getdate()) FOR [Sequence]
GO
ALTER TABLE [dbo].[ExsiccataEditor] ADD  CONSTRAINT [DF_ExsiccataEditor_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
ALTER TABLE [dbo].[ExsiccataEditor] ADD  CONSTRAINT [DF_ExsiccataEditor_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
ALTER TABLE [dbo].[ExsiccataExamples] ADD  CONSTRAINT [DF_ExsiccataExamples_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
ALTER TABLE [dbo].[ExsiccataExamples] ADD  CONSTRAINT [DF_ExsiccataExamples_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
ALTER TABLE [dbo].[ExsiccataReference] ADD  CONSTRAINT [DF_ExsiccataReference_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
ALTER TABLE [dbo].[ExsiccataReference] ADD  CONSTRAINT [DF_ExsiccataReference_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
ALTER TABLE [dbo].[ExsiccataRegion] ADD  CONSTRAINT [DF_ExsiccataRegion_LogUpdatedWhen]  DEFAULT (getdate()) FOR [LogUpdatedWhen]
GO
ALTER TABLE [dbo].[ExsiccataRegion] ADD  CONSTRAINT [DF_ExsiccataRegion_LogUpdatedBy]  DEFAULT (user_name()) FOR [LogUpdatedBy]
GO
ALTER TABLE [dbo].[Exsiccata]  WITH NOCHECK ADD  CONSTRAINT [FK_Exsiccata_Exsiccata] FOREIGN KEY([PrecededBy])
REFERENCES [dbo].[Exsiccata] ([ExsiccataID])
GO
ALTER TABLE [dbo].[Exsiccata] NOCHECK CONSTRAINT [FK_Exsiccata_Exsiccata]
GO
ALTER TABLE [dbo].[ExsiccataEditor]  WITH NOCHECK ADD  CONSTRAINT [FK_ExsiccataEditor_Exsiccata] FOREIGN KEY([ExsiccataID])
REFERENCES [dbo].[Exsiccata] ([ExsiccataID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ExsiccataEditor] CHECK CONSTRAINT [FK_ExsiccataEditor_Exsiccata]
GO
ALTER TABLE [dbo].[ExsiccataExamples]  WITH NOCHECK ADD  CONSTRAINT [FK_ExsiccataExamples_Exsiccata] FOREIGN KEY([ExsiccataID])
REFERENCES [dbo].[Exsiccata] ([ExsiccataID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ExsiccataExamples] CHECK CONSTRAINT [FK_ExsiccataExamples_Exsiccata]
GO
ALTER TABLE [dbo].[ExsiccataReference]  WITH NOCHECK ADD  CONSTRAINT [FK_ExsiccataReference_Exsiccata] FOREIGN KEY([ExsiccataID])
REFERENCES [dbo].[Exsiccata] ([ExsiccataID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ExsiccataReference] CHECK CONSTRAINT [FK_ExsiccataReference_Exsiccata]
GO
ALTER TABLE [dbo].[ExsiccataRegion]  WITH NOCHECK ADD  CONSTRAINT [FK_ExsiccataRegion_Exsiccata] FOREIGN KEY([ExsiccataID])
REFERENCES [dbo].[Exsiccata] ([ExsiccataID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ExsiccataRegion] CHECK CONSTRAINT [FK_ExsiccataRegion_Exsiccata]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the exsiccata (primary key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsiccataID'
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'Exsiccata', @level2type=N'COLUMN',@level2name=N'Version'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Std. abbreviation (authors/editors, std. abbrev. of title)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsAbbreviation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Exact title (create a new entry if title spelling changed considerably, link entries using PrecededBy/SupersededBy)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Issuing/Editing institution (If no editors are known, at least this must be entered)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'EditingInstitution'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Original spelling of city/country where the exsiccata has been issued' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'EditingLocationOri'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current spelling of city/country where the exsiccata has been issued' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'EditingLocationCurrent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current English spelling of city/country where the exsiccata has been issued' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'EditingLocationEnglish'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An earlier exsiccata publication appeared under different title or editors (Reference to entry in this database)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'PrecededBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If known: number of the first exsiccata that was issued by the current editors under the current title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsNumberFirst'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If known: number of the last exssiccata that was issued by the current editors under the current title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsNumberLast'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If known: publication year of the first exsiccata that was issued by the current editors under the current title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsPublYearFirst'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'If known: publication year of the last exsiccata that was issued by the current editors under the current title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'ExsPublYearLast'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Annotation, please add your name and a date for each annotation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Please explain here if you have a problem, this field will later be checked' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Problems'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers pteridophytes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Bacteria'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers fungal species (default) 1 or -1= Yes it does, 0=No it does not, Null/empty = don''t know' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Fungi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers Algae/Cyanophyta' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Algae'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers mosses/bryophytes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Bryophytes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers pteridophytes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Pteridophytes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers higher plants' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'HigherPlants'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'check if exsiccata covers galls on plants caused by animals' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Zoocecidia'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Educational purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don''t know' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Educational'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Scientific purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don''t know' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'Scientific'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Exsiccata is restricted to a taxonomic entity or ecologically delimited group, e.g. family or lichens on leaves, 1 or -1= Yes, 0=No, Null/empty = don''t know' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata', @level2type=N'COLUMN',@level2name=N'GroupSpecific'
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'Exsiccata', @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'Exsiccata', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An Exsiccata is a series of specimen issued in a publication like form.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Exsiccata'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Reference to ExsiccataID in Exsiccata (foreign Key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataEditor', @level2type=N'COLUMN',@level2name=N'ExsiccataID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Enter as last name, comma, first names, use blanks after comma and period' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataEditor', @level2type=N'COLUMN',@level2name=N'Name'
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'ExsiccataEditor', @level2type=N'COLUMN',@level2name=N'EditorAgentURI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(automatically set during entry, to maintain the sequence of editors)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataEditor', @level2type=N'COLUMN',@level2name=N'Sequence'
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'ExsiccataEditor', @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'ExsiccataEditor', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The editors that published an exsiccatal series.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataEditor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Reference to ExsiccataID in Exsiccata (foreign Key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'ExsiccataID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A number that defines the sequence in which the examples have been added.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'ExampleID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Example: Path and file name for an image of the label of the exsiccata example issue' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'ImageFile'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optionally: The URI under which the image is recoded in e.g. DiversityResources.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @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'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'ResourceURI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Example: Published taxon name of example issue' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'PublishedName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Example: Name or Acronym of collection where the example issue is available. Default is M for München' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'CollectionName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Example: Number of example issue within the exsiccata series' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'Number'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Example: Deposited under (scientific name indicating a storage location)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'StorageLocation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optionally: The Display text of the example specimen as recorded in e.g. DiversityCollection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'CollectionSpecimen'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Optionally: The URI under which the example specimen is recorded in e.g. DiversityCollection' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'CollectionSpecimenURI'
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'ExsiccataExamples', @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'ExsiccataExamples', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Examples for an exsiccatal series.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataExamples'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Reference to ExsiccataID in Exsiccata (foreign Key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataReference', @level2type=N'COLUMN',@level2name=N'ExsiccataID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the publication where information on the exiccata was published. Note this is only a cached value where ReferenceURI is present' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataReference', @level2type=N'COLUMN',@level2name=N'ReferenceTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'URI (e.g. LSID) of reference where information on the exsiccata was published, e.g. referring to the module DiversityReferences' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataReference', @level2type=N'COLUMN',@level2name=N'ReferenceURI'
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'ExsiccataReference', @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'ExsiccataReference', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The references where an exsiccatal series is listed.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataReference'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Reference to ExsiccataID in Exsiccata (foreign Key)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataRegion', @level2type=N'COLUMN',@level2name=N'ExsiccataID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A region where the specimens within the exsiccata were collected.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataRegion', @level2type=N'COLUMN',@level2name=N'Region'
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'ExsiccataRegion', @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'ExsiccataRegion', @level2type=N'COLUMN',@level2name=N'LogUpdatedBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The geographic regions that are covered by the specimen within an exsiccatal series.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ExsiccataRegion'
GO