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


How did we do?


Powered by HelpDocs (opens in a new tab)