Database – Investment Document Entity (investment_document_entity)
Holds document information for investment entities.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
investment_id | int(11) | Associated investment id | ||
user_id | int(11) | ID of the associated agent user | ||
user_name | varchar(255) | Created user name | ||
remote_addr | char(20) | IP address of the client machine | ||
section_id | int(11) | ID of the associated section for the entity | ||
file_attachment_id | int(11) | File attachment id | ||
filename | varchar(500) | file name | ||
description | text | The description of the entity instance | ||
ip | int(11) | IP Address | ||
size | int(11) | Size of the generated file | ||
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 |