By G. Hagedorn, 2002
This document contains a complete list of all entities and attributes used in the information model of this application module. It is primarily intended as a technical reference. It can also be helpful, however, in understanding the scope and usage of certain attributes. When you have a question like 'where does this information fit in', reading the attribute description may help you.
Besides the human readable documentation provided below, three additional technical documents are provided:
See also the separate alphabetical index to attribute names.
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!
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ResourceCollectionID | Long | Resource collection ID, unique system generated value (primary key). Default value: =CLng(Rnd()*2147483647.1), validation message: A resource collection ID must be a positive number. |
R | I (P) |
| Title | Text | Unique user readable title, identifying the resource collection. Example: 'Ascochyta images from Melnik (1977)'. | R | I/I(UNM)+ |
| Description | Memo | Short description of the resource collection, ca. a single paragraph long. Basic xhtml formatting tags are permitted. | R | - |
| Coverage | Memo | 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 | Text | 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. | - | I(UNM) |
| Editors | Text | 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. | - | I(UNM) |
| Contributors | Text | A list of contributors displayed on the title page of the entire collection. | - | - |
| SourceDescription | Memo | 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 | Text | 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. | - | I (N) |
| SourceRefDescriptionCache | Text | A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem. | - | - |
| AcknowledgementID | Long | Refers to an acknowledgement definition that documents source and intellectual property rights, and provides a formatted acknowledgement (foreign key). | - | I |
| Rights | Memo | 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 | Memo | Internal notes and remarks. Not published in public reports. | - | - |
| IconURI | Text | URI of a icon or logo, usually a small gif file that can be displayed next to the collection title. | - | - |
| IconLinkURI | Text | A URI that may optionally be placed behind the collection icon, to create a hyperlink to another site on the world-wide-web. | - | - |
| IconLinkHidden | Boolean | True = no link border around icon image (default); False = a colored link border is added around icon image. Default value: -1 |
R | - |
| IconDescription | Text | Text used for the alternative text of the image; usually this text is also displayed when the mouse hovers over the image. | - | - |
| IconWidth | Long | Width of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no width is available. Default value: 0 |
R | - |
| IconHeight | Long | Height of image in pixels (improves speed with which html pages can be displayed). Set to 0 if no height is available. Default value: 0 |
R | - |
| ReleaseDate | Date/Time | 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). Default value: Now(); Validation rule: <(CLng(Now())+366), validation message: The release date may be only up to 1 year in the future. |
R | - |
| ReleaseNotes | Text | 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 | Boolean | 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! Default value: False |
R | - |
| EditorialControl | Boolean | 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. Default value: True |
R | - |
| EditorialControlDelegated | Boolean | 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! Default value: False |
R | - |
| EditorialControlDocumentation | Memo | 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 | Long | The responsible site manager who delegated the editorial control. Editable only by site managers, not by resource collection managers! | - | - |
| EditorialControlSetWhen | Date/Time | Date/time when the EditorialControl was delegated. Validation rule: Is Null Or <=Now() |
- | - |
| EditorialReleaseBy | Long | 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 | 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. Validation rule: Is Null Or <=Now() |
- | - |
| CheckAvailability_LastTestWhen | Date/Time | 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. Default value: 0 |
R | - |
| CheckAvailability_Interval | Integer | The number of days after which a routine availability check of all resource instances shall be performed. Set to 999999 to disable routine test. Default value: 60; Validation rule: (>0 And <501) Or 999999, validation message: The number of days between availability tests must be between 1 and 500, or set to 999999 to disable the test. |
R | - |
| IsTemplate | Boolean | True for templates used to create a new resource collection together with the relevant resource classes. System attribute, not user editable, default is false. Default value: False |
R | - |
| [LogCreatedBy] | Long | The user who created this record. | R | - |
| [LogCreatedWhen] | Date/Time | 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). Default value: Now() |
R | - |
| Table validation rule: | (Not IsNull([Authors]) Or Not IsNull([Editors])) And ([EditorialControl] Or Not [ManagedContent]) And Not (IsNull([EditorialReleaseBy]) And Not IsNull([EditorialReleaseWhen])) And Not ((IsNull([EditorialControlSetBy]) And Not IsNull([EditorialControlSetWhen])) Or (Not IsNull([EditorialControlSetBy]) And IsNull([EditorialControlSetWhen]))) And Not (([EditorialControlDelegated] Or Not [EditorialControl]) And (IsNull([EditorialControlDocumentation]) Or IsNull([EditorialControlSetBy]) Or IsNull([EditorialControlSetWhen]))) | |||
| Table validation text: | a) Either Authors or Editors must be defined. b) ManagedContent requires EditorialControl. c) EditorialControlDelegated=true or EditorialControl=false require E.Con.-Documentation, -SetBy and -SetWhen. | |||
| Index name: | Attributes & index properties | |||
| AcknowledgementID: | AcknowledgementID (Duplicates OK) | |||
| PrimaryKey: | ResourceCollectionID (Primary key; Unique values) | |||
| SourceReferenceID: | SourceReferenceID (Duplicates OK; Ignore Nulls) | |||
| Title: | Title (Duplicates OK) | |||
| TitleWithAuthorsUnique: | Title; Authors (Unique values; Ignore Nulls) | |||
| TitleWithEditorsUnique: | Title; Editors (Unique values; Ignore Nulls) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceAbstractItem.ResourceCollectionID | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceQualityClass.ResourceCollectionID | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceManager.ResourceCollectionID | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceProvider.ResourceCollectionID | |||
Defines providers (primary/backup mirror/load balancing mirrors, online/offline status, etc.) of the content of a resource collection.
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ResourceCollectionID | Long | Refers to a resource collection (foreign key and part of primary key). | R | I(PM) | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| ProviderOrder | Long | Number defining the order in which mirrored backup providers are accessed. Unique within a ResourceCollection (part of primary key). Default value: 1 |
R | I(PM) | ||||||||||||||||||||||||||||||||||||
| Status | Text | Defines status as: Online primary location, Online load balancing, Online backup/mirror, Offline backup. | R | - | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| URI_Part1 | Text | 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'. |
- | - | ||||||||||||||||||||||||||||||||||||
| Examples values (any other values may be added): |
|
|||||||||||||||||||||||||||||||||||||||
| URI_Part1_Write | Text | 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. |
- | - | ||||||||||||||||||||||||||||||||||||
| Examples values (any other values may be added): |
|
|||||||||||||||||||||||||||||||||||||||
| InternalNotes | Memo | Internal notes and remarks. | - | - | ||||||||||||||||||||||||||||||||||||
| [LogCreatedBy] | Long | The user who created this record. | R | - | ||||||||||||||||||||||||||||||||||||
| [LogCreatedWhen] | Date/Time | The date and time when this record was created. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||
| [LogUpdatedBy] | Long | The user who updated this record the last time. | R | - | ||||||||||||||||||||||||||||||||||||
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||
| Index name: | Attributes & index properties | |||||||||||||||||||||||||||||||||||||||
| PrimaryKey: | ResourceCollectionID; ProviderOrder (Primary key; Unique values) | |||||||||||||||||||||||||||||||||||||||
| Relation type: | Attributes involved | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceProvider.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||
| Simple relation (no integrity) | ResourceProvider.ResourceCollectionID « ResourceQualityClass.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceProvider.ResourceCollectionID « ResourceInstance.ResourceCollectionID; ResourceProvider.ProviderOrder « ResourceInstance.ProviderOrder | |||||||||||||||||||||||||||||||||||||||
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.
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ResourceCollectionID | Long | Refers to a resource collection (foreign key and part of primary key). | R | I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| QualityLevel | Long | A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key). | R | I/I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| OnlineAvailability | Byte+ | Online availability scope (managers, login, intranet, internet) of resource instances of this quality class (also restricted by ItemOnlineAvailability of abstract item!). Default value: 9; Validation rule: In (0,3,6,9), validation message: The availability scope must come from the list of predefined values. |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| RequestAvailability | Byte+ | 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!). Default value: 9; Validation rule: In (0,3,6,9), validation message: The availability scope must come from the list of predefined values. |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| URI_Part2 | Text | Optional string, inserted between URI_Part1 (see ResourceProvider) and the individual resource name URI_Part3 (see ResourceAbstractItem). | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| URI_Part4 | Text | 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 | Text | Recommended presentation mode (Link, New-window-link, Download, Embed). The web interface may either follow the recommendation or implement its own rules. Default value: "L"; Validation rule: "L" Or "N" Or "E" Or "D" |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| AutoGenerateMethodID | Long | 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. Default value: 0 |
R | I | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| InternalNotes | Text | Internal notes regarding this quality version of the resource (history of editing, steps taken to generate this version, compression rate, etc.). | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| [LogCreatedBy] | Long | The user who created this record. | R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| [LogCreatedWhen] | Date/Time | The date and time when this record was created. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| [LogUpdatedBy] | Long | The user who updated this record the last time. | R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Table validation rule: | [RequestAvailability]>=[OnlineAvailability] | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Table validation text: | The availabilty scope may not be smaller in 'On Request' (RequestAvailability) than in 'Online' (OnlineAvailability). | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Index name: | Attributes & index properties | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| AutoGenerateMethodID: | AutoGenerateMethodID (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| PrimaryKey: | ResourceCollectionID; QualityLevel (Primary key; Unique values) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| QualityLevel: | QualityLevel (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Relation type: | Attributes involved | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceQualityClass.ResourceCollectionID « ResourceInstance.ResourceCollectionID; ResourceQualityClass.QualityLevel « ResourceInstance.QualityLevel | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceQualityClass.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Simple relation (no integrity) | ResourceProvider.ResourceCollectionID « ResourceQualityClass.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Updates cascade | RscQualityLevel_Enum.QualityLevel « ResourceQualityClass.QualityLevel | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Updates cascade | RscAutoGenerateMethod_Enum.AutoGenerateMethodID « ResourceQualityClass.AutoGenerateMethodID | |||||||||||||||||||||||||||||||||||||||||||||||||||||
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.
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ResourceCollectionID | Long | ID of the resource collection (foreign key). | R | I(PM) | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| ManagingUserID | Long | ID of user who may manage the resource information in the resource collection (foreign key, referring to DiversityUsers.UserID). | R | I/I(PM) | ||||||||||||||||||||||||||||||||||||
| [LogCreatedBy] | Long | The user who created this record. | R | - | ||||||||||||||||||||||||||||||||||||
| [LogCreatedWhen] | Date/Time | The date and time when this record was created. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||
| Index name: | Attributes & index properties | |||||||||||||||||||||||||||||||||||||||
| ManagingUserID: | ManagingUserID (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||
| PrimaryKey: | ResourceCollectionID; ManagingUserID (Primary key; Unique values) | |||||||||||||||||||||||||||||||||||||||
| Relation type: | Attributes involved | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceManager.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||
The abstract resource item defines general information that applies to all duplicates or quality versions of a resource .
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ResourceID | Long | 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. Default value: =CLng(Rnd()*2147483647.1), validation message: A resource ID must be a positive number. |
R | I (P) | ||||||||||||||||||||||||||||||||||||
| ResourceCollectionID | Long | The specific information stored here is supplemented with the attributes defined in this resource collection entity (foreign key). | R | I | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| URI_Part3 | Text | 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. Validation rule: Not (Like ' %' Or Like '% ' Or Like '% %' Or Like '%' & Chr(10) & '%' Or Like '%' & Chr(13) & '%')on message: The availability scope must come from the list of predefined values. |
R | - | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| NumberingCategory | Byte+ | For reports where the resource will be embedded in another document: Defines a numbering sequence category (fig., tab., etc.) to be used. Default value: 0 |
R | - | ||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||
| LinkAssociatedIcon | Text | 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.). Validation rule: Is Null Or Not (ALike ' %' Or ALike '% ' Or ALike '% %' Or ALike '%' & Chr(10) & '%' Or ALike '%' & Chr(13) & '%')"nowrap">SourceLabel |
Text | 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 | Long | For resources from published sources: An ascending number reflecting the sequence of resources in the source. | - | - | ||||||||||||||||||||||||||||||||||||
| SourceCaption | Memo | 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). Validation rule: Is Null Or Not (Like ' %' Or Like '% ' Or Like '% %' Or Like '%' & Chr(10) & '%' Or Like '%' & Chr(13) & '%')tion Rqrd./Index |
| |||||||||||||||||||||||||||||||||||||
| ResourceID | Long | ID of external resource to which this description applies (foreign key). | R | I(PM) | ||||||||||||||||||||||||||||||||||||
| FragmentID | Long | 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. Default value: 0, validation message: You must use a positive number to identify a resource fragment. |
R | I/I(PM) | ||||||||||||||||||||||||||||||||||||
| FragmentLabel | Text | 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! Default value: "-" |
R | - | ||||||||||||||||||||||||||||||||||||
| FragmentStart | Text | 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 | Text | 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 | Text | 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 | Date/Time | 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 | Memo | Optional: additional information regarding the creation process, e.g. image lens, scale, exposure time, etc. | - | - | ||||||||||||||||||||||||||||||||||||
| Rights | Memo | 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 | Text | Language of the resource itself. Empty = not yet analysed; hyphen ('-') = language neutral (e.g. images without text). Compare also language of DiversityResource resource description under DisplayElement. 2 letter ISO code of language [DC 1.1!] | - | - | ||||||||||||||||||||||||||||||||||||
| InternalNotes | Memo | Internal notes, applying to the entire resource or parts of the resource. Visible only to managers of the resource collection. | - | I | ||||||||||||||||||||||||||||||||||||
| [LogCreatedBy] | Long | The user who created this record. | R | - | ||||||||||||||||||||||||||||||||||||
| [LogCreatedWhen] | Date/Time | The date and time when this record was created. Default value: Now() |
R | - | ||||||||||||||||||||||||||||||||||||
| [LogUpdatedBy] | Long | The user who updated this record the last time. | - | - | ||||||||||||||||||||||||||||||||||||
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
- | - | ||||||||||||||||||||||||||||||||||||
| Table validation rule: | ([FragmentLabel]<>'-' Or [FragmentStart] Is Null And [FragmentEnd] Is Null) | |||||||||||||||||||||||||||||||||||||||
| Index name: | Attributes & index properties | |||||||||||||||||||||||||||||||||||||||
| FragmentID: | FragmentID (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||
| InternalNotes: | InternalNotes (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||
| PrimaryKey: | ResourceID; FragmentID (Primary key; Unique values) | |||||||||||||||||||||||||||||||||||||||
| Relation type: | Attributes involved | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceAbstractItem.ResourceID « ResourceDescription.ResourceID | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceDisplayElement.ResourceID; ResourceDescription.FragmentID « ResourceDisplayElement.FragmentID | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceKeyword.ResourceID; ResourceDescription.FragmentID « ResourceKeyword.FragmentID | |||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceTaxon.ResourceID; ResourceDescription.FragmentID « ResourceTaxon.FragmentID | |||||||||||||||||||||||||||||||||||||||
Defines language specific elements in presentations. The web interface can support any language for which a display elements has been defined for the requested resource items.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ResourceID | Long | ID of external resource to which this description applies (foreign key). | R | I(PM) |
| FragmentID | Long | ID of fragment ('0' for entire resource) to which the display element applies (foreign key). Default value: 0, validation message: You must use a positive number to identify a resource fragment. |
R | I(PM) |
| Language | Text | 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!] Default value: "en" |
R | I(PM) |
| Title | Text | 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!] | R | - |
| Description | Memo | 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 | Memo | 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. | - | - |
| DisplayOrderText | Text | 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 | Text | Calculated field, set to DisplayOrderText if present, otherwise to Title. Introduced to allow indexing and fast sorting. | - | I |
| [LogUpdatedBy] | Long | The user who created/updated the keyword. | R | - |
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| DisplayOrderCache: | DisplayOrderCache (Duplicates OK) | |||
| PrimaryKey: | ResourceID; FragmentID; Language (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceDisplayElement.ResourceID; ResourceDescription.FragmentID « ResourceDisplayElement.FragmentID | |||
Resource management subsystem: Keywords (general keywords applicable to the entire resource, not taxon-specific).
| Name | Type | Description / Default value & validation | Rqrd./Index | ||||||
|---|---|---|---|---|---|---|---|---|---|
| ResourceID | Long | ID of external resource to which the keyword applies (foreign key). | R | I/I(PM) | |||||
| FragmentID | Long | ID of fragment ('0' for entire resource) to which the keyword applies (foreign key). Default value: 0, validation message: You must use a positive number to identify a resource fragment. |
R | I(PM) | |||||
| Keyword | Text | A keyword, including subject headings or private markers. A keyword entry may consist of multiple words or phrases (e. g. 'red herring'). | R | I(PM) | |||||
| Examples values (any other values may be added): |
|
||||||||
| [LogUpdatedBy] | Long | The user who created/updated the keyword. | R | - | |||||
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
R | - | |||||
| Index name: | Attributes & index properties | ||||||||
| PrimaryKey: | ResourceID; FragmentID; Keyword (Primary key; Unique values) | ||||||||
| ResourceID: | ResourceID (Duplicates OK) | ||||||||
| Relation type: | Attributes involved | ||||||||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceKeyword.ResourceID; ResourceDescription.FragmentID « ResourceKeyword.FragmentID | ||||||||
Defines organism names, features or characteristics of the organism, and topics (nomenclature, description, distribution, etc.) covered.
| Name | Type | Description / Default value & validation | Rqrd./Index | ||||||
|---|---|---|---|---|---|---|---|---|---|
| ResourceID | Long | ID of external resource to which the taxon applies (foreign key). | R | I | |||||
| FragmentID | Long | ID of fragment ('0' for entire resource) to which the taxon applies (foreign key). Default value: 0, validation message: You must use a positive number to identify a resource fragment. |
R | - | |||||
| RecordID | GUID | 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. Default value: GenGUID() |
R | I (P) | |||||
| TaxonomicName | Text | Scientific name of taxon (if possible include authors). Any name can be entered, regardless of whether it is present in taxonomy or not. | - | I | |||||
| Examples values (any other values may be added): |
|
||||||||
| VernacularName | Text | Non-scientific name of organism (e.g. 'white fir') or non-taxonomic name ('conifer', 'hardwood'). | - | I | |||||
| NomID | Long | Unique ID code of the taxon. Refers to the NomID code of TaxonomyName (= foreign key) in the database DiversityTaxonomy. | - | I | |||||
| IdentificationQualifier | Text | Qualification of the identification e.g. 'cf.', 'aff.', 'sp. nov.'. | - | - | |||||
| IdentificationResponsible | Text | 'ORIGINAL' = according to original description (e.g. publication), else name of person responsible for a later identification. Default value: ='Original' |
- | - | |||||
| FeatureList | Memo | Semicolon-separated list of features of the taxon, e.g. 'ascomata; asci; ascospores; germination'. | - | - | |||||
| _TopicNomenclature | Long | 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. Default value: 0 |
- | - | |||||
| _TopicDescription | Long | 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. Default value: 0 |
- | - | |||||
| _TopicGeography | Long | Default value: 0 | - | - | |||||
| _TopicPhylogeny | Long | Default value: 0 | - | - | |||||
| _IDQuality | Text | assessment of identification quality? | - | - | |||||
| _IDQualityResponsible | Text | - | - | ||||||
| [LogUpdatedBy] | Long | The user who created/updated this record the last time. | - | - | |||||
| [LogUpdatedWhen] | Date/Time | The date and time when this record was last updated. Default value: Now() |
- | - | |||||
| Table validation rule: | Not (IsNull([TaxonomicName]) And IsNull([VernacularName])) | ||||||||
| Index name: | Attributes & index properties | ||||||||
| NomID: | NomID (Duplicates OK) | ||||||||
| PrimaryKey: | RecordID (Primary key; Unique values) | ||||||||
| ResourceID: | ResourceID (Duplicates OK) | ||||||||
| TaxonomicName: | TaxonomicName (Duplicates OK) | ||||||||
| VernacularName: | VernacularName (Duplicates OK) | ||||||||
| Relation type: | Attributes involved | ||||||||
| Updates & deletions cascade | ResourceDescription.ResourceID « ResourceTaxon.ResourceID; ResourceDescription.FragmentID « ResourceTaxon.FragmentID | ||||||||
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.
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ResourceID | Long | ID of external resource to which this association applies (foreign key and part of primary key). | R | I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| ResourceCollectionID | Long | Refers to a resource collection (foreign key and part of primary key). | R | I/I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| ProviderOrder | Long | Refers to one of possible several resource providers within a resource collection (foreign key and part of primary key). | R | I/I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| QualityLevel | Long | A quality level for this resource class resources, as defined in RscQualityLevel_Enum (foreign key and part of primary key). | R | I/I(PM) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| URI_ManualOverride | Text | If this attribute is filled with a complete URI, it is directly used, ignoring URI_Part1 to URI_Part4. | - | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| URI_Cache | Text | 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 | Byte+ | (calculated value; = Min(Class.OnlineAvailability, ItemOnlineAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) > Instance creation date OR Not EditorialControl)). Default value: 0; Validation rule: In (0,3,6,9), validation message: The availability scope must come from the list of predefined values. |
R | - | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
| RequestAvailabilityCache | Byte+ | (calculated value; = Min(Class.RequestAvailability, ItemRequestAvailability) AND current date > Collection.ReleaseDate AND (Collection.EditorialReleaseWhen (date) &g | ||||||||||||||||||||||||||||||||||||||||||||||||||||