By G. Hagedorn, 2003
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:
(You can click on the entities to go to the attribute tables.)
Two separate tables are intended to be used to allow "presentations" i.e. collection-views that can select and present material from several resource collections. Whereas the standard resource collection is optimized for management purposes (one team of managers, usually all resources are located at on the same server, usually the same or similar copyright situation), the presentation is optimized for consumption. Presentations have not yet been tested and the model presented here may well be inadequate!
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). 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: True |
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; Validation rule: [IconHeight]>=0 [IconHeight]<150 |
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 no more than 1 year in the future. You can extend the release block at any time during that period. |
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 « ResourceCollectionManager.ResourceCollectionID | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceProvider.ResourceCollectionID | |||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceQualityClass.ResourceCollectionID | |||
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) |
| ManagingUserID | Long | ID of user who may manages 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 « ResourceCollectionManager.ResourceCollectionID | |||
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/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: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 availability 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) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ResourceQualityClassResourc...: | ResourceCollectionID (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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
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) | |||||||||||||||||||||||||||
| 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'. |
- | - | |||||||||||||||||||||||||||
| 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. |
- | - | |||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| Deletions cascade | ResourceProvider.ResourceCollectionID « ResourceInstance.ResourceCollectionID; ResourceProvider.ProviderOrder « ResourceInstance.ProviderOrder | ||||||||||||||||||||||||||||||
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. validation message: A resource ID must be a positive number. |
R | I (P) | ||||||||||||||||||||||||||||||||||||||||
| ResourceCollectionID | Long | Each resource belongs to a single resource collection (foreign key). The res. collection supplies general information not present in each item. | R | I | ||||||||||||||||||||||||||||||||||||||||
| 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) & '%'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | I | ||||||||||||||||||||||||||||||||||||||||
| ItemOnlineAvailability | Byte+ | Online availability scope (managers, login, intranet, internet) of resource instances of this abstract item (also restricted by OnlineAvailability of resource class!). 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: |
|
|||||||||||||||||||||||||||||||||||||||||||
| ItemRequestAvailability | 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 RequestAvailability of resource class!). 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: |
|
|||||||||||||||||||||||||||||||||||||||||||
| 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) & '%'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - | ||||||||||||||||||||||||||||||||||||||||
| UpdateStatus | Byte+ | 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. Default value: 0 |
R | - | ||||||||||||||||||||||||||||||||||||||||
| Values currently restricted to: |
|
|||||||||||||||||||||||||||||||||||||||||||
| SourceReferenceID | Text | For resources from published sources: the reference ID as defined in a bibliographic reference manager like DiversityReferences (RefID, foreign key). Compare also ResourceCollection.SourceReferenceID! | - | - | ||||||||||||||||||||||||||||||||||||||||
| SourceRefDescriptionCache | Text | A readable description (author, year, etc.) corresponding to SourceReferenceID, automatically updated from the reference management subsystem. | - | - | ||||||||||||||||||||||||||||||||||||||||
| SourceDetail | Text | Information how to locate original information in source, esp. page numbers. Do not add 'page' or 'p.' for page numbers (incl. roman numbers) – Specimen/culture collections: accession number or storage location code. Validation rule: Is Null Or Not (ALike ' %' Or ALike '% ' Or ALike '% %' Or ALike '%' & Chr(10) & '%' Or ALike '%' & Chr(13) & '%'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - | ||||||||||||||||||||||||||||||||||||||||
| 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) & '%'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - | ||||||||||||||||||||||||||||||||||||||||
| RatingCountCache | Long | The number of times this item was rated. Default value: 0 |
R | - | ||||||||||||||||||||||||||||||||||||||||
| RatingAverageCache | Single | The average rating score as obtained by averaging all values in ResourceAbstractItem_Rating for this abstract item. Default value: 0 |
R | I | ||||||||||||||||||||||||||||||||||||||||
| _ParentResourceID | Long | 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**] | - | I (N) | ||||||||||||||||||||||||||||||||||||||||
| IsTemplate | Boolean | Defines a template for new abstract items. Default is false, should be true only a single time within each collection. A template may already include dependent records for descriptions, taxa, and keywords. 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. 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: | [ItemRequestAvailability]>=[ItemOnlineAvailability] | |||||||||||||||||||||||||||||||||||||||||||
| Table validation text: | The item availability scope may not be smaller in 'On Request' (ItemRequestAvailability) than in 'Online' (ItemOnlineAvailability). | |||||||||||||||||||||||||||||||||||||||||||
| Index name: | Attributes & index properties | |||||||||||||||||||||||||||||||||||||||||||
| ParentResourceID: | _ParentResourceID (Duplicates OK; Ignore Nulls) | |||||||||||||||||||||||||||||||||||||||||||
| RatingAverageCache: | RatingAverageCache (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||||||
| ResourceCollectionID: | ResourceCollectionID (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||||||
| ResourceID: | ResourceID (Primary key; Unique values) | |||||||||||||||||||||||||||||||||||||||||||
| URI_Part3: | URI_Part3 (Duplicates OK) | |||||||||||||||||||||||||||||||||||||||||||
| Relation type: | Attributes involved | |||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceAbstractItem.ResourceID « ResourceAbstractItem_Rating.ResourceID | |||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceAbstractItem.ResourceID « ResourceDescription.ResourceID | |||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceAbstractItem.ResourceID « ResourceInstance.ResourceID | |||||||||||||||||||||||||||||||||||||||||||
| Updates & deletions cascade | ResourceCollection.ResourceCollectionID « ResourceAbstractItem.ResourceCollectionID | |||||||||||||||||||||||||||||||||||||||||||
Individual rating scores of abstract item (relating to content, not presentation quality!).
| 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. validation message: A resource ID must be a positive number. |
R | - |
| EntryDate | Date/Time | Time when the rating was entered. Default value: Now() |
R | - |
| Rating | Long | A numerical rating value. Default value: 0 |
R | - |
| RatingComment | Text | An optional comment associated with a rating. | - | - |
| RatingID | Autonum | Internal unique primary key number. | R | I (P) |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RatingID (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ResourceAbstractItem.ResourceID « ResourceAbstractItem_Rating.ResourceID | |||
Description of an entire resource (or an optional resource fragment). The entity combines the description and the resource fragment definition, which could also be modeled in a 1:1 relationship.
| 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 | 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 resource title or description meta data under DescriptionTranslation. 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 « ResourceDescriptionTranslation.ResourceID; ResourceDescription.FragmentID « ResourceDescriptionTranslation.FragmentID | |||
| Simple relation (no integrity) | 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, translatable elements associated with a resource item. The web interface supports any language for which the language or audience specific elements have been defined for the requested resource items.
| 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. | - | - |
| DisplayOrderOverride | Text | Normally the attribute is empty and resources are sorted by title. If filled, used to sort resources in a presentation. Example: 'The Area of New York' shall be sorted under 'New York''. Numbers are sorted as text, i.e. '10'<'9', use '09', '10'! | - | - |
| DisplayOrderCache | Text | Computed field, set to DisplayOrderOverride if present, otherwise to Title. The cache is 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 « ResourceDescriptionTranslation.ResourceID; ResourceDescription.FragmentID « ResourceDescriptionTranslation.FragmentID | |||
| Simple relation (no integrity) | ResourceDescriptionTranslation.ResourceID « ResourceTaxon.ResourceID; ResourceDescriptionTranslation.FragmentID « ResourceTaxon.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) |
| [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 | Autonum | 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. | 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 |
| 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' |
R | - |
| FeatureList | Memo | Semicolon-separated list of features of the taxon, e.g. 'ascomata; asci; ascospores; germination'. | - | - |
| _TopicNomenclature | Long | *** All fields starting with underscore are present only as a reminder, not yet decided upon! Default value: 0 |
- | - |
| _TopicDescription | Long | 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. Default value: 0 |
- | - |
| _TopicGeography | Long | 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. Default value: 0 |
- | - |
| _TopicPhylogeny | Long | 0 = not covered (or negligible), 1 = partly covered, 2 = primary topic of resource. Default value: 0 |
- | - |
| _IDQuality | Text | *** assessment of identification quality? | - | - |
| _IDQualityResponsible | Text | *** person responsible for setting IDQuality? | - | - |
| [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 ([TaxonomicName] Is Null And [VernacularName] Is Null) | |||
| 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 | |||
| Simple relation (no integrity) | ResourceDescriptionTranslation.ResourceID « ResourceTaxon.ResourceID; ResourceDescriptionTranslation.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 | |
|---|---|---|---|---|