Database – Source Company Document (source_company_document_entity)
Updated 1 year ago
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 |