Database – Investor Information (investor_entity)
Deprecated!
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
custom_id | varchar(255) | Custom investor id | ||
customer_type | char(100) | Investor type | customer.type.* | |
status | varchar(255) | Status code of the entity | ||
first_name | varchar(50) | investor first name | ||
last_name | varchar(50) | investor last name | ||
middle_name | varchar(50) | investor middle name | ||
birth_date | varbinary(255) | investor birthdate | ||
gender | char(100) | investor gender | customer.gender.* | |
generation_code | char(100) | investor generation code | customer.generationCode.* | |
varchar(255) | investor email | |||
ssn | varbinary(255) | investor ssn | ||
driver_license | varchar(50) | investor driver license | ||
company_name | varchar(255) | Company name of investor. | ||
contact_name | varchar(255) | investor contact name | ||
customer_id_type | char(100) | investor id type | customer.idType.* | |
customer_id | varbinary(255) | ID for the customer | ||
credit_limit | decimal(10,2) | investor credit limit | ||
access_username | varchar(255) | investor website access username | ||
access_password | varchar(255) | investor website access password | ||
primary_address_id | int(11) | investor primary address id | ||
mail_address_id | int(11) | investor mail address id | ||
has_avatar | tinyint(4) | whether or not has an avatar | 1 - yes, 0 - no | |
ofac_match | tinyint(4) | Whether or not match OFAC records | 1 - yes, 0 - no | |
ofac_tested | tinyint(4) | Whether or not was OFAC tested | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(4) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |