1.0

Appendix A Table Descriptions
34 AVID CONFIDENTIAL DRAFT VERSION 5/24/06
wg_objects
Each row is a Workgroup Object.
Column Name Type Description
bdh bigint The canonical object
identifier.
bih bigint The low level ID of the
object (often called the
BIH)
parent_bdh bigint The BDH of the parent
object.
name ntext The object name.
mimetype_bdh bigint The BDH of the mime
type for this object. If
there is no mime type
object associated this
field will be NULL.
flags bigint Low-level object flags
(undefined).
isfolder tinyint True if the object is a
folder.
ischeckedout tinyint True if the object is
checked out.
issystem issystem True if the object is a
Workgroup System
object.
smot datetime Server File Modification
Time
simt datetime Server File Import Time
scit datetime Server Check In Time
scrt datetime Server File Creation Time