/* SQL DDL: Create an implementation of the model using the SQL Data Definition Language */ /* Note: You may want to change some field types to improve the implementation on your DBMS */ /* Comments such as this may not be supported by your system and may have to be removed */ /* 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 */ /* is now created as well as the current, aiming more at SQL-Server dialects (but using 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 */ /* PostgreSQL: National Character etc. indicates Unicode text. For Postgres you should create the entire database as Unicode and the 'National' must be removed from the SQL code */ /* PostgreSQL: replace the data type CHARACTER VARYING with VARCHAR */ /* PostgreSQL: replace the data type DATETIME with TIMESTAMP */ /* PostgreSQL: replace the default values for boolean fields with 'true' and 'false' */ /* PostgreSQL: The modeler can create special postgress SQL files as a separate file, it will be easiest to use those instead of the standard file. */ /* Note: CREATE INDEX (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */ /* Generated on 2.Nov.2001 10:59 by Diversity Workbench: Diversity Information Model Documenter, Vers. 2.0 (G. Hagedorn) */ /*=== Table: ResourceCollection ===*/ /* Definition of common properties (esp. the start of the URI) for a set of related external resources of various quality levels. */ /* 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 a collection of information resources, about one paragraph long. Basic xhtml formatting tags are permitted. */ /* Authors: A list of authors displayed on the title page for the entire collection. Authors or editors need not be identical with resource managers. */ /* Editors: A list of editors displayed on the title page for the entire collection. Authors or editors need not be identical with resource managers. */ /* SourceDescription: Description of the source or origin of resources in the current collection, esp. if URI point to files. 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). Examples: ''AUTH92Q974' 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 acknowledgements (foreign key). */ /* CopyrightDocumentation: 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. */ /* URI_Part1: If available via http/ftp: The first part of the URI, before the variable part defined in the individual resource. Should include protocol, server, and beginning of path. Example: 'http://www.example.net/images'. */ /* LAN_Part1: If available on a local fileserver/in a local area network: The start of the path. This can be used as an alternative to internet access while in the local area network. Example: '\\server\images\'. Mapped network drives ('Z:\images') should be avoided! */ /* BackupLocation: Description of location (local LAN path, label of CDs, etc. ) where a backup of the resource collection (including all resource instance files) is kept. */ /* ReleaseDate: A date which may be up to 2 years 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). */ /* xx_ManagedContent: Does the collection contain links to content for which the organization hosting the web site itself is responsible? */ /* EditorialControl: True if editorial control is required; necessary for managed content. Can be changed only by responsible managers of the internet site, not by resource collection managers. If set to false, EditorialReleaseBy/When are updated to document responsibility. */ /* EditorialReleaseBy: Name of a responsible manager of the internet site; can NOT be set by resource collection managers. The editorial review mechanism guarantees that no unwanted information is presented on the website, esp. for images uploaded by external users. */ /* EditorialReleaseWhen: Date up to which the resources have been reviewed. Instances added at a later date are automatically prevented from being available in the internet. */ /* IsTemplate: True if collection has been introduced as a template for new collections. */ /* xx_DefaultKeywords: Keywords that are automatically inserted into all new resource items / can be changed only for new items! */ /* xx_CollectionKeywords: Keywords that apply to the collection / can be changed at any time! */ /* xx_DefaultTaxa: Names AND/OR IDs? */ /* 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). */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceCollection ( ResourceCollectionID INTEGER IDENTITY NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(80) NOT NULL UNIQUE, Description NATIONAL TEXT NOT NULL, Authors NATIONAL CHARACTER VARYING(255) NULL, Editors NATIONAL CHARACTER VARYING(255) NULL, SourceDescription NATIONAL TEXT NULL, SourceReferenceID NATIONAL CHARACTER VARYING(20) NULL, SourceRefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, AcknowledgementID INTEGER NULL, CopyrightDocumentation NATIONAL TEXT NULL, InternalNotes NATIONAL TEXT NULL, URI_Part1 NATIONAL CHARACTER VARYING(255) NULL, LAN_Part1 NATIONAL CHARACTER VARYING(255) NULL, BackupLocation NATIONAL CHARACTER VARYING(255) NULL, ReleaseDate DATETIME NOT NULL DEFAULT current_timestamp, ReleaseNotes NATIONAL CHARACTER VARYING(255) NULL, xx_ManagedContent BIT NULL, EditorialControl BIT NOT NULL DEFAULT 1, EditorialReleaseBy NATIONAL CHARACTER VARYING(50) NULL, EditorialReleaseWhen DATETIME NULL, IsTemplate BIT NOT NULL DEFAULT 0, xx_DefaultKeywords NATIONAL CHARACTER VARYING(255) NULL, xx_CollectionKeywords NATIONAL CHARACTER VARYING(50) NULL, xx_DefaultTaxa NATIONAL CHARACTER VARYING(255) NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp ); /*=== Table: ResourceManager ===*/ /* Person that manages a ResourceCollection. Multiple managers can share the management. */ /* ResourceCollectionID: ID of the resource collection (foreign key). */ /* ManagingUserID: ID of user who may manage the resource information in the resource collection (foreign key, referring to DiversityUsers.UserID). */ CREATE TABLE ResourceManager ( ResourceCollectionID INTEGER NOT NULL, ManagingUserID INTEGER NOT NULL, PRIMARY KEY (ResourceCollectionID,ManagingUserID) ); /*=== Table: ResourceQualityClass ===*/ /* Quality classes for all instances of each abstract resource item are defined (separately for each resource collection). Examples for quality classes are preview or thumbnail versions, compressed versions, or high quality versions. */ /* ResourceCollectionID: Refers to a resource collection (foreign key). */ /* QualityLevel: A quality level for this class of resources as defined in SysRsc_QualityLevel (foreign key). */ /* URI_Part2: Optional string, inserted between URL_Part1 (see ResourceCollection) and the individual resource name URL_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, Download, Embed); the web interface may either follow the recommendation or implement its own rules. */ /* QualityAvailability: Availability scope (managers, login, intranet, internet) of resource instances of this quality class (also restricted by ItemAvailability!). */ /* QualityAvailableOnline: Access immediacy: True = directly online available; False = only meta information (keywords), but no access information (URI) is provided, available only on explicit request by electronic or postal means. (Also restricted by ItemAvailableOnline!). */ /* AutoGenerateFrom: A quality level from which resource instances for the current quality level can be generated (e.g. an image robot generating thumbnails) for each resource item. Leave empty if the instances are created manually. */ /* AutoGenerationCommand: A command calling the auto-generation robot with specific parameters (e.g. indicating the size of the desired preview image). */ /* InternalNotes: Internal notes regarding this quality version of the resource (history, steps taken to generate this version, compression rate, etc.). */ /* 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, URI_Part2 NATIONAL CHARACTER VARYING(255) NULL, URI_Part4 NATIONAL CHARACTER VARYING(255) NULL, RecommendedPresentation NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'L', QualityAvailability TINYINT NOT NULL DEFAULT 3, QualityAvailableOnline BIT NOT NULL DEFAULT 1, AutoGenerateFrom INTEGER NOT NULL, AutoGenerationCommand NATIONAL CHARACTER VARYING(255) NULL, InternalNotes NATIONAL CHARACTER VARYING(255) NULL, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceCollectionID,QualityLevel) ); /*=== Table: AppRsc_QualityLevel ===*/ /* System wide definitions of quality levels, used in ResourceQualityClass. */ /* QualityLevel: Unique ID for the quality level (primary key). */ /* QualityLevelDescription: User readable, unique description of quality level, e.g. "original version" or "modified"; for images: "full resolution", "default compressed", or "thumbnail image". */ /* Mirror: Primary location (= 0) or first and second mirror location. Mirror quality classes should not normally be offered as quality levels in the user interface. */ /* PresentationDefault: Default for recommended presentation mode (Link, Download, Embed) of new quality classes. */ /* SingleClass: Only a single quality class is used (however, multiple classes may be present due to mirror classes). Most QualityClass attributes in editing form are unavailable (except always RecommendedPresentation and if Mirror is > 0 also URI_Path2 ). */ /* Abridged: Information in this quality level is abridged, e.g. thumbnail preview, or short preview sequences from a video. */ /* Internal: Information of this quality level is normally not intended for public use, esp. original scans, internal backup copies, etc. */ CREATE TABLE AppRsc_QualityLevel ( QualityLevel INTEGER NOT NULL PRIMARY KEY, QualityLevelDescription NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, Mirror TINYINT NOT NULL DEFAULT 0, PresentationDefault NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'L', SingleClass BIT NOT NULL DEFAULT 0, Abridged BIT NOT NULL DEFAULT 0, Internal BIT NOT NULL DEFAULT 0 ); /*=== Table: ResourceAbstractItem ===*/ /* Abstract resource item: general information that applies to all duplicates or quality versions of a resource . */ /* ResourceID: Unique ID for external information resource (primary key). */ /* ResourceCollectionID: The specific information stored here is supplemented with the attributes defined in this resource collection entity (foreign key). */ /* 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 QualityClass attributes URI_Part2 and Part4. Example: 'figure13'. */ /* ItemAvailability: Availability scope (managers, login, intranet, internet) of resource instances of this abstract item (also restricted by QualityAvailability!). */ /* ItemAvailableOnline: Access immediacy: True = directly online available; False = only meta information (keywords), but no access information (URI) is provided, available only on explicit request by electronic or postal means. (Also restricted by QualityAvailableOnline!). */ /* xx_NumberingCategory: If resource is 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: Optional: 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 that are present in published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Compare also ResourceCollection.ReferenceID! */ /* SourceRefDescriptionCache: A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem. */ /* SourceReferenceDetail: Detail, especially page or figure number in a reference. Available if either the entire collection, or the current item is derived from a published source. */ /* SourceCaption: The full, unchanged text of the original caption for the resource, esp. in the case of images (if resource has parts, the captions of all parts are entered here). */ /* 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**] */ /* 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 IDENTITY NOT NULL PRIMARY KEY, ResourceCollectionID INTEGER NOT NULL, URI_Part3 NATIONAL CHARACTER VARYING(255) NULL, ItemAvailability TINYINT NOT NULL DEFAULT 3, ItemAvailableOnline BIT NOT NULL DEFAULT 1, xx_NumberingCategory TINYINT NOT NULL DEFAULT 0, LinkAssociatedIcon NATIONAL CHARACTER VARYING(255) NULL, UpdateStatus TINYINT NOT NULL DEFAULT 0, SourceReferenceID NATIONAL CHARACTER VARYING(255) NULL, SourceRefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, SourceReferenceDetail NATIONAL CHARACTER VARYING(50) NULL, SourceCaption NATIONAL TEXT NULL, ParentResourceID INTEGER NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp ); /*=== Table: ResourceDescription ===*/ /* Description of an entire resource or an optionally defined resource part. The entity combines the description and the resource part definition, which could also be modeled in a 1:1 relationship. */ /* ResourceID: ID of external resource to which this description applies (foreign key). */ /* PartID: A number that is unique within a resource ID, identifying the resource part. '0' for entire resource. PartID is used by external modules to identify a resource part and should therefore not be changed at a later time. */ /* PartLabel: For parts of resources: label identifying resource parts or components (e.g. a-, b-, c-labeled figures in images, tracks on audio resources, etc.). Use description like 'top', 'left side', etc. for unlabeled parts! */ /* PartStart: 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 for text, etc. */ /* PartEnd: Optional: Definition in technical units of the end of this part of a multipart resource. Empty for entire resource! Compare PartStart for examples of technical units. */ /* Creators: Optional: Author(s), photographer, director, etc. Person(s) or institution(s) responsible for the creation of the abstract resource item (not creators of the instance, e.g. a scan of an image!). */ /* CreationMetadata: Optional: information regarding the creation process, e.g. image capture date/time, location, lens, scale, exposure time, etc. */ /* CopyrightInformation: Optional: information regarding copyright of resource, esp. name of person or institution holding the copyright to this resource. Leave empty if unknown or if all content in the resource collection has the same copyright owner. */ /* 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, PartID INTEGER NOT NULL DEFAULT 0, PartLabel NATIONAL CHARACTER VARYING(255) NOT NULL DEFAULT '-', PartStart NATIONAL CHARACTER VARYING(255) NULL, PartEnd NATIONAL CHARACTER VARYING(255) NULL, Creators NATIONAL CHARACTER VARYING(255) NULL, CreationMetadata NATIONAL TEXT NULL, CopyrightInformation NATIONAL TEXT 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,PartID) ); /*=== Table: ResourceDisplayElement ===*/ /* All elements defining language specific output in presentations. The web interface can support all languages for which display elements have been defined. */ /* ResourceID: ID of external resource to which this description applies (foreign key). */ /* PartID: ID of part ('0' for entire resource) to which the display element applies (foreign key). */ /* Language: 2 letter iso code of language. */ /* Title: A title for the resource item, esp. used as link text if hyperlink to resource is created. */ /* Description: Short description of the entire resource, especially displayed as additional information after a hyperlink. Basic xhtml character formatting tags are allowed. In the absence of SpecialCaption the description is also used as caption for embedded resources. */ /* SpecialCaption: Optional: If description is not suitable as caption of an embedded resource, a special caption may be defined here. Basic xhtml formatting tags may be used. For images information about measurement scale (example: 'bar=10 µm') should be included. */ /* DisplayOrderText: If filled, used for sorting in a presentation. Example: 'The Area of New York' shall be sorted under 'New York', or at position '34'. Text sorting, use '09', '10', or '10' < '9'! Normally the attribute is empty and resources are sorted by title. */ /* DisplayOrderCache: Calculated field, set to DisplayOrderText if present, otherwise to Title. Introduced to allow indexing and fast sorting. */ CREATE TABLE ResourceDisplayElement ( ResourceID INTEGER NOT NULL, PartID INTEGER NOT NULL, Language NATIONAL CHARACTER VARYING(2) NOT NULL DEFAULT 'en', Title NATIONAL CHARACTER VARYING(255) NOT NULL, Description NATIONAL TEXT NULL, SpecialCaption NATIONAL TEXT NULL, DisplayOrderText NATIONAL CHARACTER VARYING(255) NULL, DisplayOrderCache NATIONAL CHARACTER VARYING(255) NULL, PRIMARY KEY (ResourceID,PartID,Language) ); /*=== Table: ResourceKeyword ===*/ /* Resource management subsystem: Keywords (general keywords applicable to the entire resource, not taxon-specific). */ /* ResourceID: ID of external resource to which keyword applies (foreign key). */ /* PartID: ID of part ('0' for entire resource) to which keyword applies (foreign key). */ /* Keyword: A keyword, esp. subject headings or private markers. A keyword may consist of multiple words (phrases, e.g. 'red herring'), which can then only be searched as a whole. */ /* Responsible: Person responsible for entering the keyword. */ CREATE TABLE ResourceKeyword ( ResourceID INTEGER NOT NULL, PartID INTEGER NOT NULL, Keyword NATIONAL CHARACTER VARYING(255) NOT NULL, Responsible INTEGER NOT NULL, PRIMARY KEY (ResourceID,PartID,Keyword) ); /*=== Table: ResourceTaxon ===*/ /* Resource management subsystem: Organism names, features or characteristics of the organism, and topics (nomenclature, description, distribution, etc.) covered. */ /* ResourceID: ID of external resource to which keyword applies (foreign key). */ /* PartID: ID of part ('0' for entire resource) to which keyword applies (foreign 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: 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. */ /* TopicDescription: 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. */ CREATE TABLE ResourceTaxon ( ResourceID INTEGER NOT NULL, PartID INTEGER NOT NULL, TaxonomicName NATIONAL CHARACTER VARYING(255) NULL, VernacularName NATIONAL CHARACTER VARYING(255) NULL, NomID INTEGER NULL DEFAULT 0, IdentificationQualifier NATIONAL CHARACTER VARYING(10) NULL, IdentificationResponsible NATIONAL CHARACTER VARYING(255) 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 ); /*=== Table: ResourceInstance ===*/ /* Resource instance: Attributes that apply to a specific quality instance of an information resouce. Inherits information from collection, abstract item, and quality class. */ /* ResourceID: ID of external resource to which this association applies (foreign key). */ /* QualityLevel: A quality level for this instance of the resource as defined in SysRsc_QualityLevel (foreign key). */ /* URI_ManualOverride: If this attribute is filled with a complete URI, it is directly used, ignoring the settings. */ /* 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). */ /* InstanceAvailabilityCache: (calculated value; = Min(QualityAvailability, ItemAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)). */ /* InstanceAvailableOnlineCache: (calculated value; = ItemAvailableOnline AND QualityAvailableOnline). */ /* CheckAvailability_LastTestWhen: The date and time the availability was last tested (set by a link checking program). The normal testing cycle should retest every 3 days. */ /* CheckAvailability_LastResult: The result of the last availability test (set by a link checking program). */ /* CheckAvailability_LastSuccessWhen: The last date and time when the availability test result was positive (set by a link checking program). */ /* CheckAvailability_Deactivated: Automatic deactivation of link if the LastResult is negative and LastSuccessWhen more than 14 days ago (set by a link checking program). */ /* CheckAvailability_DeactivatedWhen: Date and time when the resource instance was automatically deactivated. */ /* 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 SysRsc_MediaType (foreign key). Normally the type is automatically set based on file extension in URI, see SysMediaType for definitions. */ /* ResourceSize: Size of resource in bytes (file size, or length of download stream); this may be used to add size indications after links to help users in making appropriate choices. The value is 0 if the size is unknown. */ /* FileDate: The file date of those resource of which the file system date can be read. Used to identify updated instances and update those all other attributes that can be automatically obtained (e.g. size, pixel, etc.) are updated as well. */ /* 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. */ /* LogCreatedWhen: The date and time when this record was created. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE ResourceInstance ( ResourceID INTEGER NOT NULL, QualityLevel INTEGER NOT NULL, URI_ManualOverride NATIONAL CHARACTER VARYING(255) NULL, URI_Cache NATIONAL CHARACTER VARYING(255) NULL, InstanceAvailabilityCache TINYINT NOT NULL DEFAULT 0, InstanceAvailableOnlineCache BIT NOT NULL DEFAULT 0, CheckAvailability_LastTestWhen DATETIME NULL, CheckAvailability_LastResult BIT NULL, CheckAvailability_LastSuccessWhen DATETIME NULL, CheckAvailability_Deactivated BIT NOT NULL DEFAULT 0, CheckAvailability_DeactivatedWhen DATETIME NULL, CheckAvailability_Attempts INTEGER NULL DEFAULT 0, CheckAvailability_Failures INTEGER NULL DEFAULT 0, CheckAvailability_ResetWhen DATETIME NULL, MediaTypeID INTEGER NULL, ResourceSize INTEGER NOT NULL DEFAULT 0, FileDate DATETIME NULL, ImgPixelHeight INTEGER NOT NULL DEFAULT 0, ImgPixelWidth INTEGER NOT NULL DEFAULT 0, ImgColorDepth INTEGER NOT NULL DEFAULT 0, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp, PRIMARY KEY (ResourceID,QualityLevel) ); /*=== Table: AppRsc_MediaType ===*/ /* System wide definition of resource media types, according to MIME (rfc 2046; e.g. file format image/gif). */ /* MediaTypeID: Internal ID number for 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 AppRsc_MediaType ( MediaTypeID INTEGER 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: AppRsc_MediaTypeExtension ===*/ /* 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 AppRsc_MediaTypeExtension ( RecognizedFileExtension NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, MediaTypeID INTEGER NULL ); /*=== Table: AppRsc_MediaTypeIcon ===*/ /* System wide definition of generic icon images for resource media types (file formats), optionally quality dependent. */ /* MediaTypeID: ID number of media type (foreign key + 1st part of primary key). */ /* QualityLevel: A quality level as defined in SysRsc_QualityLevel (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 AppRsc_MediaTypeIcon ( MediaTypeID INTEGER 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: Presentation ===*/ /* A resource presentation is similar to a resource collection, but it may combine several collections. */ /* PresentationID: Presentation ID, unique system generated value (primary key). */ /* Title: Unique user readable title, identifying the resource presentation. Example: 'Collected Ascochyta images'. */ /* Description: Short description of a presentation of information resources, about one paragraph long. Basic xhtml formatting tags are permitted. */ /* Authors: A list of authors displayed on the title page for the resource presentation. */ /* Editors: A list of editors displayed on the title page for the resource presentation. */ /* AcknowledgementID: Refers to an acknowledgement definition that documents source and intellectual property rights, and provides a formatted acknowledgements (foreign key). */ /* InternalNotes: Internal notes and remarks. */ /* CreateTitlePage: Automatically generate a separate title page for the presentation. */ /* CreateTableOfContents: Automatically generate a hyperlinked table of contents page from the heading elements defined. */ /* PageFooterText: Footer to be displayed on each page of the presentation. */ /* PageBreakMaxElements: If long presentations are not structured by headings, a new presentation page is started after this number of elements. */ /* PageBreakAtHeading: Heading level at which a new a new presentation page is started (all presentation pages are linked as consecutive pages). */ /* StylesheetScreenURI: URI to the stylesheet to be used for screen display (a default stylesheet will be used if empty). */ /* StylesheetPrintURI: URI to the stylesheet to be used for printing (a default stylesheet will be used if empty). */ /* ResourceQualityLevelStart: For resources with multiple quality classes: Quality level of a resource initially displayed in a presentation (e.g. a preview like thumbnail image), possibly hyperlinking to higher quality levels, see ResourceQualityLevelEnd. */ /* ResourceQualityLevelEnd: For resources with multiple quality classes: Last quality level of a resource displayed in a presentation, higher quality levels are not hyperlinked. */ /* ResourceShowUpdateStatus: For resources: display update status of resource using icons for 'new' or 'updated'. */ /* LogCreatedBy: The user who created this record. */ /* LogCreatedWhen: The date and time when this record was created. Also serves as publication date of the presentation. */ /* LogUpdatedBy: The user who updated this record the last time. */ /* LogUpdatedWhen: The date and time when this record was last updated. */ CREATE TABLE Presentation ( PresentationID INTEGER IDENTITY NOT NULL PRIMARY KEY, Title NATIONAL CHARACTER VARYING(80) NOT NULL UNIQUE, Description NATIONAL TEXT NOT NULL, Authors NATIONAL CHARACTER VARYING(255) NULL, Editors NATIONAL CHARACTER VARYING(255) NULL, AcknowledgementID INTEGER NULL, InternalNotes NATIONAL TEXT NULL, CreateTitlePage BIT NULL DEFAULT 1, CreateTableOfContents BIT NULL DEFAULT 1, PageFooterText NATIONAL TEXT NULL, PageBreakMaxElements INTEGER NOT NULL DEFAULT 500, PageBreakAtHeading INTEGER NOT NULL DEFAULT 0, StylesheetScreenURI NATIONAL CHARACTER VARYING(255) NULL, StylesheetPrintURI NATIONAL CHARACTER VARYING(255) NULL, ResourceQualityLevelStart INTEGER NULL DEFAULT 0, ResourceQualityLevelEnd INTEGER NULL DEFAULT 0, ResourceShowUpdateStatus BIT NOT NULL DEFAULT 1, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp ); /*=== Table: PresentationElement ===*/ /* Items contained in a presentation. A resource presentation may combine several collections. */ /* PresentationID: Presentation ID (foreign key). */ /* DisplayOrder: The order in which the presentation elements are displayed. */ /* ElementType: Different presentation elements (heading, paragraph, list element, hyperlink, reference, etc.) are formatted differently. */ /* DisplayText: If element type is html, heading, paragraph, or list element: Contains the text for output. If element type is resource: overrules the default caption or link title. Leave empty to use the default title. */ /* ResourcePresentation: For resource elements: Presentation mode (Link, Download, Embed, etc.) to be used. Default: use the recommended presentation mode defined in the quality class of the resource. */ /* ResourceDirectID: For resource elements: Directly defines a single resource item to be used (foreign key). */ /* ResourceLookupKeyword: For resource elements: Retrieve all resources containing this keyword, optionally further restricted by resource collection. */ /* ResourceLookupCollectionID: For resource elements: Retrieve all resources from this resource collection (foreign key), optionally further restricted by keyword. */ /* ReferenceID: For reference elements: An optional reference as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). */ /* ReferenceDescriptionCache: For reference elements: A readable description (author, year, etc.) corresponding to ReferenceID, automatically updated from the reference management subsystem. */ /* KeyID_Notimplemented: NOT YET IMPLEMENTED: Applicable only if element type is identification key: Defines the identification key to be inserted here. */ /* 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. */ /* SourceReferenceDetail: If presentation has a published source: the page or figure number corresponding to the current presentation element in the published source. */ CREATE TABLE PresentationElement ( PresentationID INTEGER NOT NULL, DisplayOrder INTEGER NOT NULL DEFAULT CLng((Now()-37188)*250000), ElementType INTEGER NOT NULL DEFAULT 0, DisplayText NATIONAL TEXT NULL, ResourcePresentation NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT '-', ResourceDirectID INTEGER NULL, ResourceLookupKeyword NATIONAL CHARACTER VARYING(255) NULL, ResourceLookupCollectionID INTEGER NULL, ReferenceID NATIONAL CHARACTER VARYING(20) NULL, ReferenceDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, KeyID_Notimplemented INTEGER NULL, LogCreatedBy INTEGER NOT NULL, LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp, LogUpdatedBy INTEGER NULL, LogUpdatedWhen DATETIME NULL DEFAULT current_timestamp, SourceReferenceDetail NATIONAL CHARACTER VARYING(50) NULL, PRIMARY KEY (PresentationID,DisplayOrder) ); /*=== Table: Resource_URI_Translation ===*/ /* DISCUSS: URI translation service. When URI is changed, the old URI is copied into a permanent translation table and can be replaced from there. Difficult to interact with the web server! */ CREATE TABLE Resource_URI_Translation ( OldInstanceURI NATIONAL CHARACTER VARYING(255) NULL, NewInstanceURI NATIONAL CHARACTER VARYING(255) NULL ); ALTER TABLE ResourceManager 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 AppRsc_QualityLevel (QualityLevel) ON UPDATE CASCADE, FOREIGN KEY (AutoGenerateFrom) REFERENCES AppRsc_QualityLevel (QualityLevel) ON UPDATE CASCADE ALTER TABLE ResourceAbstractItem ADD FOREIGN KEY (ResourceCollectionID) REFERENCES ResourceCollection (ResourceCollectionID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceDescription ADD FOREIGN KEY (ResourceID) REFERENCES ResourceAbstractItem (ResourceID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceDisplayElement ADD FOREIGN KEY (ResourceID,PartID) REFERENCES ResourceDescription (ResourceID,PartID) ALTER TABLE ResourceKeyword ADD FOREIGN KEY (ResourceID,PartID) REFERENCES ResourceDescription (ResourceID,PartID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceTaxon ADD FOREIGN KEY (ResourceID,PartID) REFERENCES ResourceDescription (ResourceID,PartID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ResourceInstance ADD FOREIGN KEY (ResourceID) REFERENCES ResourceAbstractItem (ResourceID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (MediaTypeID) REFERENCES AppRsc_MediaType (MediaTypeID), FOREIGN KEY (QualityLevel) REFERENCES AppRsc_QualityLevel (QualityLevel) ON UPDATE CASCADE ALTER TABLE AppRsc_MediaTypeExtension ADD FOREIGN KEY (MediaTypeID) REFERENCES AppRsc_MediaType (MediaTypeID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE AppRsc_MediaTypeIcon ADD FOREIGN KEY (MediaTypeID) REFERENCES AppRsc_MediaType (MediaTypeID) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (QualityLevel) REFERENCES AppRsc_QualityLevel (QualityLevel) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE PresentationElement ADD FOREIGN KEY (PresentationID) REFERENCES Presentation (PresentationID) ON UPDATE CASCADE ON DELETE 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 a collection of information resources, about one 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'A list of authors displayed on the title page for the entire collection. Authors or editors need not be identical with resource managers.',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 for the entire collection. Authors or editors need not be identical with resource managers.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'Editors' exec sp_addextendedproperty N'MS_Description',N'Description of the source or origin of resources in the current collection, esp. if URI point to files. 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). Examples: ''''AUTH92Q974'' 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 acknowledgements (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'CopyrightDocumentation' exec sp_addextendedproperty N'MS_Description',N'Internal notes and remarks.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'If available via http/ftp: The first part of the URI, before the variable part defined in the individual resource. Should include protocol, server, and beginning of path. Example: ''http://www.example.net/images''.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'URI_Part1' exec sp_addextendedproperty N'MS_Description',N'If available on a local fileserver/in a local area network: The start of the path. This can be used as an alternative to internet access while in the local area network. Example: ''\\server\images\''. Mapped network drives (''Z:\images'') should be avoided!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'LAN_Part1' exec sp_addextendedproperty N'MS_Description',N'Description of location (local LAN path, label of CDs, etc. ) where a backup of the resource collection (including all resource instance files) is kept.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'BackupLocation' exec sp_addextendedproperty N'MS_Description',N'A date which may be up to 2 years 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'Does the collection contain links to content for which the organization hosting the web site itself is responsible?',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'xx_ManagedContent' exec sp_addextendedproperty N'MS_Description',N'True if editorial control is required; necessary for managed content. Can be changed only by responsible managers of the internet site, not by resource collection managers. If set to false, EditorialReleaseBy/When are updated to document responsibility.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialControl' exec sp_addextendedproperty N'MS_Description',N'Name of a responsible manager of the internet site; can NOT be set by resource collection managers. The editorial review mechanism guarantees that no unwanted information is presented on the website, esp. for images uploaded by external users.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialReleaseBy' exec sp_addextendedproperty N'MS_Description',N'Date up to which the resources have been reviewed. Instances added at a later date are automatically prevented from being available in the internet.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'EditorialReleaseWhen' exec sp_addextendedproperty N'MS_Description',N'True if collection has been introduced as a template for new collections.',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'IsTemplate' exec sp_addextendedproperty N'MS_Description',N'Keywords that are automatically inserted into all new resource items / can be changed only for new items!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'xx_DefaultKeywords' exec sp_addextendedproperty N'MS_Description',N'Keywords that apply to the collection / can be changed at any time!',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'xx_CollectionKeywords' exec sp_addextendedproperty N'MS_Description',N'Names AND/OR IDs?',N'user',N'dbo',N'table',N'ResourceCollection',N'column',N'xx_DefaultTaxa' 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'The user who updated this record the last time.',N'user',N'dbo',N'table',N'ResourceCollection',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'ResourceCollection',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'ID of the resource collection (foreign key).',N'user',N'dbo',N'table',N'ResourceManager',N'column',N'ResourceCollectionID' exec sp_addextendedproperty N'MS_Description',N'ID of user who may manage the resource information in the resource collection (foreign key, referring to DiversityUsers.UserID).',N'user',N'dbo',N'table',N'ResourceManager',N'column',N'ManagingUserID' exec sp_addextendedproperty N'MS_Description',N'Refers to a resource collection (foreign 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 class of resources as defined in SysRsc_QualityLevel (foreign key).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'Optional string, inserted between URL_Part1 (see ResourceCollection) and the individual resource name URL_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, 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'Availability scope (managers, login, intranet, internet) of resource instances of this quality class (also restricted by ItemAvailability!).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'QualityAvailability' exec sp_addextendedproperty N'MS_Description',N'Access immediacy: True = directly online available; False = only meta information (keywords), but no access information (URI) is provided, available only on explicit request by electronic or postal means. (Also restricted by ItemAvailableOnline!).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'QualityAvailableOnline' exec sp_addextendedproperty N'MS_Description',N'A quality level from which resource instances for the current quality level can be generated (e.g. an image robot generating thumbnails) for each resource item. Leave empty if the instances are created manually.',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'AutoGenerateFrom' exec sp_addextendedproperty N'MS_Description',N'A command calling the auto-generation robot with specific parameters (e.g. indicating the size of the desired preview image).',N'user',N'dbo',N'table',N'ResourceQualityClass',N'column',N'AutoGenerationCommand' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding this quality version of the resource (history, 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 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'Unique ID for the quality level (primary key).',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',N'column',N'QualityLevel' exec sp_addextendedproperty N'MS_Description',N'User readable, unique description of quality level, e.g. "original version" or "modified"; for images: "full resolution", "default compressed", or "thumbnail image".',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',N'column',N'QualityLevelDescription' exec sp_addextendedproperty N'MS_Description',N'Primary location (= 0) or first and second mirror location. Mirror quality classes should not normally be offered as quality levels in the user interface.',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',N'column',N'Mirror' exec sp_addextendedproperty N'MS_Description',N'Default for recommended presentation mode (Link, Download, Embed) of new quality classes.',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',N'column',N'PresentationDefault' exec sp_addextendedproperty N'MS_Description',N'Only a single quality class is used (however, multiple classes may be present due to mirror classes). Most QualityClass attributes in editing form are unavailable (except always RecommendedPresentation and if Mirror is > 0 also URI_Path2 ).',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',N'column',N'SingleClass' exec sp_addextendedproperty N'MS_Description',N'Information in this quality level is abridged, e.g. thumbnail preview, or short preview sequences from a video.',N'user',N'dbo',N'table',N'AppRsc_QualityLevel',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'AppRsc_QualityLevel',N'column',N'Internal' exec sp_addextendedproperty N'MS_Description',N'Unique ID for external information resource (primary key).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'The specific information stored here is supplemented with the attributes defined in this resource collection entity (foreign key).',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 QualityClass attributes URI_Part2 and Part4. Example: ''figure13''.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'URI_Part3' exec sp_addextendedproperty N'MS_Description',N'Availability scope (managers, login, intranet, internet) of resource instances of this abstract item (also restricted by QualityAvailability!).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ItemAvailability' exec sp_addextendedproperty N'MS_Description',N'Access immediacy: True = directly online available; False = only meta information (keywords), but no access information (URI) is provided, available only on explicit request by electronic or postal means. (Also restricted by QualityAvailableOnline!).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'ItemAvailableOnline' exec sp_addextendedproperty N'MS_Description',N'If resource is 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'xx_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'Optional: 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 that are present in published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Compare also ResourceCollection.ReferenceID!',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'Detail, especially page or figure number in a reference. Available if either the entire collection, or the current item is derived from a published source.',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceReferenceDetail' exec sp_addextendedproperty N'MS_Description',N'The full, unchanged text of the original caption for the resource, esp. in the case of images (if resource has parts, the captions of all parts are entered here).',N'user',N'dbo',N'table',N'ResourceAbstractItem',N'column',N'SourceCaption' 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'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'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 part. ''0'' for entire resource. PartID is used by external modules to identify a resource part and should therefore not be changed at a later time.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'PartID' exec sp_addextendedproperty N'MS_Description',N'For parts of resources: label identifying resource parts or components (e.g. a-, b-, c-labeled figures in images, 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'PartLabel' 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 for text, etc.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'PartStart' 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 PartStart for examples of technical units.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'PartEnd' 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 creators of the instance, e.g. a scan of an image!).',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'Creators' exec sp_addextendedproperty N'MS_Description',N'Optional: information regarding the creation process, e.g. image capture date/time, location, 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 regarding copyright of resource, esp. name of person or institution holding the copyright to this resource. Leave empty if unknown or if all content in the resource collection has the same copyright owner.',N'user',N'dbo',N'table',N'ResourceDescription',N'column',N'CopyrightInformation' 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'ResourceDisplayElement',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'ID of part (''0'' for entire resource) to which the display element applies (foreign key).',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'PartID' exec sp_addextendedproperty N'MS_Description',N'2 letter iso code of language.',N'user',N'dbo',N'table',N'ResourceDisplayElement',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.',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Short description of the entire resource, especially displayed as additional information after a hyperlink. Basic xhtml character formatting tags are allowed. In the absence of SpecialCaption the description is also used as caption for embedded resources.',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Optional: If description is not suitable as caption of an embedded resource, a special caption may be defined here. Basic xhtml formatting tags may be used. For images information about measurement scale (example: ''bar=10 µm'') should be included.',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'SpecialCaption' exec sp_addextendedproperty N'MS_Description',N'If filled, used for sorting in a presentation. Example: ''The Area of New York'' shall be sorted under ''New York'', or at position ''34''. Text sorting, use ''09'', ''10'', or ''10'' < ''9''! Normally the attribute is empty and resources are sorted by title.',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'DisplayOrderText' exec sp_addextendedproperty N'MS_Description',N'Calculated field, set to DisplayOrderText if present, otherwise to Title. Introduced to allow indexing and fast sorting.',N'user',N'dbo',N'table',N'ResourceDisplayElement',N'column',N'DisplayOrderCache' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which 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 part (''0'' for entire resource) to which keyword applies (foreign key).',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'PartID' exec sp_addextendedproperty N'MS_Description',N'A keyword, esp. subject headings or private markers. A keyword may consist of multiple words (phrases, e.g. ''red herring''), which can then only be searched as a whole.',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'Keyword' exec sp_addextendedproperty N'MS_Description',N'Person responsible for entering the keyword.',N'user',N'dbo',N'table',N'ResourceKeyword',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'ID of external resource to which keyword applies (foreign key).',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'ID of part (''0'' for entire resource) to which keyword applies (foreign key).',N'user',N'dbo',N'table',N'ResourceTaxon',N'column',N'PartID' 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'0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource.',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'ID of external resource to which this association applies (foreign key).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ResourceID' exec sp_addextendedproperty N'MS_Description',N'A quality level for this instance of the resource as defined in SysRsc_QualityLevel (foreign 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 the settings.',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(QualityAvailability, ItemAvailability) 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'InstanceAvailabilityCache' exec sp_addextendedproperty N'MS_Description',N'(calculated value; = ItemAvailableOnline AND QualityAvailableOnline).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'InstanceAvailableOnlineCache' exec sp_addextendedproperty N'MS_Description',N'The date and time the availability was last tested (set by a link checking program). The normal testing cycle should retest every 3 days.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_LastTestWhen' 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'The last date and time when the availability test result was positive (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'Automatic deactivation of link if the LastResult is negative and LastSuccessWhen more than 14 days ago (set by a link checking program).',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_Deactivated' exec sp_addextendedproperty N'MS_Description',N'Date and time when the resource instance was automatically deactivated.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'CheckAvailability_DeactivatedWhen' 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 SysRsc_MediaType (foreign key). Normally the type is automatically set based on file extension in URI, see SysMediaType for definitions.',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 length of download stream); this may be used to add size indications after links to help users in making appropriate choices. The value is 0 if the size is unknown.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'ResourceSize' exec sp_addextendedproperty N'MS_Description',N'The file date of those resource of which the file system date can be read. Used to identify updated instances and update those all other attributes that can be automatically obtained (e.g. size, pixel, etc.) are updated as well.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'FileDate' 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 created.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'LogCreatedWhen' exec sp_addextendedproperty N'MS_Description',N'The date and time when this record was last updated.',N'user',N'dbo',N'table',N'ResourceInstance',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Internal ID number for media type.',N'user',N'dbo',N'table',N'AppRsc_MediaType',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'AppRsc_MediaType',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'AppRsc_MediaType',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'AppRsc_MediaType',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'AppRsc_MediaType',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'AppRsc_MediaType',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'AppRsc_MediaTypeExtension',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'AppRsc_MediaTypeExtension',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'AppRsc_MediaTypeIcon',N'column',N'MediaTypeID' exec sp_addextendedproperty N'MS_Description',N'A quality level as defined in SysRsc_QualityLevel (foreign key + 2nd part of primary key).',N'user',N'dbo',N'table',N'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',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'AppRsc_MediaTypeIcon',N'column',N'LargeIconHeight' exec sp_addextendedproperty N'MS_Description',N'Presentation ID, unique system generated value (primary key).',N'user',N'dbo',N'table',N'Presentation',N'column',N'PresentationID' exec sp_addextendedproperty N'MS_Description',N'Unique user readable title, identifying the resource presentation. Example: ''Collected Ascochyta images''.',N'user',N'dbo',N'table',N'Presentation',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'Short description of a presentation of information resources, about one paragraph long. Basic xhtml formatting tags are permitted.',N'user',N'dbo',N'table',N'Presentation',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'A list of authors displayed on the title page for the resource presentation.',N'user',N'dbo',N'table',N'Presentation',N'column',N'Authors' exec sp_addextendedproperty N'MS_Description',N'A list of editors displayed on the title page for the resource presentation.',N'user',N'dbo',N'table',N'Presentation',N'column',N'Editors' exec sp_addextendedproperty N'MS_Description',N'Refers to an acknowledgement definition that documents source and intellectual property rights, and provides a formatted acknowledgements (foreign key).',N'user',N'dbo',N'table',N'Presentation',N'column',N'AcknowledgementID' exec sp_addextendedproperty N'MS_Description',N'Internal notes and remarks.',N'user',N'dbo',N'table',N'Presentation',N'column',N'InternalNotes' exec sp_addextendedproperty N'MS_Description',N'Automatically generate a separate title page for the presentation.',N'user',N'dbo',N'table',N'Presentation',N'column',N'CreateTitlePage' exec sp_addextendedproperty N'MS_Description',N'Automatically generate a hyperlinked table of contents page from the heading elements defined.',N'user',N'dbo',N'table',N'Presentation',N'column',N'CreateTableOfContents' exec sp_addextendedproperty N'MS_Description',N'Footer to be displayed on each page of the presentation.',N'user',N'dbo',N'table',N'Presentation',N'column',N'PageFooterText' exec sp_addextendedproperty N'MS_Description',N'If long presentations are not structured by headings, a new presentation page is started after this number of elements.',N'user',N'dbo',N'table',N'Presentation',N'column',N'PageBreakMaxElements' exec sp_addextendedproperty N'MS_Description',N'Heading level at which a new a new presentation page is started (all presentation pages are linked as consecutive pages).',N'user',N'dbo',N'table',N'Presentation',N'column',N'PageBreakAtHeading' exec sp_addextendedproperty N'MS_Description',N'URI to the stylesheet to be used for screen display (a default stylesheet will be used if empty).',N'user',N'dbo',N'table',N'Presentation',N'column',N'StylesheetScreenURI' exec sp_addextendedproperty N'MS_Description',N'URI to the stylesheet to be used for printing (a default stylesheet will be used if empty).',N'user',N'dbo',N'table',N'Presentation',N'column',N'StylesheetPrintURI' exec sp_addextendedproperty N'MS_Description',N'For resources with multiple quality classes: Quality level of a resource initially displayed in a presentation (e.g. a preview like thumbnail image), possibly hyperlinking to higher quality levels, see ResourceQualityLevelEnd.',N'user',N'dbo',N'table',N'Presentation',N'column',N'ResourceQualityLevelStart' exec sp_addextendedproperty N'MS_Description',N'For resources with multiple quality classes: Last quality level of a resource displayed in a presentation, higher quality levels are not hyperlinked.',N'user',N'dbo',N'table',N'Presentation',N'column',N'ResourceQualityLevelEnd' exec sp_addextendedproperty N'MS_Description',N'For resources: display update status of resource using icons for ''new'' or ''updated''.',N'user',N'dbo',N'table',N'Presentation',N'column',N'ResourceShowUpdateStatus' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'Presentation',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 presentation.',N'user',N'dbo',N'table',N'Presentation',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'Presentation',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'Presentation',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'Presentation ID (foreign key).',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'PresentationID' exec sp_addextendedproperty N'MS_Description',N'The order in which the presentation elements are displayed.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Different presentation elements (heading, paragraph, list element, hyperlink, reference, etc.) are formatted differently.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ElementType' exec sp_addextendedproperty N'MS_Description',N'If element type is html, heading, paragraph, or list element: Contains the text for output. If element type is resource: overrules the default caption or link title. Leave empty to use the default title.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'DisplayText' exec sp_addextendedproperty N'MS_Description',N'For resource elements: Presentation mode (Link, Download, Embed, etc.) to be used. Default: use the recommended presentation mode defined in the quality class of the resource.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ResourcePresentation' exec sp_addextendedproperty N'MS_Description',N'For resource elements: Directly defines a single resource item to be used (foreign key).',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ResourceDirectID' exec sp_addextendedproperty N'MS_Description',N'For resource elements: Retrieve all resources containing this keyword, optionally further restricted by resource collection.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ResourceLookupKeyword' exec sp_addextendedproperty N'MS_Description',N'For resource elements: Retrieve all resources from this resource collection (foreign key), optionally further restricted by keyword.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ResourceLookupCollectionID' exec sp_addextendedproperty N'MS_Description',N'For reference elements: An optional reference as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key).',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ReferenceID' exec sp_addextendedproperty N'MS_Description',N'For reference elements: A readable description (author, year, etc.) corresponding to ReferenceID, automatically updated from the reference management subsystem.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'ReferenceDescriptionCache' exec sp_addextendedproperty N'MS_Description',N'NOT YET IMPLEMENTED: Applicable only if element type is identification key: Defines the identification key to be inserted here.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'KeyID_Notimplemented' exec sp_addextendedproperty N'MS_Description',N'The user who created this record.',N'user',N'dbo',N'table',N'PresentationElement',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'PresentationElement',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'PresentationElement',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'PresentationElement',N'column',N'LogUpdatedWhen' exec sp_addextendedproperty N'MS_Description',N'If presentation has a published source: the page or figure number corresponding to the current presentation element in the published source.',N'user',N'dbo',N'table',N'PresentationElement',N'column',N'SourceReferenceDetail' GO *** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/