/* SQL DDL: Create an implementation of the model using the SQL Data Definition Language */ /* Note: Comments such as this may not be supported by your system and may have to be removed */ /* You may want to change some field types to improve the implementation on your DBMS. */ /* Data type 'National Character' etc. indicates Unicode text. /* Note: Tested with MS SQL Server 2000 and PostgreSQL. Originally this file attempted to use */ /* Standard SQL for both. However, a common denominator could not be found. A special PostgreSQL file */ /* named '...SQL.Postgres' instead of '...SQL.txt' is now created in addition to the current file. */ /* The current file aims at SQL-Server dialects (but uses SQL92 whereever possible). The following changes may have to be made: */ /* Standard SQL 92: replace the data type BIT with SQL92 BOOLEAN */ /* MS SQL Server 2000: replace the SQL92 constant 'current_timestamp' with 'GETDATE()' (= date and time) */ /* MS SQL Server 2000: remove comments around the block of 'exec' statements at end of file to enable creation of column descriptions */ /* Note: CREATE INDEX statements (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */ /* Generated on 28.Sep.2003 10:28 by Diversity Information Model Documenter 2.5 (G. Hagedorn) */ /*=== Table: ResourceCollection ===*/ /* Defines common properties for a set of related information resources of various quality levels. A collection is defined by management (managing users, storage locations, etc.). Compare 'Presentation' for thematic collections! */ /* ResourceCollectionID: Resource collection ID, unique system generated value (primary key). */ /* Title: Unique user readable title, identifying the resource collection. Example: 'Ascochyta images from Melnik (1977)'. */ /* Description: Short description of the resource collection, ca. a single paragraph long. Basic xhtml formatting tags are permitted. */ /* Coverage: The extent or scope of the content of the resource. Coverage will typically include spatial location (e.g. a place name), temporal period (a period label, date, or date range) or taxonomic group [DC 1.1!] */ /* Authors: A list of authors displayed on the title page of the entire collection. Authors or editors of a collection need not be identical with resource managers, or creators of resources. */ /* Editors: A list of editors displayed on the title page of the entire collection. The creators of a resource collection can decide whether they are Authors or Editors, but at least one of the two must be used. */ /* Contributors: A list of contributors displayed on the title page of the entire collection. */ /* SourceDescription: Where applicable, a general description of the source or origin of the resources covered in the current collection. Compare SourceReferenceID if source is a publication. */ /* SourceReferenceID: For resources that are present in published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Example: 'ABE_1990_MPL' for figures from a book recorded under this ID. */ /* SourceRefDescriptionCache: A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem. */ /* AcknowledgementID: Refers to an acknowledgement definition that documents source and intellectual property rights, and provides a formatted acknowledgement (foreign key). */ /* Rights: If not already covered by acknowledgment: documentation of copyright or usage agreements, including dates and the name of the responsible person or institution with which an agreement was reached. */ /* InternalNotes: Internal notes and remarks. Not published in public reports. */ /* IconURI: URI of a icon or logo, usually a small gif file that can be displayed next to the collection title. */ /* IconLinkURI: A URI that may optionally be placed behind the collection icon, to create a hyperlink to another site on the world-wide-web. */ /* IconLinkHidden: True = no link border around icon image (default); False = a colored link border is added around icon image. */ /* IconDescription: Text used for the alternative text of the image; usually this text is also displayed when the mouse hovers over the image. */ /* IconWidth: Width of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no width is available. */ /* IconHeight: Height of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no height is available. */ /* ReleaseDate: A date which may be up to 1 year in the future to prevent public access to the resource collection prior to this date (set by the managers of the collection). */ /* ReleaseNotes: Required whenever ReleaseDate postpones the public release: Documentation of the motives for the postponement, and name of responsible user (esp. if multiple collection managers exist). */ /* ManagedContent: True: the organization hosting the DiversityResources metadata management application is also legally responsible for the server from which the resource content is provided. Editable only by site managers, not by resource collection managers! */ /* EditorialControl: True if editorial control is required (always necessary for managed content). Editable only by site managers, not by resource collection managers! If set to false, EditorialReleaseBy/When are updated to document decisions. */ /* EditorialControlDelegated: Default is false = only site managers can set EditorialRelease, if true EditorialRelease can be set by all managers of the resource collection. Editable only by site managers, not by resource collection managers! */ /* EditorialControlDocumentation: If EditorialControl is false or EditorialControlDelegated true, a documentation about the rejection or delegation is required. In the case of a delegation the responsibility must accepted a signed paper or agreement by email exchange should be cited. */ /* EditorialControlSetBy: The responsible site manager who delegated the editorial control. Editable only by site managers, not by resource collection managers! */ /* EditorialControlSetWhen: Date/time when the EditorialControl was delegated. */ /* EditorialReleaseBy: The editorial review mechanism guarantees that no unwanted information is presented on the website. Important for images uploaded by external users. Editability depends on EditorialControlDelegated attribute. */ /* EditorialReleaseWhen: Date/time up to which the all resources in the collection have been reviewed and found suitable for public release. Instances added at a later date are automatically prevented from being available in the internet. Editability like EditorialReleaseBy. */ /* CheckAvailability_LastTestWhen: The data and time when the last routine availability check of all resource instances of this collection was performed. Compare also CheckAvailability_LastTestWhen of individual resource instances. */ /* CheckAvailability_Interval: The number of days after which a routine availability check of all resource instances shall be performed. Set to 999999 to disable routine test. */ /* IsTemplate: True for templates used to create a new resource collection together with the relevant resource classes. System attribute, not user editable, default is false. */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. Also serves as publication date of the collection (use of ReleaseDate is not indicated, may later be changed to temporarily lock the collection). */ CREATE TABLE ResourceCollection ( ResourceCollectionID INTEGER NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(80) NOT NULL UNIQUE, Description NATIONAL TEXT NOT NULL, Coverage NATIONAL TEXT NULL, Authors NATIONAL CHARACTER VARYING(255) NULL UNIQUE, Editors NATIONAL CHARACTER VARYING(255) NULL UNIQUE, Contributors NATIONAL CHARACTER VARYING(255) NULL, SourceDescription NATIONAL TEXT NULL, SourceReferenceID NATIONAL CHARACTER VARYING(20) NULL, SourceRefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, AcknowledgementID INTEGER NULL, Rights NATIONAL TEXT NULL, InternalNotes NATIONAL TEXT NULL, IconURI NATIONAL CHARACTER VARYING(255) NULL, IconLinkURI NATIONAL CHARACTER VARYING(255) NULL, IconLinkHidden BIT NOT NULL DEFAULT 1, IconDescription NATIONAL CHARACTER VARYING(100) NULL, IconWidth INTEGER NOT NULL DEFAULT 0, IconHeight INTEGER NOT NULL DEFAULT 0, ReleaseDate DATETIME NOT NULL DEFAULT current_timestamp, ReleaseNotes NATIONAL CHARACTER VARYING(255) NULL, ManagedContent BIT NOT NULL DEFAULT 0, EditorialControl BIT NOT NULL DEFAULT 1, EditorialControlDelegated BIT NOT NULL DEFAULT 0, EditorialControlDocumentation NATIONAL TEXT NULL, EditorialControlSetBy INTEGER NULL, EditorialControlSetWhen DATETIME NULL, EditorialReleaseBy INTEGER NULL, EditorialReleaseWhen DATETIME NULL, CheckAvailability_LastTestWhen DATETIME NOT NULL DEFAULT 0, CheckAvailability_Interval SMALLINT NOT NULL DEFAULT 60, IsTemplate BIT NOT NULL DEFAULT 0, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp ); /*=== Table: ResourceCollectionManager ===*/ /* A resource manager defines one or several persons that manage a ResourceCollection. Multiple resource managers can share the management responsibility equally, but no prioritization is yet possible. */ /* ResourceCollectionID: ID of the resource collection (foreign key). */ /* ManagingUserID: ID of user who may manages the resource information in the resource collection (foreign key, referring to DiversityUsers.UserID). */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. */ CREATE TABLE ResourceCollectionManager ( ResourceCollectionID INTEGER NOT NULL, ManagingUserID INTEGER NOT NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceCollectionID,ManagingUserID) ); /*=== Table: ResourceQualityClass ===*/ /* Quality classes contains instances of abstract items. Defined separately for each resource collection, but collectively for all providers. Examples of quality classes are preview or thumbnail versions, compressed versions, or high quality versions. */ /* ResourceCollectionID: Refers to a resource collection (foreign key and part of primary key). */ /* QualityLevel: A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key). */ /* OnlineAvailability: Online availability scope (managers, login, intranet, internet) of resource instances of this quality class (also restricted by ItemOnlineAvailability of abstract item!). */ /* RequestAvailability: Availabilty scope of meta information (description, keywords); access information (URI) is available only on explicit request by electronic or postal means (also restricted by ItemRequestAvailability of abstract item!). */ /* URI_Part2: Optional string, inserted between URI_Part1 (see ResourceProvider) and the individual resource name URI_Part3 (see ResourceAbstractItem). */ /* URI_Part4: Optional string, appended to the individual resource name (URL_Part3). This may be part of the filename + quality-level typical extension, e.g. '_thumbn.gif. */ /* RecommendedPresentation: Recommended presentation mode (Link, New-window-link, Download, Embed). The web interface may either follow the recommendation or implement its own rules. */ /* AutoGenerateMethodID: Defines a method used to automatically generate instances for this class based on another resource class (usually of higher quality level). ID = 0 disables autogeneration. */ /* InternalNotes: Internal notes regarding this quality version of the resource (history of editing, steps taken to generate this version, compression rate, etc.). */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceQualityClass ( ResourceCollectionID INTEGER NOT NULL, QualityLevel INTEGER NOT NULL, OnlineAvailability TINYINT NOT NULL DEFAULT 9, RequestAvailability TINYINT NOT NULL DEFAULT 9, URI_Part2 NATIONAL CHARACTER VARYING(255) NULL, URI_Part4 NATIONAL CHARACTER VARYING(255) NULL, RecommendedPresentation NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'L', AutoGenerateMethodID INTEGER NOT NULL DEFAULT 0, InternalNotes NATIONAL CHARACTER VARYING(255) NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NOT NULL, LogUpdatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceCollectionID,QualityLevel) ); /*=== Table: ResourceProvider ===*/ /* Defines providers (primary/backup mirror/load balancing mirrors, online/offline status, etc.) of the content of a resource collection. */ /* ResourceCollectionID: Refers to a resource collection (foreign key and part of primary key). */ /* ProviderOrder: Number defining the order in which mirrored backup providers are accessed. Unique within a ResourceCollection (part of primary key). */ /* Status: Defines status as: Online primary location, Online load balancing, Online backup/mirror, Offline backup. */ /* URI_Part1: The first part of the URI, before the variable part defined in the individual resource. It should include protocol, server, and beginning of path. Example: 'http://www.example.net/images'. */ /* URI_Part1_Write: An alternative version of the first part of the URI, allowing write access (e.g. for updating mirrors or autogenerating instances). Example: 'user:pass@ftp://www.example.net/images'. URI_Part1 may rarely allow write access, URI_Part_Write always does. */ /* InternalNotes: Internal notes and remarks. */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceProvider ( ResourceCollectionID INTEGER NOT NULL, ProviderOrder INTEGER NOT NULL DEFAULT 1, Status NATIONAL CHARACTER VARYING(1) NOT NULL, URI_Part1 NATIONAL CHARACTER VARYING(255) NULL, URI_Part1_Write NATIONAL CHARACTER VARYING(255) NULL, InternalNotes NATIONAL TEXT NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NOT NULL, LogUpdatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceCollectionID,ProviderOrder) ); /*=== Table: ResourceAbstractItem ===*/ /* The abstract resource item defines general information that applies to all duplicates or quality versions of a resource . */ /* ResourceID: Unique system generated value (primary key). Resource ID is a public ID. It may be stored outside of DiversityResources and should therefore not be changed after creation. */ /* ResourceCollectionID: Each resource belongs to a single resource collection (foreign key). The res. collection supplies general information not present in each item. */ /* URI_Part3: The part of the URI that is specific to the abstract resource item (applicable to all quality instances of the item). Inserted between the optional Class attributes URI_Part2 & Part4. Example: 'figure13.gif'. Required even if URI_ManualOverride is used. */ /* ItemOnlineAvailability: Online availability scope (managers, login, intranet, internet) of resource instances of this abstract item (also restricted by OnlineAvailability of resource class!). */ /* ItemRequestAvailability: Availabilty scope of meta information (description, keywords); access information (URI) is available only on explicit request by electronic or postal means (also restricted by RequestAvailability of resource class!). */ /* NumberingCategory: For reports where the resource will be embedded in another document: Defines a numbering sequence category (fig., tab., etc.) to be used. */ /* LinkAssociatedIcon: Optional for hyperlinks: Complete URI of an icon that shall be displayed in addition to the text link (e.g. icon of a online journal, computer application, etc.). */ /* UpdateStatus: The update status (normal, new, updated) of a resource can be defined; this can be used to automatically add appropriate icons to alert users to changes. */ /* SourceReferenceID: For resources from published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Compare also ResourceCollection.SourceReferenceID! */ /* SourceRefDescriptionCache: A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem. */ /* SourceDetail: Information how to locate original information in source, esp. page numbers. Do not add 'page' or 'p.' for page numbers (incl. roman numbers) -- Specimen/culture collections: accession number or storage location code. */ /* SourceLabel: An identifier code used in the source from which a digitized resource is derived. This may, e. g. be the slide number of a digitized slide, or the page and figure number in a publication. */ /* SourceOrder: For resources from published sources: An ascending number reflecting the sequence of resources in the source. */ /* SourceCaption: The full, unchanged text of the original caption of the resource in the source, esp. in the case of images (if resource has fragments/parts, the captions of all fragments are entered here). */ /* RatingCountCache: The number of times this item was rated. */ /* RatingAverageCache: The average rating score as obtained by averaging all values in ResourceAbstractItem_Rating for this abstract item. */ /* _ParentResourceID: Optional: if the current resource is a modified version derived from another resource available in the system, this points to the original resource (ResourceID foreign key) [** not implemented, prepared for future versions**] */ /* IsTemplate: Defines a template for new abstract items. Default is false, should be true only a single time within each collection. A template may already include dependent records for descriptions, taxa, and keywords. */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceAbstractItem ( ResourceID INTEGER NOT NULL PRIMARY KEY, ResourceCollectionID INTEGER NOT NULL, URI_Part3 NATIONAL CHARACTER VARYING(255) NOT NULL, ItemOnlineAvailability TINYINT NOT NULL DEFAULT 9, ItemRequestAvailability TINYINT NOT NULL DEFAULT 9, NumberingCategory TINYINT NOT NULL DEFAULT 0, LinkAssociatedIcon NATIONAL CHARACTER VARYING(255) NULL, UpdateStatus TINYINT NOT NULL DEFAULT 0, SourceReferenceID NATIONAL CHARACTER VARYING(20) NULL, SourceRefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, SourceDetail NATIONAL CHARACTER VARYING(50) NULL, SourceLabel NATIONAL CHARACTER VARYING(255) NULL, SourceOrder INTEGER NULL, SourceCaption NATIONAL TEXT NULL, RatingCountCache INTEGER NOT NULL DEFAULT 0, RatingAverageCache FLOAT(7) NOT NULL DEFAULT 0, _ParentResourceID INTEGER NULL, IsTemplate BIT NOT NULL DEFAULT 0, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp ); /*=== Table: ResourceAbstractItem_Rating ===*/ /* Individual rating scores of abstract item (relating to content, not presentation quality!). */ /* ResourceID: Unique system generated value (primary key). Resource ID is a public ID. It may be stored outside of DiversityResources and should therefore not be changed after creation. */ /* EntryDate: Time when the rating was entered. */ /* Rating: A numerical rating value. */ /* RatingComment: An optional comment associated with a rating. */ /* RatingID: Internal unique primary key number. */ CREATE TABLE ResourceAbstractItem_Rating ( ResourceID INTEGER NOT NULL, EntryDate DATETIME NOT NULL DEFAULT current_timestamp, Rating INTEGER NOT NULL DEFAULT 0, RatingComment NATIONAL CHARACTER VARYING(255) NULL, RatingID INTEGER IDENTITY NOT NULL PRIMARY KEY ); /*=== Table: ResourceDescription ===*/ /* Description of an entire resource (or an optional resource fragment). The entity combines the description and the resource fragment definition, which could also be modeled in a 1:1 relationship. */ /* ResourceID: ID of external resource to which this description applies (foreign key). */ /* FragmentID: A number that is unique within a resource ID, identifying the resource fragment. Use '0' for entire resource. The FragmentID is used by external modules to identify a resource fragment and should therefore not be changed after creation. */ /* FragmentLabel: For fragments of resources: label identifying resource part, fragment, or component (e.g. figures in a composite image labeled a, b, etc.; tracks on audio resources, etc.). Use description like 'top', 'left side', etc. for unlabeled parts! */ /* FragmentStart: Optional: Definition in technical units of the start of this part of a multipart resource. Empty for entire resource! Use percent of height/width for images (not pixel, they are quality dependent!), seconds for audio/video, bookmark-code for text, etc. */ /* FragmentEnd: Optional: Definition in technical units of the end of this part of a multipart resource. Empty for entire resource! Compare FragmentStart for examples of technical units. */ /* Creator: Optional: Author(s), photographer, director, etc. Person(s) or institution(s) responsible for the creation of the abstract resource item (not of the instance, e.g. a scan of an image). [DC11!] */ /* CreationDate: Creation date (optionally also time) of the original resource. For digitized resources this should refer to the original creation (of the abstract item, e.g. when picture was drawn or photographed), not the digitization process. */ /* CreationMetadata: Optional: additional information regarding the creation process, e.g. image lens, scale, exposure time, etc. */ /* Rights: Optional: Information about rights (copyright, intellectual property) held in and over the resource. Enter esp. name of person or institution holding the copyright. Leave empty if unknown or if rights are globally described in resource collection. [DC11!] */ /* Language: Language of the resource itself. Empty = not yet analysed; hyphen ('-') = language neutral (e.g. images without text). Compare also language of resource title or description meta data under DescriptionTranslation. 2 letter ISO code of language [DC 1.1!] */ /* InternalNotes: Internal notes, applying to the entire resource or parts of the resource. Visible only to managers of the resource collection. */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceDescription ( ResourceID INTEGER NOT NULL, FragmentID INTEGER NOT NULL DEFAULT 0, FragmentLabel NATIONAL CHARACTER VARYING(255) NOT NULL DEFAULT '-', FragmentStart NATIONAL CHARACTER VARYING(255) NULL, FragmentEnd NATIONAL CHARACTER VARYING(255) NULL, Creator NATIONAL CHARACTER VARYING(255) NULL, CreationDate DATETIME NULL, CreationMetadata NATIONAL TEXT NULL, Rights NATIONAL TEXT NULL, Language NATIONAL CHARACTER VARYING(2) NULL, InternalNotes NATIONAL TEXT NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceID,FragmentID) ); /*=== Table: ResourceDescriptionTranslation ===*/ /* Defines language specific, translatable elements associated with a resource item. The web interface supports any language for which the language or audience specific elements have been defined for the requested resource items. */ /* ResourceID: ID of external resource to which this description applies (foreign key). */ /* FragmentID: ID of fragment ('0' for entire resource) to which the display element applies (foreign key). */ /* Language: Language of the current title, description, keywords, etc. (i.e. language of meta data to the resource object; the language of the resource itself is defined in xxx). 2 letter ISO code of language [DC 1.1!] */ /* Title: A title for the resource item, esp. used as link text if hyperlink to resource is created. If possible, the title should be unique within a resource collection (not enforced!) [DC 1.1!] */ /* Description: Short description of the entire resource, primarily intended for use in hyperlink lists. Basic xhtml character formatting tags may be used. If no separate Caption is used, this is also used as caption for embedded resources [DC 1.1!] */ /* Caption: Optional: If Description does not already provides an adequate caption for embedded resource display, a caption may be defined here. Basic xhtml formatting tags may be used. For images: the measurement scale (example: 'bar=10 µm') should be included here. */ /* DisplayOrderOverride: Normally the attribute is empty and resources are sorted by title. If filled, used to sort resources in a presentation. Example: 'The Area of New York' shall be sorted under 'New York''. Numbers are sorted as text, i.e. '10'<'9', use '09', '10'! */ /* DisplayOrderCache: Computed field, set to DisplayOrderOverride if present, otherwise to Title. The cache is introduced to allow indexing and fast sorting. */ /* LogUpdatedBy: The user who created/updated the keyword. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceDescriptionTranslation ( ResourceID INTEGER NOT NULL, FragmentID INTEGER NOT NULL DEFAULT 0, Language NATIONAL CHARACTER VARYING(2) NOT NULL DEFAULT 'en', Title NATIONAL CHARACTER VARYING(255) NOT NULL, Description NATIONAL TEXT NULL, Caption NATIONAL TEXT NULL, DisplayOrderOverride NATIONAL CHARACTER VARYING(255) NULL, DisplayOrderCache NATIONAL CHARACTER VARYING(255) NULL, LogUpdatedBy INTEGER NOT NULL, LogUpdatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceID,FragmentID,Language) ); /*=== Table: ResourceKeyword ===*/ /* Resource management subsystem: Keywords (general keywords applicable to the entire resource, not taxon-specific). */ /* ResourceID: ID of external resource to which the keyword applies (foreign key). */ /* FragmentID: ID of fragment ('0' for entire resource) to which the keyword applies (foreign key). */ /* Keyword: A keyword, including subject headings or private markers. A keyword entry may consist of multiple words or phrases (e. g. 'red herring'). */ /* LogUpdatedBy: The user who created/updated the keyword. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceKeyword ( ResourceID INTEGER NOT NULL, FragmentID INTEGER NOT NULL DEFAULT 0, Keyword NATIONAL CHARACTER VARYING(255) NOT NULL, LogUpdatedBy INTEGER NOT NULL, LogUpdatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceID,FragmentID,Keyword) ); /*=== Table: ResourceTaxon ===*/ /* Defines organism names, features or characteristics of the organism, and topics (nomenclature, description, distribution, etc.) covered. */ /* ResourceID: ID of external resource to which the taxon applies (foreign key). */ /* FragmentID: ID of fragment ('0' for entire resource) to which the taxon applies (foreign key). */ /* RecordID: Internal number providing a primary key. A combined primary key would be ResourceID, FragmentID, and either TaxonomicName or VernacularName (one of which must be filled). Such an alternative use of fields is, however, not possible in a primary key. */ /* TaxonomicName: Scientific name of taxon (if possible include authors). Any name can be entered, regardless of whether it is present in taxonomy or not. */ /* VernacularName: Non-scientific name of organism (e.g. 'white fir') or non-taxonomic name ('conifer', 'hardwood'). */ /* NomID: Unique ID code of the taxon. Refers to the NomID code of TaxonomyName (= foreign key) in the database DiversityTaxonomy. */ /* IdentificationQualifier: Qualification of the identification e.g. 'cf.', 'aff.', 'sp. nov.'. */ /* IdentificationResponsible: 'ORIGINAL' = according to original description (e.g. publication), else name of person responsible for a later identification. */ /* FeatureList: Semicolon-separated list of features of the taxon, e.g. 'ascomata; asci; ascospores; germination'. */ /* _TopicNomenclature: *** All fields starting with underscore are present only as a reminder, not yet decided upon! */ /* _TopicDescription: 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. */ /* _TopicGeography: 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. */ /* _TopicPhylogeny: 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. */ /* _IDQuality: *** assessment of identification quality? */ /* _IDQualityResponsible: *** person responsible for setting IDQuality? */ /* LogUpdatedBy: The user who created/updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceTaxon ( ResourceID INTEGER NOT NULL, FragmentID INTEGER NOT NULL DEFAULT 0, RecordID INTEGER IDENTITY NOT NULL PRIMARY KEY, TaxonomicName NATIONAL CHARACTER VARYING(255) NULL, VernacularName NATIONAL CHARACTER VARYING(255) NULL, NomID INTEGER NULL, IdentificationQualifier NATIONAL CHARACTER VARYING(10) NULL, IdentificationResponsible NATIONAL CHARACTER VARYING(50) NOT NULL DEFAULT ='Original', FeatureList NATIONAL TEXT NULL, _TopicNomenclature INTEGER NULL DEFAULT 0, _TopicDescription INTEGER NULL DEFAULT 0, _TopicGeography INTEGER NULL DEFAULT 0, _TopicPhylogeny INTEGER NULL DEFAULT 0, _IDQuality NATIONAL CHARACTER VARYING(255) NULL, _IDQualityResponsible NATIONAL CHARACTER VARYING(255) NULL, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp ); /*=== Table: ResourceInstance ===*/ /* Resource instances define attributes that apply to a specific quality instance of an abstract information resource. Inherits information from collection, abstract item, provider, and quality class. */ /* ResourceID: ID of external resource to which this association applies (foreign key and part of primary key). */ /* ResourceCollectionID: Refers to a resource collection (foreign key and part of primary key). */ /* ProviderOrder: Refers to one of possible several resource providers within a resource collection (foreign key and part of primary key). */ /* QualityLevel: A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key). */ /* URI_ManualOverride: If this attribute is filled with a complete URI, it is directly used, ignoring URI_Part1 to URI_Part4. */ /* URI_Cache: The complete URI address. If URI_ManualOverride is empty, it is generated from URI_Part1 to URI_Part4 (for digital resources that are available online). */ /* OnlineAvailabilityCache: (calculated value; = Min(Class.OnlineAvailability, ItemOnlineAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)). */ /* RequestAvailabilityCache: (calculated value; = Min(Class.RequestAvailability, ItemRequestAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)). */ /* CheckAvailability_LastResult: The result of the last availability test (set by a link checking program). */ /* CheckAvailability_LastStatusCode: Http status code of last availability test as defined in RFC 2616; contains 0 if status code not applicable (e. g. non-http request) or not evaluated (set by a link checking program). */ /* CheckAvailability_LastTestWhen: The date and time the availability was last tested (set by a link checking program). A standard testing cycle might retest every 3-6 days. The date is no longer updated when instance is deactivated. */ /* CheckAvailability_LastSuccessWhen: The date and time when the availability test result was positive the last time (set by a link checking program). */ /* CheckAvailability_Deactivated: Automatically deactivated if LastResult is negative and LastSuccessWhen more than 14 days ago (set by a link checking program). Date and time when the resource instance was deactivated can be found in CheckAvailability_LastTestWhen. */ /* CheckAvailability_Attempts: The total number of availability tests since the last ResetWhen (set by a link checking program). */ /* CheckAvailability_Failures: The total number of failed availability tests since the last ResetWhen (set by a link checking program). */ /* CheckAvailability_ResetWhen: Date and time when the attributes Attempts and Failures were last reset to 0 (automatically set by the reset routine of the link checking program). */ /* MediaTypeID: Media type according to MIME, refers to RscMediaType_Enum (foreign key). May be determined based on information in http requests or using recognized file extension (compare RscMediaTypeExtension_Enum). 0 indicates an unknown media type. */ /* ContentLength: Size of resource in bytes: file size or content length of download stream. The information is used to add size indications to links, helping resource consumers to make appropriate choices. The value is -1 if the size is unknown. */ /* LastModified: Last-Modified date obtained during resource request (e. g. from http-header). Used to identify updated instances and update attributes that can be automatically obtained (e.g. size, pixel, etc.). */ /* ImgPixelHeight: Optional for images: The height/width in pixel; esp. used for internet presentations; pages can be displayed better if height is known before the image is fully loaded. The value is 0 if the height is not available. */ /* ImgPixelWidth: Optional for images: The height/width in pixel; esp. used for internet presentations; pages can be displayed better if height is known before the image is fully loaded. The value is 0 if the width is not available. */ /* ImgColorDepth: Optional for images: The color depth in bits/pixel. The value is 0 if the color depth is not available. */ /* LogUpdatedWhen: The date and time when this record was last updated. The creation time is not recorded, since instance records are automatically created and deleted with item, provider, or quality class records. */ CREATE TABLE ResourceInstance ( ResourceID INTEGER NOT NULL, ResourceCollectionID INTEGER NOT NULL, ProviderOrder INTEGER NOT NULL, QualityLevel INTEGER NOT NULL, URI_ManualOverride NATIONAL CHARACTER VARYING(255) NULL, URI_Cache NATIONAL CHARACTER VARYING(255) NULL, OnlineAvailabilityCache TINYINT NOT NULL DEFAULT 0, RequestAvailabilityCache TINYINT NOT NULL DEFAULT 0, CheckAvailability_LastResult BIT NOT NULL, CheckAvailability_LastStatusCode SMALLINT NOT NULL DEFAULT 0, CheckAvailability_LastTestWhen DATETIME NOT NULL DEFAULT 0, CheckAvailability_LastSuccessWhen DATETIME NOT NULL DEFAULT 0, CheckAvailability_Deactivated BIT NOT NULL DEFAULT 0, CheckAvailability_Attempts INTEGER NOT NULL DEFAULT 0, CheckAvailability_Failures INTEGER NOT NULL DEFAULT 0, CheckAvailability_ResetWhen DATETIME NOT NULL DEFAULT current_timestamp, MediaTypeID SMALLINT NOT NULL DEFAULT 0, ContentLength INTEGER NOT NULL DEFAULT -1, LastModified DATETIME NOT NULL DEFAULT #12/30/1899#, ImgPixelHeight SMALLINT NOT NULL DEFAULT 0, ImgPixelWidth SMALLINT NOT NULL DEFAULT 0, ImgColorDepth SMALLINT NOT NULL DEFAULT 0, LogUpdatedWhen DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceID,ResourceCollectionID,ProviderOrder,QualityLevel) ); /*=== Table: RscAutoGenerateMethod_Enum ===*/ /* Definitions how to create automatically generate instances for resource quality classes based on other classes. */ /* AutoGenerateMethodID: Unique ID for the autogeneration method (primary key). The method with ID=0 is special, it defines "autogeneration is disabled". */ /* Title: User readable, short and unique description of autogeneration method. */ /* ImgPixelExtension: Maximum extension (height or width) of autogenerated images in pixel. The other dimension will be scaled so that the aspect ratio remains constant. AutoGeneratePixelHeight/Width should both be 0. */ /* ImgPixelHeight: Height of autogenerated images in pixel. Enter 0 to keep aspect ratio of the image and resize based on width. AutoGeneratePixelExtension should be = 0 if used. */ /* ImgPixelWidth: Width of autogenerated images in pixel. Enter 0 to keep aspect ratio of the image and resize based on heigth. AutoGeneratePixelExtension should be = 0 if used. */ /* ImgCropping: Border around the original image in percent to be cropped, cropping occurs before reducing the size as requested in ImgPixelExtension/Height/Width. In a 1000x500 pixel image, ImgCropping=10 will leave 900 x 450 pixel after cropping (5% left, 5% right). */ /* ImgColorDepth: If autogeneration is requested: The color depth in bits/pixel. The value 0 indicates that the color depth shall remain unchanged. */ /* ImgGrayscale: True if image shall be gray-scale. */ /* _Format: Destination format for resource instance (currently as file extension, may later be changed to MIME types) // Not used, format is already defined in URI-components through file extension! */ /* _Compression: Compression factor for compression algorithms causing information loss. PROBLEM: unclear how to define for all formats! */ /* InternalNotes: Internal notes regarding this quality version of the resource (history of editing, steps taken to generate this version, compression rate, etc.). */ CREATE TABLE RscAutoGenerateMethod_Enum ( AutoGenerateMethodID INTEGER NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(65) NULL UNIQUE, ImgPixelExtension SMALLINT NOT NULL DEFAULT 0, ImgPixelHeight SMALLINT NOT NULL DEFAULT 0, ImgPixelWidth SMALLINT NOT NULL DEFAULT 0, ImgCropping TINYINT NOT NULL DEFAULT 0, ImgColorDepth INTEGER NOT NULL DEFAULT 0, ImgGrayscale BIT NOT NULL, _Format NATIONAL CHARACTER VARYING(255) NULL, _Compression NATIONAL CHARACTER VARYING(255) NULL, InternalNotes NATIONAL CHARACTER VARYING(255) NULL ); /*=== Table: RscHTTP11StatusCode_Enum ===*/ /* Contains definitions of http status codes as defined in RFC 2616. Used in the context of the Availability Check (ResourceInstance) to report messages. */ /* Code: Code number according to internet standard RFC 2616. */ /* CodeText: Short title. */ /* Category: Heading or category. */ /* TechnicalDescriptionRFC2616: Full text of description. */ CREATE TABLE RscHTTP11StatusCode_Enum ( Code SMALLINT NOT NULL PRIMARY KEY, CodeText NATIONAL CHARACTER VARYING(255) NOT NULL, Category NATIONAL CHARACTER VARYING(255) NOT NULL, TechnicalDescriptionRFC2616 NATIONAL TEXT NOT NULL ); /*=== Table: RscMediaType_CompleteImported ===*/ /* Temporary table, documenting possible MIME media types. Not all media types should be made available in the system! */ CREATE TABLE RscMediaType_CompleteImported ( ID INTEGER IDENTITY NOT NULL PRIMARY KEY, Type NATIONAL CHARACTER VARYING(255) NULL, Subtype NATIONAL CHARACTER VARYING(255) NULL, Description NATIONAL CHARACTER VARYING(255) NULL, Used BIT NULL, DoNotUse BIT NULL ); /*=== Table: RscMediaType_Enum ===*/ /* System wide enumeration of resource media types, according to MIME (rfc 2046; e.g. file format image/gif). */ /* MediaTypeID: Unique internal ID number for a media type. */ /* MediaType: Media type according to MIME (rfc 2046; e.g. file format: image/gif). */ /* Description: Description of the media type, displayed in user interface. */ /* _WebCompatible: The quality level is compatible with current internet browsers. */ /* _HtmlEmbeddableImage: Resources of this format can be embedded in html files using the html image tag. */ /* _HtmlEmbeddableText: Resources of this format can be embedded in html files directly (header/body less html resources designed to be included elsewhere). */ CREATE TABLE RscMediaType_Enum ( MediaTypeID SMALLINT NOT NULL PRIMARY KEY, MediaType NATIONAL CHARACTER VARYING(255) NOT NULL, Description NATIONAL CHARACTER VARYING(255) NOT NULL, _WebCompatible BIT NOT NULL DEFAULT 0, _HtmlEmbeddableImage BIT NOT NULL DEFAULT 0, _HtmlEmbeddableText BIT NOT NULL DEFAULT 0 ); /*=== Table: RscMediaTypeExtension_Enum ===*/ /* System wide definition of file extensions to be recognized as a media type (e.g. '.gif' for image/gif). */ /* RecognizedFileExtension: File extension recognized for a media type. */ /* MediaTypeID: ID number of media type (foreign key). */ CREATE TABLE RscMediaTypeExtension_Enum ( RecognizedFileExtension NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, MediaTypeID SMALLINT NOT NULL ); /*=== Table: RscMediaTypeIcon_Enum ===*/ /* System wide enumeration of generic icon images for resource media types (file formats), optionally quality level dependent. */ /* MediaTypeID: ID number of media type (foreign key + 1st part of primary key). */ /* QualityLevel: A quality level as defined in RscQualityLevel_Enum (foreign key + 2nd part of primary key). */ /* SmallIconURI: Complete URI of icon image used to symbolize all resource instances of this quality level. Different quality levels may have the same or different icons. */ /* SmallIconWidth: Width of small icon image in pixel. */ /* SmallIconHeight: Height of small icon image in pixel. */ /* LargeIconURI: Like SmallIconURI, but for a larger icon size. */ /* LargeIconWidth: Width of large icon image in pixel. */ /* LargeIconHeight: Height of large icon image in pixel. */ CREATE TABLE RscMediaTypeIcon_Enum ( MediaTypeID SMALLINT NOT NULL, QualityLevel INTEGER NOT NULL, SmallIconURI NATIONAL CHARACTER VARYING(255) NOT NULL, SmallIconWidth TINYINT NOT NULL DEFAULT 0, SmallIconHeight TINYINT NOT NULL DEFAULT 0, LargeIconURI NATIONAL CHARACTER VARYING(255) NOT NULL, LargeIconWidth TINYINT NOT NULL DEFAULT 0, LargeIconHeight TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (MediaTypeID,QualityLevel) ); /*=== Table: RscPresentationMode_Enum ===*/ /* System wide enumeration of possible presentation modes (link, embedded, etc.). */ /* Mode: Unique 1 letter code defining a presentation mode (primary key). Code values are fixed and may be directly evaluated by applications. */ /* Title: User readable, unique title for presentation mode. */ /* Description: Optional additional description of presentation mode. */ /* DisplayOrder: Display order / sequence. */ CREATE TABLE RscPresentationMode_Enum ( Mode NATIONAL CHARACTER VARYING(1) NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(65) NOT NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, DisplayOrder INTEGER NOT NULL DEFAULT 0 ); /*=== Table: RscProviderStatus_Enum ===*/ /* System wide enumeration of provider status, used in ResourceProvider. */ /* Status: Unique 1 letter code defining a provider status (primary key). Code values are fixed and may be directly evaluated by applications. */ /* Title: User readable, unique title for provider status. */ /* Description: Optional additional description of provider status. */ /* AccessType: 'Internet', 'LAN', 'offline storage'. */ /* IsOnline: Is the provider available online? */ /* InternetAccess: In the provider available on the Internet? */ /* LoadBalancing: Is the access load shared between multiple providers? */ /* ContentMaster: This provider provides the original resource version, from which backup or load balancing mirrors may be updated (if they are present). */ /* DisplayOrder: Display order / sequence. */ CREATE TABLE RscProviderStatus_Enum ( Status NATIONAL CHARACTER VARYING(1) NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(65) NOT NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, AccessType NATIONAL CHARACTER VARYING(15) NOT NULL, IsOnline BIT NOT NULL, InternetAccess BIT NOT NULL, LoadBalancing BIT NOT NULL, ContentMaster BIT NOT NULL, DisplayOrder INTEGER NOT NULL DEFAULT 0 ); /*=== Table: RscQualityLevel_Enum ===*/ /* System wide enumeration of quality levels, used in ResourceQualityClass. */ /* QualityLevel: Unique ID for the quality level (primary key). A higher level indicates a higher quality. */ /* Abbreviation: Short abbreviated description of the quality level, may displayed in the user interface. */ /* Title: User readable, unique title for quality level, e.g. 'original version' or 'modified'; for images: 'full resolution', 'default compressed', or 'thumbnail image'. */ /* Description: Additional description of quality level. */ /* _PresentationDefault: Default for recommended presentation mode (Link, New-window-link, Download, Embed) of new ResourceQualityClass records based on this quality level. */ /* _ImageAutoGenerateDefault: Default for recommended method to automatically generate instances for ResourceClasses of this quality level (currently only for images). */ /* _Abridged: Information in this quality level is abridged, e.g. thumbnail image preview, or short preview video sequences. */ /* _Internal: Information of this quality level is normally not intended for public use, esp. original scans, internal backup copies, etc. */ CREATE TABLE RscQualityLevel_Enum ( QualityLevel INTEGER NOT NULL PRIMARY KEY, Abbreviation NATIONAL CHARACTER VARYING(25) NULL, Title NATIONAL CHARACTER VARYING(65) NOT NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NOT NULL, _PresentationDefault NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'L', _ImageAutoGenerateDefault INTEGER NOT NULL DEFAULT 0, _Abridged BIT NOT NULL DEFAULT 0, _Internal BIT NOT NULL DEFAULT 0 ); ALTER TABLE ResourceCollectionManager ADD FOREIGN KEY (ResourceCollectionID) REFERENCES ResourceCollection (ResourceCollectionID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceQualityClass ADD FOREIGN KEY (ResourceCollectionID) REFERENCES ResourceCollection (ResourceCollectionID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (QualityLevel) REFERENCES RscQualityLevel_Enum (QualityLevel) ON UPDATE CASCADE, FOREIGN KEY (AutoGenerateMethodID) REFERENCES RscAutoGenerateMethod_Enum (AutoGenerateMethodID) ON UPDATE CASCADE ALTER TABLE ResourceProvider ADD FOREIGN KEY (ResourceCollectionID) REFERENCES ResourceCollection (ResourceCollectionID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceAbstractItem ADD FOREIGN KEY (ResourceCollectionID) REFERENCES ResourceCollection (ResourceCollectionID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceAbstractItem_Rating ADD FOREIGN KEY (ResourceID) REFERENCES ResourceAbstractItem (ResourceID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceDescription ADD FOREIGN KEY (ResourceID) REFERENCES ResourceAbstractItem (ResourceID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceDescriptionTranslation ADD FOREIGN KEY (ResourceID,FragmentID) REFERENCES ResourceDescription (ResourceID,FragmentID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceKeyword ADD FOREIGN KEY (ResourceID,FragmentID) REFERENCES ResourceDescription (ResourceID,FragmentID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceTaxon ADD FOREIGN KEY (ResourceID,FragmentID) REFERENCES ResourceDescription (ResourceID,FragmentID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceInstance ADD FOREIGN KEY (ResourceID) REFERENCES ResourceAbstractItem (ResourceID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (ResourceCollectionID,QualityLevel) REFERENCES ResourceQualityClass (ResourceCollectionID,QualityLevel) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (ResourceCollectionID,ProviderOrder) REFERENCES ResourceProvider (ResourceCollectionID,ProviderOrder) ON DELETE CASCADE, FOREIGN KEY (MediaTypeID) REFERENCES RscMediaType_Enum (MediaTypeID) ON UPDATE CASCADE ALTER TABLE RscMediaTypeExtension_Enum ADD FOREIGN KEY (MediaTypeID) REFERENCES RscMediaType_Enum (MediaTypeID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE RscMediaTypeIcon_Enum ADD FOREIGN KEY (MediaTypeID) REFERENCES RscMediaType_Enum (MediaTypeID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (QualityLevel) REFERENCES RscQualityLevel_Enum (QualityLevel) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE RscQualityLevel_Enum ADD FOREIGN KEY (_ImageAutoGenerateDefault) REFERENCES RscAutoGenerateMethod_Enum (AutoGenerateMethodID) ON UPDATE CASCADE /*** Remove this comment line to enable creation of column description for MS SQL Server 2000 *** exec sp_addextendedproperty N'MS_Description',N'Resource collection ID, unique system generated value (primary key).',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'Unique user readable title, identifying the resource collection. Example: ''Ascochyta images from Melnik (1977)''.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Short description of the resource collection, ca. a single paragraph long. Basic xhtml formatting tags are permitted.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'The extent or scope of the content of the resource. Coverage will typically include spatial location (e.g. a place name), temporal period (a period label, date, or date range) or taxonomic group [DC 1.1!]',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Coverage' exec sp_addextendedproperty N'MS_Description',N'A list of authors displayed on the title page of the entire collection. Authors or editors of a collection need not be identical with resource managers, or creators of resources.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Authors' exec sp_addextendedproperty N'MS_Description',N'A list of editors displayed on the title page of the entire collection. The creators of a resource collection can decide whether they are Authors or Editors, but at least one of the two must be used.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Editors' exec sp_addextendedproperty N'MS_Description',N'A list of contributors displayed on the title page of the entire collection.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Contributors' exec sp_addextendedproperty N'MS_Description',N'Where applicable, a general description of the source or origin of the resources covered in the current collection. Compare SourceReferenceID if source is a publication.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'SourceDescription' exec sp_addextendedproperty N'MS_Description',N'For resources that are present in published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Example: ''ABE_1990_MPL'' for figures from a book recorded under this ID.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'SourceReferenceID' exec sp_addextendedproperty N'MS_Description',N'A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'SourceRefDescriptionCache' exec sp_addextendedproperty N'MS_Description',N'Refers to an acknowledgement definition that documents source and intellectual property rights, and provides a formatted acknowledgement (foreign key).',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'AcknowledgementID' exec sp_addextendedproperty N'MS_Description',N'If not already covered by acknowledgment: documentation of copyright or usage agreements, including dates and the name of the responsible person or institution with which an agreement was reached.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Rights' exec sp_addextendedproperty N'MS_Description',N'Internal notes and remarks. Not published in public reports.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'URI of a icon or logo, usually a small gif file that can be displayed next to the collection title.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconURI' exec sp_addextendedproperty N'MS_Description',N'A URI that may optionally be placed behind the collection icon, to create a hyperlink to another site on the world-wide-web.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconLinkURI' exec sp_addextendedproperty N'MS_Description',N'True = no link border around icon image (default); False = a colored link border is added around icon image.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconLinkHidden' exec sp_addextendedproperty N'MS_Description',N'Text used for the alternative text of the image; usually this text is also displayed when the mouse hovers over the image.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconDescription' exec sp_addextendedproperty N'MS_Description',N'Width of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no width is available.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconWidth' exec sp_addextendedproperty N'MS_Description',N'Height of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no height is available.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IconHeight' exec sp_addextendedproperty N'MS_Description',N'A date which may be up to 1 year in the future to prevent public access to the resource collection prior to this date (set by the managers of the collection).',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'ReleaseDate' exec sp_addextendedproperty N'MS_Description',N'Required whenever ReleaseDate postpones the public release: Documentation of the motives for the postponement, and name of responsible user (esp. if multiple collection managers exist).',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'ReleaseNotes' exec sp_addextendedproperty N'MS_Description',N'True: the organization hosting the DiversityResources metadata management application is also legally responsible for the server from which the resource content is provided. Editable only by site managers, not by resource collection managers!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'ManagedContent' exec sp_addextendedproperty N'MS_Description',N'True if editorial control is required (always necessary for managed content). Editable only by site managers, not by resource collection managers! If set to false, EditorialReleaseBy/When are updated to document decisions.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControl' exec sp_addextendedproperty N'MS_Description',N'Default is false = only site managers can set EditorialRelease, if true EditorialRelease can be set by all managers of the resource collection. Editable only by site managers, not by resource collection managers!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControlDelegated' exec sp_addextendedproperty N'MS_Description',N'If EditorialControl is false or EditorialControlDelegated true, a documentation about the rejection or delegation is required. In the case of a delegation the responsibility must accepted a signed paper or agreement by email exchange should be cited.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControlDocumentation' exec sp_addextendedproperty N'MS_Description',N'The responsible site manager who delegated the editorial control. Editable only by site managers, not by resource collection managers!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControlSetBy' exec sp_addextendedproperty N'MS_Description',N'Date/time when the EditorialControl was delegated.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControlSetWhen' exec sp_addextendedproperty N'MS_Description',N'The editorial review mechanism guarantees that no unwanted information is presented on the website. Important for images uploaded by external users. Editability depends on EditorialControlDelegated attribute.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialReleaseBy' exec sp_addextendedproperty N'MS_Description',N'Date/time up to which the all resources in the collection have been reviewed and found suitable for public release. Instances added at a later date are automatically prevented from being available in the internet. Editability like EditorialReleaseBy.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialReleaseWhen' exec sp_addextendedproperty N'MS_Description',N'The data and time when the last routine availability check of all resource instances of this collection was performed. Compare also CheckAvailability_LastTestWhen of individual resource instances.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'CheckAvailability_LastTestWhen' exec sp_addextendedproperty N'MS_Description',N'The number of days after which a routine availability check of all resource instances shall be performed. Set to 999999 to disable routine test.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'CheckAvailability_Interval' exec sp_addextendedproperty N'MS_Description',N'True for templates used to create a new resource collection together with the relevant resource classes. System attribute, not user editable, default is false.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IsTemplate' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created. Also serves as publication date of the collection (use of ReleaseDate is not indicated, may later be changed to temporarily lock the collection).',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of the resource collection (foreign key).',N'user',N'dbo',N'table',N'ResourceCollectionManager',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'ID of user who may manages the resource information in the resource collection (foreign key, referring to DiversityUsers.UserID).',N'user',N'dbo',N'table',N'ResourceCollectionManager',N'column',N'ManagingUserID' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceCollectionManager',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created.',N'user',N'dbo',N'table',N'ResourceCollectionManager',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'Refers to a resource collection (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'Online availability scope (managers, login, intranet, internet) of resource instances of this quality class (also restricted by ItemOnlineAvailability of abstract item!).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'OnlineAvailability' exec sp_addextendedproperty N'MS_Description',N'Availabilty scope of meta information (description, keywords); access information (URI) is available only on explicit request by electronic or postal means (also restricted by ItemRequestAvailability of abstract item!).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'RequestAvailability' exec sp_addextendedproperty N'MS_Description',N'Optional string, inserted between URI_Part1 (see ResourceProvider) and the individual resource name URI_Part3 (see ResourceAbstractItem).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'URI_Part2' exec sp_addextendedproperty N'MS_Description',N'Optional string, appended to the individual resource name (URL_Part3). This may be part of the filename + quality-level typical extension, e.g. ''_thumbn.gif.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'URI_Part4' exec sp_addextendedproperty N'MS_Description',N'Recommended presentation mode (Link, New-window-link, Download, Embed). The web interface may either follow the recommendation or implement its own rules.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'RecommendedPresentation' exec sp_addextendedproperty N'MS_Description',N'Defines a method used to automatically generate instances for this class based on another resource class (usually of higher quality level). ID = 0 disables autogeneration.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'AutoGenerateMethodID' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding this quality version of the resource (history of editing, steps taken to generate this version, compression rate, etc.).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'The user who updated this record the last time.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Refers to a resource collection (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'Number defining the order in which mirrored backup providers are accessed. Unique within a ResourceCollection (part of primary key).',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'ProviderOrder' exec sp_addextendedproperty N'MS_Description',N'Defines status as: Online primary location, Online load balancing, Online backup/mirror, Offline backup.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'Status' exec sp_addextendedproperty N'MS_Description',N'The first part of the URI, before the variable part defined in the individual resource. It should include protocol, server, and beginning of path. Example: ''http://www.example.net/images''.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'URI_Part1' exec sp_addextendedproperty N'MS_Description',N'An alternative version of the first part of the URI, allowing write access (e.g. for updating mirrors or autogenerating instances). Example: ''user:pass@ftp://www.example.net/images''. URI_Part1 may rarely allow write access, URI_Part_Write always does.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'URI_Part1_Write' exec sp_addextendedproperty N'MS_Description',N'Internal notes and remarks.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'The user who updated this record the last time.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceProvider',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Unique system generated value (primary key). Resource ID is a public ID. It may be stored outside of DiversityResources and should therefore not be changed after creation.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'Each resource belongs to a single resource collection (foreign key). The res. collection supplies general information not present in each item.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'The part of the URI that is specific to the abstract resource item (applicable to all quality instances of the item). Inserted between the optional Class attributes URI_Part2 & Part4. Example: ''figure13.gif''. Required even if URI_ManualOverride is used.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'URI_Part3' exec sp_addextendedproperty N'MS_Description',N'Online availability scope (managers, login, intranet, internet) of resource instances of this abstract item (also restricted by OnlineAvailability of resource class!).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ItemOnlineAvailability' exec sp_addextendedproperty N'MS_Description',N'Availabilty scope of meta information (description, keywords); access information (URI) is available only on explicit request by electronic or postal means (also restricted by RequestAvailability of resource class!).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ItemRequestAvailability' exec sp_addextendedproperty N'MS_Description',N'For reports where the resource will be embedded in another document: Defines a numbering sequence category (fig., tab., etc.) to be used.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'NumberingCategory' exec sp_addextendedproperty N'MS_Description',N'Optional for hyperlinks: Complete URI of an icon that shall be displayed in addition to the text link (e.g. icon of a online journal, computer application, etc.).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'LinkAssociatedIcon' exec sp_addextendedproperty N'MS_Description',N'The update status (normal, new, updated) of a resource can be defined; this can be used to automatically add appropriate icons to alert users to changes.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'UpdateStatus' exec sp_addextendedproperty N'MS_Description',N'For resources from published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Compare also ResourceCollection.SourceReferenceID!',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceReferenceID' exec sp_addextendedproperty N'MS_Description',N'A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceRefDescriptionCache' exec sp_addextendedproperty N'MS_Description',N'Information how to locate original information in source, esp. page numbers. Do not add ''page'' or ''p.'' for page numbers (incl. roman numbers) -- Specimen/culture collections: accession number or storage location code.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceDetail' exec sp_addextendedproperty N'MS_Description',N'An identifier code used in the source from which a digitized resource is derived. This may, e. g. be the slide number of a digitized slide, or the page and figure number in a publication.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceLabel' exec sp_addextendedproperty N'MS_Description',N'For resources from published sources: An ascending number reflecting the sequence of resources in the source.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceOrder' exec sp_addextendedproperty N'MS_Description',N'The full, unchanged text of the original caption of the resource in the source, esp. in the case of images (if resource has fragments/parts, the captions of all fragments are entered here).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceCaption' exec sp_addextendedproperty N'MS_Description',N'The number of times this item was rated.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'RatingCountCache' exec sp_addextendedproperty N'MS_Description',N'The average rating score as obtained by averaging all values in ResourceAbstractItem_Rating for this abstract item.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'RatingAverageCache' exec sp_addextendedproperty N'MS_Description',N'Optional: if the current resource is a modified version derived from another resource available in the system, this points to the original resource (ResourceID foreign key) [** not implemented, prepared for future versions**]',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'_ParentResourceID' exec sp_addextendedproperty N'MS_Description',N'Defines a template for new abstract items. Default is false, should be true only a single time within each collection. A template may already include dependent records for descriptions, taxa, and keywords.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'IsTemplate' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'The user who updated this record the last time.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Unique system generated value (primary key). Resource ID is a public ID. It may be stored outside of DiversityResources and should therefore not be changed after creation.',N'user',N'dbo',N'table',N'ResourceAbstractItem_Rating',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'Time when the rating was entered.',N'user',N'dbo',N'table',N'ResourceAbstractItem_Rating',N'column',N'EntryDate' exec sp_addextendedproperty N'MS_Description',N'A numerical rating value.',N'user',N'dbo',N'table',N'ResourceAbstractItem_Rating',N'column',N'Rating' exec sp_addextendedproperty N'MS_Description',N'An optional comment associated with a rating.',N'user',N'dbo',N'table',N'ResourceAbstractItem_Rating',N'column',N'RatingComment' exec sp_addextendedproperty N'MS_Description',N'Internal unique primary key number.',N'user',N'dbo',N'table',N'ResourceAbstractItem_Rating',N'column',N'RatingID' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which this description applies (foreign key).',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'A number that is unique within a resource ID, identifying the resource fragment. Use ''0'' for entire resource. The FragmentID is used by external modules to identify a resource fragment and should therefore not be changed after creation.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'FragmentID' exec sp_addextendedproperty N'MS_Description',N'For fragments of resources: label identifying resource part, fragment, or component (e.g. figures in a composite image labeled a, b, etc.; tracks on audio resources, etc.). Use description like ''top'', ''left side'', etc. for unlabeled parts!',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'FragmentLabel' exec sp_addextendedproperty N'MS_Description',N'Optional: Definition in technical units of the start of this part of a multipart resource. Empty for entire resource! Use percent of height/width for images (not pixel, they are quality dependent!), seconds for audio/video, bookmark-code for text, etc.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'FragmentStart' exec sp_addextendedproperty N'MS_Description',N'Optional: Definition in technical units of the end of this part of a multipart resource. Empty for entire resource! Compare FragmentStart for examples of technical units.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'FragmentEnd' exec sp_addextendedproperty N'MS_Description',N'Optional: Author(s), photographer, director, etc. Person(s) or institution(s) responsible for the creation of the abstract resource item (not of the instance, e.g. a scan of an image). [DC11!]',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'Creator' exec sp_addextendedproperty N'MS_Description',N'Creation date (optionally also time) of the original resource. For digitized resources this should refer to the original creation (of the abstract item, e.g. when picture was drawn or photographed), not the digitization process.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'CreationDate' exec sp_addextendedproperty N'MS_Description',N'Optional: additional information regarding the creation process, e.g. image lens, scale, exposure time, etc.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'CreationMetadata' exec sp_addextendedproperty N'MS_Description',N'Optional: Information about rights (copyright, intellectual property) held in and over the resource. Enter esp. name of person or institution holding the copyright. Leave empty if unknown or if rights are globally described in resource collection. [DC11!]',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'Rights' exec sp_addextendedproperty N'MS_Description',N'Language of the resource itself. Empty = not yet analysed; hyphen (''-'') = language neutral (e.g. images without text). Compare also language of resource title or description meta data under DescriptionTranslation. 2 letter ISO code of language [DC 1.1!]',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'Language' exec sp_addextendedproperty N'MS_Description',N'Internal notes, applying to the entire resource or parts of the resource. Visible only to managers of the resource collection.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'LogCreatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was created.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'The user who updated this record the last time.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which this description applies (foreign key).',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'ID of fragment (''0'' for entire resource) to which the display element applies (foreign key).',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'FragmentID' exec sp_addextendedproperty N'MS_Description',N'Language of the current title, description, keywords, etc. (i.e. language of meta data to the resource object; the language of the resource itself is defined in xxx). 2 letter ISO code of language [DC 1.1!]',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'Language' exec sp_addextendedproperty N'MS_Description',N'A title for the resource item, esp. used as link text if hyperlink to resource is created. If possible, the title should be unique within a resource collection (not enforced!) [DC 1.1!]',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Short description of the entire resource, primarily intended for use in hyperlink lists. Basic xhtml character formatting tags may be used. If no separate Caption is used, this is also used as caption for embedded resources [DC 1.1!]',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Optional: If Description does not already provides an adequate caption for embedded resource display, a caption may be defined here. Basic xhtml formatting tags may be used. For images: the measurement scale (example: ''bar=10 µm'') should be included here.',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'Caption' exec sp_addextendedproperty N'MS_Description',N'Normally the attribute is empty and resources are sorted by title. If filled, used to sort resources in a presentation. Example: ''The Area of New York'' shall be sorted under ''New York''''. Numbers are sorted as text, i.e. ''10''<''9'', use ''09'', ''10''!',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'DisplayOrderOverride' exec sp_addextendedproperty N'MS_Description',N'Computed field, set to DisplayOrderOverride if present, otherwise to Title. The cache is introduced to allow indexing and fast sorting.',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'DisplayOrderCache' exec sp_addextendedproperty N'MS_Description',N'The user who created/updated the keyword.',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceDescriptionTranslation',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which the keyword applies (foreign key).',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'ID of fragment (''0'' for entire resource) to which the keyword applies (foreign key).',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'FragmentID' exec sp_addextendedproperty N'MS_Description',N'A keyword, including subject headings or private markers. A keyword entry may consist of multiple words or phrases (e. g. ''red herring'').',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'Keyword' exec sp_addextendedproperty N'MS_Description',N'The user who created/updated the keyword.',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which the taxon applies (foreign key).',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'ID of fragment (''0'' for entire resource) to which the taxon applies (foreign key).',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'FragmentID' exec sp_addextendedproperty N'MS_Description',N'Internal number providing a primary key. A combined primary key would be ResourceID, FragmentID, and either TaxonomicName or VernacularName (one of which must be filled). Such an alternative use of fields is, however, not possible in a primary key.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'RecordID' exec sp_addextendedproperty N'MS_Description',N'Scientific name of taxon (if possible include authors). Any name can be entered, regardless of whether it is present in taxonomy or not.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'TaxonomicName' exec sp_addextendedproperty N'MS_Description',N'Non-scientific name of organism (e.g. ''white fir'') or non-taxonomic name (''conifer'', ''hardwood'').',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'VernacularName' exec sp_addextendedproperty N'MS_Description',N'Unique ID code of the taxon. Refers to the NomID code of TaxonomyName (= foreign key) in the database DiversityTaxonomy.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'NomID' exec sp_addextendedproperty N'MS_Description',N'Qualification of the identification e.g. ''cf.'', ''aff.'', ''sp. nov.''.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'IdentificationQualifier' exec sp_addextendedproperty N'MS_Description',N'''ORIGINAL'' = according to original description (e.g. publication), else name of person responsible for a later identification.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'IdentificationResponsible' exec sp_addextendedproperty N'MS_Description',N'Semicolon-separated list of features of the taxon, e.g. ''ascomata; asci; ascospores; germination''.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'FeatureList' exec sp_addextendedproperty N'MS_Description',N'*** All fields starting with underscore are present only as a reminder, not yet decided upon!',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_TopicNomenclature' exec sp_addextendedproperty N'MS_Description',N'0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_TopicDescription' exec sp_addextendedproperty N'MS_Description',N'0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_TopicGeography' exec sp_addextendedproperty N'MS_Description',N'0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_TopicPhylogeny' exec sp_addextendedproperty N'MS_Description',N'*** assessment of identification quality?',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_IDQuality' exec sp_addextendedproperty N'MS_Description',N'*** person responsible for setting IDQuality?',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'_IDQualityResponsible' exec sp_addextendedproperty N'MS_Description',N'The user who created/updated this record the last time.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'LogUpdatedBy' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which this association applies (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'Refers to a resource collection (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'Refers to one of possible several resource providers within a resource collection (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ProviderOrder' exec sp_addextendedproperty N'MS_Description',N'A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'If this attribute is filled with a complete URI, it is directly used, ignoring URI_Part1 to URI_Part4.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'URI_ManualOverride' exec sp_addextendedproperty N'MS_Description',N'The complete URI address. If URI_ManualOverride is empty, it is generated from URI_Part1 to URI_Part4 (for digital resources that are available online).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'URI_Cache' exec sp_addextendedproperty N'MS_Description',N'(calculated value; = Min(Class.OnlineAvailability, ItemOnlineAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'OnlineAvailabilityCache' exec sp_addextendedproperty N'MS_Description',N'(calculated value; = Min(Class.RequestAvailability, ItemRequestAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'RequestAvailabilityCache' exec sp_addextendedproperty N'MS_Description',N'The result of the last availability test (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_LastResult' exec sp_addextendedproperty N'MS_Description',N'Http status code of last availability test as defined in RFC 2616; contains 0 if status code not applicable (e. g. non-http request) or not evaluated (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_LastStatusCode' exec sp_addextendedproperty N'MS_Description',N'The date and time the availability was last tested (set by a link checking program). A standard testing cycle might retest every 3-6 days. The date is no longer updated when instance is deactivated.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_LastTestWhen' exec sp_addextendedproperty N'MS_Description',N'The date and time when the availability test result was positive the last time (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_LastSuccessWhen' exec sp_addextendedproperty N'MS_Description',N'Automatically deactivated if LastResult is negative and LastSuccessWhen more than 14 days ago (set by a link checking program). Date and time when the resource instance was deactivated can be found in CheckAvailability_LastTestWhen.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_Deactivated' exec sp_addextendedproperty N'MS_Description',N'The total number of availability tests since the last ResetWhen (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_Attempts' exec sp_addextendedproperty N'MS_Description',N'The total number of failed availability tests since the last ResetWhen (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_Failures' exec sp_addextendedproperty N'MS_Description',N'Date and time when the attributes Attempts and Failures were last reset to 0 (automatically set by the reset routine of the link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_ResetWhen' exec sp_addextendedproperty N'MS_Description',N'Media type according to MIME, refers to RscMediaType_Enum (foreign key). May be determined based on information in http requests or using recognized file extension (compare RscMediaTypeExtension_Enum). 0 indicates an unknown media type.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'MediaTypeID' exec sp_addextendedproperty N'MS_Description',N'Size of resource in bytes: file size or content length of download stream. The information is used to add size indications to links, helping resource consumers to make appropriate choices. The value is -1 if the size is unknown.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ContentLength' exec sp_addextendedproperty N'MS_Description',N'Last-Modified date obtained during resource request (e. g. from http-header). Used to identify updated instances and update attributes that can be automatically obtained (e.g. size, pixel, etc.).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'LastModified' exec sp_addextendedproperty N'MS_Description',N'Optional for images: The height/width in pixel; esp. used for internet presentations; pages can be displayed better if height is known before the image is fully loaded. The value is 0 if the height is not available.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ImgPixelHeight' exec sp_addextendedproperty N'MS_Description',N'Optional for images: The height/width in pixel; esp. used for internet presentations; pages can be displayed better if height is known before the image is fully loaded. The value is 0 if the width is not available.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ImgPixelWidth' exec sp_addextendedproperty N'MS_Description',N'Optional for images: The color depth in bits/pixel. The value is 0 if the color depth is not available.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ImgColorDepth' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated. The creation time is not recorded, since instance records are automatically created and deleted with item, provider, or quality class records.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Unique ID for the autogeneration method (primary key). The method with ID=0 is special, it defines "autogeneration is disabled".',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'AutoGenerateMethodID' exec sp_addextendedproperty N'MS_Description',N'User readable, short and unique description of autogeneration method.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Maximum extension (height or width) of autogenerated images in pixel. The other dimension will be scaled so that the aspect ratio remains constant. AutoGeneratePixelHeight/Width should both be 0.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgPixelExtension' exec sp_addextendedproperty N'MS_Description',N'Height of autogenerated images in pixel. Enter 0 to keep aspect ratio of the image and resize based on width. AutoGeneratePixelExtension should be = 0 if used.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgPixelHeight' exec sp_addextendedproperty N'MS_Description',N'Width of autogenerated images in pixel. Enter 0 to keep aspect ratio of the image and resize based on heigth. AutoGeneratePixelExtension should be = 0 if used.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgPixelWidth' exec sp_addextendedproperty N'MS_Description',N'Border around the original image in percent to be cropped, cropping occurs before reducing the size as requested in ImgPixelExtension/Height/Width. In a 1000x500 pixel image, ImgCropping=10 will leave 900 x 450 pixel after cropping (5% left, 5% right).',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgCropping' exec sp_addextendedproperty N'MS_Description',N'If autogeneration is requested: The color depth in bits/pixel. The value 0 indicates that the color depth shall remain unchanged.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgColorDepth' exec sp_addextendedproperty N'MS_Description',N'True if image shall be gray-scale.',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'ImgGrayscale' exec sp_addextendedproperty N'MS_Description',N'Destination format for resource instance (currently as file extension, may later be changed to MIME types) // Not used, format is already defined in URI-components through file extension!',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'_Format' exec sp_addextendedproperty N'MS_Description',N'Compression factor for compression algorithms causing information loss. PROBLEM: unclear how to define for all formats!',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'_Compression' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding this quality version of the resource (history of editing, steps taken to generate this version, compression rate, etc.).',N'user',N'dbo',N'table',N'RscAutoGenerateMethod_Enum',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'Code number according to internet standard RFC 2616.',N'user',N'dbo',N'table',N'RscHTTP11StatusCode_Enum',N'column',N'Code' exec sp_addextendedproperty N'MS_Description',N'Short title.',N'user',N'dbo',N'table',N'RscHTTP11StatusCode_Enum',N'column',N'CodeText' exec sp_addextendedproperty N'MS_Description',N'Heading or category.',N'user',N'dbo',N'table',N'RscHTTP11StatusCode_Enum',N'column',N'Category' exec sp_addextendedproperty N'MS_Description',N'Full text of description.',N'user',N'dbo',N'table',N'RscHTTP11StatusCode_Enum',N'column',N'TechnicalDescriptionRFC2616' exec sp_addextendedproperty N'MS_Description',N'Unique internal ID number for a media type.',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'MediaTypeID' exec sp_addextendedproperty N'MS_Description',N'Media type according to MIME (rfc 2046; e.g. file format: image/gif).',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'MediaType' exec sp_addextendedproperty N'MS_Description',N'Description of the media type, displayed in user interface.',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'The quality level is compatible with current internet browsers.',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'_WebCompatible' exec sp_addextendedproperty N'MS_Description',N'Resources of this format can be embedded in html files using the html image tag.',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'_HtmlEmbeddableImage' exec sp_addextendedproperty N'MS_Description',N'Resources of this format can be embedded in html files directly (header/body less html resources designed to be included elsewhere).',N'user',N'dbo',N'table',N'RscMediaType_Enum',N'column',N'_HtmlEmbeddableText' exec sp_addextendedproperty N'MS_Description',N'File extension recognized for a media type.',N'user',N'dbo',N'table',N'RscMediaTypeExtension_Enum',N'column',N'RecognizedFileExtension' exec sp_addextendedproperty N'MS_Description',N'ID number of media type (foreign key).',N'user',N'dbo',N'table',N'RscMediaTypeExtension_Enum',N'column',N'MediaTypeID' exec sp_addextendedproperty N'MS_Description',N'ID number of media type (foreign key + 1st part of primary key).',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'MediaTypeID' exec sp_addextendedproperty N'MS_Description',N'A quality level as defined in RscQualityLevel_Enum (foreign key + 2nd part of primary key).',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'Complete URI of icon image used to symbolize all resource instances of this quality level. Different quality levels may have the same or different icons.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'SmallIconURI' exec sp_addextendedproperty N'MS_Description',N'Width of small icon image in pixel.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'SmallIconWidth' exec sp_addextendedproperty N'MS_Description',N'Height of small icon image in pixel.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'SmallIconHeight' exec sp_addextendedproperty N'MS_Description',N'Like SmallIconURI, but for a larger icon size.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'LargeIconURI' exec sp_addextendedproperty N'MS_Description',N'Width of large icon image in pixel.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'LargeIconWidth' exec sp_addextendedproperty N'MS_Description',N'Height of large icon image in pixel.',N'user',N'dbo',N'table',N'RscMediaTypeIcon_Enum',N'column',N'LargeIconHeight' exec sp_addextendedproperty N'MS_Description',N'Unique 1 letter code defining a presentation mode (primary key). Code values are fixed and may be directly evaluated by applications.',N'user',N'dbo',N'table',N'RscPresentationMode_Enum',N'column',N'Mode' exec sp_addextendedproperty N'MS_Description',N'User readable, unique title for presentation mode.',N'user',N'dbo',N'table',N'RscPresentationMode_Enum',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Optional additional description of presentation mode.',N'user',N'dbo',N'table',N'RscPresentationMode_Enum',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Display order / sequence.',N'user',N'dbo',N'table',N'RscPresentationMode_Enum',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Unique 1 letter code defining a provider status (primary key). Code values are fixed and may be directly evaluated by applications.',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'Status' exec sp_addextendedproperty N'MS_Description',N'User readable, unique title for provider status.',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Optional additional description of provider status.',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'''Internet'', ''LAN'', ''offline storage''.',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'AccessType' exec sp_addextendedproperty N'MS_Description',N'Is the provider available online?',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'IsOnline' exec sp_addextendedproperty N'MS_Description',N'In the provider available on the Internet?',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'InternetAccess' exec sp_addextendedproperty N'MS_Description',N'Is the access load shared between multiple providers?',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'LoadBalancing' exec sp_addextendedproperty N'MS_Description',N'This provider provides the original resource version, from which backup or load balancing mirrors may be updated (if they are present).',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'ContentMaster' exec sp_addextendedproperty N'MS_Description',N'Display order / sequence.',N'user',N'dbo',N'table',N'RscProviderStatus_Enum',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Unique ID for the quality level (primary key). A higher level indicates a higher quality.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'Short abbreviated description of the quality level, may displayed in the user interface.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'Abbreviation' exec sp_addextendedproperty N'MS_Description',N'User readable, unique title for quality level, e.g. ''original version'' or ''modified''; for images: ''full resolution'', ''default compressed'', or ''thumbnail image''.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Additional description of quality level.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Default for recommended presentation mode (Link, New-window-link, Download, Embed) of new ResourceQualityClass records based on this quality level.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'_PresentationDefault' exec sp_addextendedproperty N'MS_Description',N'Default for recommended method to automatically generate instances for ResourceClasses of this quality level (currently only for images).',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'_ImageAutoGenerateDefault' exec sp_addextendedproperty N'MS_Description',N'Information in this quality level is abridged, e.g. thumbnail image preview, or short preview video sequences.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'_Abridged' exec sp_addextendedproperty N'MS_Description',N'Information of this quality level is normally not intended for public use, esp. original scans, internal backup copies, etc.',N'user',N'dbo',N'table',N'RscQualityLevel_Enum',N'column',N'_Internal' GO *** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/