Database – Source Company Document (source_company_document_entity)

Description

This table holds the values for Source Company Documents.

Table Fields

Column

Data Type

Column Info

Value Notes

id

int(11)

The ID of the cash drawer.

source_company_id

int(11)

The ID for the source company

section_id

int(11)

The ID for the document's section

user_id

int(11)

The ID for the agent user who created the document

user_name

varchar(255)

The username of the agent user who created the document

remote_addr

char(20)

The IP address for the agent user who created the document

file_name

varchar(255)

The name of the file

description

text

The description of the file

size

int(11)

The size of the document

file_attachment_id

int(11)

The ID for the attached file

archived

tinyint(1)

Whether the document has been archived

1 - archived;

0 - not archived

active

tinyint(1)

Whether the document is active

1 - active;

0 - not active

deleted

tinyint(1)

Whether the document has been deleted

1 - deleted;

0 - not deleted

created

timestamp

When the document was created

last_updated

timestamp

When the document was last updated


How did we do?


Powered by HelpDocs (opens in a new tab)