STORE

VARCHAR2(256)

Name of store

MOUNT

VARCHAR2(256)

Location at which instance of store is mounted

PATHNAME

VARCHAR2(1024)

Name of path to item

PATHTYPE

VARCHAR2(32)

Type of path item (see DBMS_DBFS_CONTENT Constants – Path Name Types)

FILEDATA

BLOB

BLOB locator that can be used to access data in the path item

STD_ACCESS_TIME

TIMESTAMP(6)

Time of last access of a path name’s contents

STD_ACL

VARCHAR2(1024)

Access Control List (in standard ACL syntax)

STD_CHANGE_TIME

TIMESTAMP(6)

Time of last change to the path name

STD_CHILDREN

NUMBER

Number of child directories/folders a directory/folder path has (this property should be available in providers that support the FEATURE_FOLDERS feature)

STD_CONTENT_TYPE

VARCHAR2(1024)

One or more client-supplied mime-types (in standard RFC syntax) describing the path name which is typically of TYPE_FILE. The content type is not necessarily interpreted by the store.

STD_CREATION_TIME

TIMESTAMP(6)

Time at which the item was created. Once set, this value remains the same for the lifetime of the path name.

STD_DELETED

NUMBER

Set to a nonzero number if the path name has been soft-deleted but not yet purged (see DBMS_DBFS_CONTENT Constants – Store Features)

STD_GUID

NUMBER

Store-specific unique identifier for a path name. Clients must not depend on the GUID being unique across different stores, but a given (store-name, store-specific-path name) has a stable and unique GUID for its lifetime.

STD_MODIFICATION_TIME

TIMESTAMP(6)

Time of last change to the data associated with a path name. Changes to the content of a TYPE_FILE or TYPE_REFERENCE path, the referent of the TYPE_LINK path, and addition or deletion of immediate children in a TYPE_DIRECTORY path, all constitute data changes.

STD_OWNER

VARCHAR2(32)

Client-supplied (or implicit) owner name for the path name

STD_PARENT_GUID

NUMBER

Store-specific unique identifier for the parent of a path name. Clients must not depend on the GUID being unique across different stores, but a given (store-name, store-specific-path name) has a stable and unique GUID for its lifetime.

The GUID of the parent of this path name (that is that std_parent_guid(pathname) == std_guid(parent(pathname))).

STD_REFERENT

VARCHAR2(1024)

Content of the symbolic link of a TYPE_LINK path, otherwise NULL. The STD_REFERENT can be an arbitrary string and must not necessarily be interpreted as path name by clients (or such interpretation should be done with great care).

OPT_HASH_TYPE

VARCHAR2(32)

Type of hash provided in the OPT_HASH_VALUE property (see DBMS_CRYPTO for possible options)

OPT_HASH_VALUE

VARCHAR2(128)

Hash value of type OPT_HASH_TYPE describing the content of the path name

OPT_LOCK_COUNT

NUMBER

Number of compatible locks placed on a path name. If different principals are allowed to place compatible (read) locks on a path, the OPT_LOCKER must specify all lockers with repeats so that lock counts can be correctly maintained.

OPT_LOCK_DATA

VARCHAR2(128)

Client-supplied user-data associated with a user-lock, uninterpreted by the store

OPT_LOCKER

VARCHAR2(128)

One or more implicit or client-specified principals that applied a user-lock on a path name

OPT_LOCK_STATUS

NUMBER

One of the (LOCK_READ_ONLY, LOCK_WRITE_ONLY, LOCK_READ_WRITE) values describing the type of lock currently applied on a path name

OPT_VERSION

NUMBER

Sequence number for linear versioning of a path name

OPT_VERSION_PATH

VARCHAR2(1024)

Version path name for hierarchical versioning of a path name

OPT_CONTENT_ID

RAW(128)

A provider-generated store-specific unique contentID in the form of a string for a file element (that may optionally not be associated with a path (see FEATURE_CONTENT_ID and FEATURE_LAZY_PATH in DBMS_DBFS_CONTENT Constants – Store Features)