|
id
|
char(36)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
document_name
|
varchar(255)
|
|
|
|
|
doc_id
|
varchar(100)
|
|
|
|
|
doc_type
|
varchar(100)
|
|
|
Sugar
|
|
doc_url
|
varchar(255)
|
|
|
|
|
active_date
|
date
|
|
|
|
|
exp_date
|
date
|
|
|
|
|
category_id
|
varchar(100)
|
|
|
|
|
subcategory_id
|
varchar(100)
|
|
|
|
|
status_id
|
varchar(100)
|
|
|
|
|
document_revision_id
|
varchar(36)
|
|
|
|
|
related_doc_id
|
char(36)
|
|
|
|
|
related_doc_rev_id
|
char(36)
|
|
|
|
|
is_template
|
tinyint(1)
|
|
|
0
|
|
template_type
|
varchar(100)
|
|
|
|