Table: Investment Document Entity

Table: Investment Document Entity

Holds document information for investment entities.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
investment_idint(11)Associated investment id
user_idint(11)ID of the associated agent user
user_namevarchar(255)Created user name
remote_addrchar(20)IP address of the client machine
section_idint(11)ID of the associated section for the entity
file_attachment_idint(11)File attachment id
filenamevarchar(500)file name
descriptiontextThe description of the entity instance
ipint(11)IP Address
sizeint(11)Size of the generated file
archivedtinyint(1)Whether or not the entity is archived1 - yes, 0 - no
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List