document_revisions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
change_log VARCHAR 255 null
document_id VARCHAR 36 null
documents.id Defined in XMLR
doc_id VARCHAR 100 null
doc_type VARCHAR 100 null
doc_url VARCHAR 255 null
date_entered DATETIME 26 null
created_by CHAR 36 null
users.id Defined in XMLR
filename VARCHAR 255 null
file_ext VARCHAR 100 null
file_mime_type VARCHAR 100 null
revision VARCHAR 100 null
deleted BIT 1 0
date_modified DATETIME 26 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
documentrevision_mimetype Performance Asc file_mime_type

Relationships