Database – Customer Document Entity (customer_document_entity)
Description
This holds information concerning documents that are attached to a customer. For information on how to upload, update, or create documents in the API, see API - Documents.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
customer_id | int(11) | ID for the customer | ||
section_id | int(11) | ID of the associated section for the entity | ||
user_id | int(11) | ID of the associated agent user | ||
user_name | varchar(255) | Username of user that uploaded it | ||
remote_addr | char(20) | IP address of the client machine | ||
file_name | varchar(255) | Name of the file being imported | ||
description | text | The description of the entity instance | ||
size | int(11) | Size of the generated file | ||
file_attachment_id | int(11) | File attachment id | ||
archived | tinyint(1) | Whether or not the entity is archived | 1 - yes, 0 - no | |
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |