Database – Customer Document Entity (customer_document_entity)
This holds information concerning documents that are attached to a customer.
|
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 |