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


How did we do?


Powered by HelpDocs (opens in a new tab)