levermkt - Laravel Schema Designer

DealDescription

id increments
timestamps timestamps
risks_and_mitigants_id ^FK integer
deal_preference_id ^FK integer
sponsorship_id ^FK integer
number_of_assets integer

SponsorshipInformation

id increments
deal_id ^FK integer
group_name string (255)
net_worth_of_sponsorship integer
total_management_experience integer
timestamps timestamps

AssetList

id increments
timestamps timestamps
project_id ^FK integer
asset_valuation_id ^FK integer
financing_request ^FK integer

AssetValuation

id increments
valuation_type string (255)
name_of_appraisal_firm string (255)
valuation_basis integer
valuation_effective_date string (255)
final_fair_market_value integer
stabilized_noi integer
overall_cap_rate integer
comments string (255)
timestamps timestamps

FinancingRequest

id increments
asset_id ^FK integer
loan_id ^FK integer
timestamps timestamps

LoanInformation

id increments
loan_type string (255)
loan_amount_requested integer
minimum_term_length integer
maximum_term_length integer
minimum_amortization_length integer
preferred_amortization_length integer
interest_only_option string
moratorium_period_required string (255)
funding_date string (255)
key_features string (255)
timestamps timestamps

RiskAndMitigants

id increments
deal_id ^FK integer
risks string (255)
mitigants string (255)
timestamps timestamps

DealPreference

id increments
deal_id ^FK integer
timestamps timestamps
excluded_lenders string (255)
non_disclosure_agreement string (255)
bid_date string (255)
bid_time string (255)

BorrowerAndGuarantorSponsorshipList

id increments
timestamps timestamps
guarantor_id ^FK integer
borrower_id ^FK integer
sponsorship_id ^FK integer
loan_id ^FK integer

BorrowerInformation

id increments
timestamps timestamps
borrower_name string (255)
total_net_worth integer
management_experience integer

GuarantorInformation

id increments
timestamps timestamps
guarantor_name string (255)
total_net_worth integer
recourse_percentage integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01