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