Page Comparison

Integer

Column	Type	References	Comments
id	Integer		Primary key
vdb_id	Integer
guid	String
name	String		Name of the document
description	String		Description
created	Date		Date this document was created
creator_id	Integer	db_person.id	ID of the owner
url	String		The actual URL
kind	Integer		URL or Document
path	String		Path of this document (folder IDs separated by /)
content_type	String		Mime type of this document
last_checkin	Date		Date the last version of this document was checked in
n_co	Integer		Number of open checkouts
head_release	Integer		Current release number of this document
head_revision	Integer		Current revision number of this document
head_file_id	Integer	db_fs_file.id	ID corresponding to the head revision
head_size	Float		Size of the latest revision
sz	Float		Sum of sizes of all its revisions
provider	String		One of celoxis\|google\|dropbox
provider_data	String		JSON encoded data from the provider
folder_id	Integer	db_folder.id	ID of this document's folder
project_id	Integer	db_project.id
task_id	Integer	db_task.id
task_update_id	Integer	db_task_update.id
process_id	Integer	db_process.id
process_update_id	Integer	db_process_update.id
message_id	Integer	db_message.id
expense_item_id	Integer	db_expense_item.id
custom_field_def_id	Integer	db_custom_field_def.id

Versions Compared