1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Jump to navigation
Jump to search
Content Manager OnDemand Database Tables (view source)
Revision as of 18:31, 1 June 2016
, 18:31, 1 June 2016Updated the Content Manager OnDemand Document Annotation table.
m (Addition of arsann table) |
(Updated the Content Manager OnDemand Document Annotation table.) |
||
| Line 203: | Line 203: | ||
!Value!!Sample Value||Type!!Description | !Value!!Sample Value||Type!!Description | ||
|- | |- | ||
|ID | |ID||?||Integer||Annotation ID Number | ||
|- | |- | ||
|USERID | |USERID||ADMIN, USER||String||The User ID that created the annotation. | ||
|- | |- | ||
|AGID | |AGID||5229, 5918||Integer||The unique Application Group Identifer that the Annotation belongs to. | ||
|- | |- | ||
|DOC_NAME | |DOC_NAME||123FAAA||String||The name of the object the annotated document is stored in. | ||
|- | |- | ||
|DOC_OFF | |DOC_OFF||0,83852||Integer||The offset from the beginning of the object, in bytes, that the annotated document begins at. | ||
|- | |- | ||
|DOC_LEN | |DOC_LEN||38582,1894||Integer||The length of the document, in bytes, for the annotated object. | ||
|- | |- | ||
|COMP_OFF | |COMP_OFF||478295, 915753||Integer||The offset from the beginning of the compressed object, in bytes, that the annotated document begins at. | ||
|- | |- | ||
|COMP_LEN | |COMP_LEN||35638,2682||Integer||The length of the compressed document, in bytes, for the annotated object. | ||
|- | |- | ||
|TIME_STAMP | |TIME_STAMP||Deprecated||Integer||In versions prior to CMOD v9.0, the timestamp when the annotation was created. | ||
|- | |- | ||
|PAGE | |PAGE||1,2,50,80000||Integer||The page number that the Annotation should appear upon. | ||
|- | |- | ||
|TYPE | |TYPE||?||Integer||Describes the type of annotation. | ||
|- | |- | ||
|X_OFF | |X_OFF||?||Integer||The X offset of the annotation. | ||
|- | |- | ||
|Y_OFF | |Y_OFF||?||Integer||The Y offset of the annotation. | ||
|- | |- | ||
|RESERVED | |RESERVED||?||VarChar||Reserved for future use. | ||
|- | |- | ||
|TEXT_BUF | |TEXT_BUF||?||LongVarChar||The text of the annotation, up to 32 kilobytes in size. | ||
|- | |- | ||
|IMAGE_BUF | |IMAGE_BUF||?||Binary Object||An image annotation up to 1 megabyte in size. | ||
|- | |- | ||
|TABLE_NAME | |TABLE_NAME||ABC1, DEF2||String||The name of the table that the annotated document is located in. | ||
|- | |- | ||
|DOC_EXP_DATE | |DOC_EXP_DATE||Deprecated||Integer||In versions prior to CMOD v9.0, the date when the document (and by extension, the annotation) was due to expire. | ||
|- | |- | ||
|DOC_EXP_DT | |DOC_EXP_DT||2019-05-15 00:00:00.000000||Integer||In versions after CMOD v9.0, the date when the document (and by extension, the annotation) was due to expire, in the database's native timestamp format. | ||
|- | |- | ||
|TIME_STAMP_DT | |TIME_STAMP_DT||2019-05-15 00:00:00.000000||Integer||In versions after CMOD v9.0, the date when the annotation was created, stored in the database's native timestamp format. | ||
|} | |} | ||