account
name subdomain hostname
name:string subdomain:string created_at:datetime updated_at:datetime logo:string theme_id:integer background_image:string company_url:string about_us:text tax_id_number:string jurisdiction:string executive_name:string favicon:string hostname:string footer_logo:string status:string education_url:string marketing_title:string marketing_subtitle:string is_private:boolean import_file:string entity_type:string screen_investors:boolean how_to_invest:boolean type_of_investment_return:integer level_1_permissions:jsonb marketing_skin:string workflow_creator_id:integer workflow_distributor_id:integer account_mailchimp_list_id:string external_investor_id_source:string general_ledger_id_source:string preferences:jsonb audit_account_id:integer
accreditation
status external_service exernal_key firstname lastname
investor_profile_id:integer organization_id:integer status:string external_service:string external_key:string firstname:string lastname:string verified_at:date legal:string disclaimer:string details:hstore created_at:datetime updated_at:datetime private_link:string public_link:string note:text
admin_profile
account_id csr firstname middlename lastname
account_id:integer csr:boolean created_at:datetime updated_at:datetime level_1_permissions:jsonb audit_user_id:integer firstname:string middlename:string lastname:string suffix:string
api_service
capital_structure
name account_id organization_id
raze
name has_tile raze_type goal_amount_cents shares start_date end_date status
capital_structure_id:integer name:string has_tile:boolean raze_type:string goal_amount_cents:integer shares:integer start_date:date end_date:date content_title_one:string content_title_two:string content_title_three:string content_body_one:text content_body_two:text content_body_three:text custom_tile_status_text:string payment_type:string min_payment_cents:integer fixed_payment_cents:integer created_at:datetime updated_at:datetime media_type:string published_flag:boolean estimated_rate_of_return:decimal investment_type:string status:string opened_at:datetime distribution_frequency:string investment_term:integer estimated_close_date:datetime funded_text:string estimated_cash_on_cash_return:float payment_increment:float actual_rate_of_return:decimal actual_cash_on_cash_return:float liquidated_date:datetime effective_return:decimal display_status:string display_on_ims:boolean escrow_service_provider:string accreditation_service_provider:string is_private:boolean sponsor_funds_html:jsonb years_in_business:integer avg_return:integer equity_raised:integer investment_closed:integer investment_capitalized:integer region:string asset_mgmt_fee:string asset_hold_period:string tile_text:text preferred_return:decimal override_funded_text:boolean workflow_creator_id:integer workflow_distributor_id:integer show_fund_page:boolean mailchimp_mailing_list_id:string show_demographic_income_info:boolean show_tile_closing_date:boolean show_tile_equity:boolean display_map_on_show_page:boolean display_property_details_on_show_page:boolean deleted_at:datetime audit_campaign_id:integer