CALM
Logical data modelOverview
SVG ↓ Physical model →
address # * * * * * id street house_number postal_code city country uuid Variable characters (255) Variable characters (20) Variable characters (20) Variable characters (255) Variable characters (2) related_party # * o o o o o o o gcid name business_line location wwid client_owner onboard_location portfolio_code address_id Long integer Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) uuid asset # * * * o o o * * o o o id asset_type asset_category name created_at description damage_insurance documentation_id documentation_id_available documentation_system currency valuation_method uuid Variable characters (31) Variable characters (20) Variable characters (255) TS6 Variable characters (2000) Variable characters (3) Variable characters (255) Variable characters (3) Variable characters (20) Variable characters (3) Variable characters (50) ufcp_asset # * * o * o * * o o id ufcp_type type_of_provider provider_description under_asset_protection_scheme asset_protection_scheme_name materiality_threshold gcid valuation_percentage provider_rrr uuid Variable characters (30) Variable characters (20) Variable characters (2000) Boolean Variable characters (255) Float Long integer Float Variable characters (255) real_estate_asset # * * * * o * * * * * * * * * * * * * * * * * * * * * * * * id real_estate_sub_type country_code ownership_type real_estate_year_of_construction year_of_renovation renovation location_description real_estate_state_of_completion real_estate_class ensurance_finished significantly_pre_sold_preleased location_type original_valuation_method current_valuation_method owner_occupier unit_of_measurement size commercial_floor_area residential_floor_area floodzone improved_real_estate property_specific_impact property_specific_impact_date junior_lien_proper_sales_process number_of_units obligor_primary_residence none_cread_financing material_dependant_credit_quality material_income uuid Variable characters (255) Variable characters (2) Variable characters (255) Integer Integer Variable characters (255) Variable characters (2000) Variable characters (255) Variable characters (255) Boolean Boolean Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Float Float Float Boolean Boolean Boolean Date Boolean Integer Boolean Boolean Boolean Boolean real_estate_location # # o o * * o * * o * asset_id item_index zipcode house_nr city country_code energy_label cadastral_id cadastral_service vbo_id date_of_issuance uuid Integer Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (2) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Date real_estate_revenue_contract # # * * * * * * asset_id item_index tenant_type rental_income remain_term_contract rental_contract_start_date rental_contract_end_date long_term_vacancy_indicator uuid Integer Variable characters (255) Float Variable characters (255) Date Date Boolean real_estate_agriculture_asset # * * * o * o o o o o o o o o o o id agri_type land_in_production type_of_production well_situated_water_rights land_use_restrictions contamination_of_land water_rights_size ground_lease_tenor ground_lease_maturity ground_lease_renewal ground_lease_currency ground_lease_annual_payment ground_lease_indexation type_of_building sufficient_access water_rate_measure uuid Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Float Variable characters (255) Date Date Variable characters (3) Float Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) real_estate_commercial_asset # * * * * * * * * * * * id expected_resource_costs qualification_property lettability liquidation_value marketability qualify_location maintenance_state rental_value operational_costs vacant_rental_value rental_start_date uuid Float Variable characters (255) Variable characters (255) Float Variable characters (255) Variable characters (255) Variable characters (255) Float Float Float Date real_estate_mortgage # # * * * * * asset_id item_index mortgage_type rank_of_security amount our_share registration_number uuid Integer Variable characters (255) Integer Float Float Variable characters (255) aircraft_asset # o * * * * * * id revenue_contract_remaining_term engine_manufacturer type_of_engine number_of_engines state_of_completion year_of_construction type_of_aircraft uuid Float Variable characters (255) Variable characters (255) Integer Variable characters (255) Date Variable characters (255) commodity_asset # * * o * o * o * o * o o id commodity_type storage_place storage_place_description storage_agreement storage_agreement_description monitoring_type monitoring_comments hedged hedged_description exchange_traded exchange_name isin_code uuid Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (2000) Variable characters (255) Variable characters (2000) Variable characters (255) Variable characters (255) Variable characters (255) commodity_evaluation # # * o commodity_id date_of_evaluation quality_evaluation comments uuid Date Variable characters (255) Variable characters (2000) equipment_asset # * * id equipment_type equipment_valuation uuid Variable characters (255) Variable characters (255) equipment_evaluation # # * o equipment_id date_of_evaluation quality_evaluation comments uuid Date Variable characters (255) Variable characters (2000) intangible_asset # * id intangible_type uuid Variable characters (255) receivables_asset # * id receivables_type uuid Variable characters (255) receivables_evaluation # # * o receivables_id date_of_evaluation quality_evaluation comments uuid Date Variable characters (255) Variable characters (2000) ship_asset # o * * * * * * * * * id ship_revenue_contract_remaining_term home_harbour_of_ship unique_maritime_organisation_identifier type_of_off_taker size_in_units_of_measure measure_used_for_ship_use ship_state_of_completion primary_use_of_ship unique_name_of_vessel ship_year_of_construction uuid Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Float Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Integer project_asset # * * * * * * * * id project_type technology_type project_revenue_contract_remaining_term sponsor_name start_date project_state_of_completion takers_type gcid_sponsor uuid Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Date Variable characters (255) Variable characters (255) Long integer inventory_asset # * * o * o id inventory_type storage_place storage_place_description storage_agreement storage_agreement_description uuid Variable characters (255) Variable characters (255) Variable characters (2000) Variable characters (255) Variable characters (2000) inventory_evaluation # # * o inventory_id date_of_evaluation quality_evaluation comments uuid Date Variable characters (255) Variable characters (2000) financial_asset # o o o o o o o * id financial_type cash_blocked name_of_bank account_number minimum_balance_percentage equity_listing isin_code shares uuid Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (34) Float Variable characters (255) Variable characters (255) Float financial_valuation # # o * o financial_id date_of_valuations share_value protection_value rabobank_protection_value uuid Date Float Float Float valuation # * * * id asset_id valuation valuation_date uuid uuid Float TS6 asset_owner # # asset_id owner_gcid uuid Long integer customer # * o o o o o o gcid name business_line location wwid client_owner onboard_location portfolio_code Long integer Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) credit_agreement # * o o o o id gcid description agreement_id syndicate our_part Variable characters (255) Long integer Variable characters (2000) Variable characters (255) Boolean Float credit_protection_agreement # * * * * o id credit_agreement_id gcid protection_level syndicate description uuid Variable characters (25 Long integer Variable characters (25 Boolean Variable characters (200 collateral # o * * * * * o o * o * * o o o o o o o o o o o o * o * o id local_collateral_id eligibility_determined eligibility_preliminary_score eligibility_advanced_irb_approach eligibility_foundation_irb_approach eligibility_standardized_approach prior_lien_third_party_claim collateral_inspection_right governing_law_country documentation_id documentation_id_available legal_opinion_available legal_opinion_date monitoring_frequency next_valuation_date valuation_date rank_of_security additional_recourse_available enforceability independent_valuer valuation_method pledge_filed sufficiently_liquid sufficiently_stable shared_collateral our_share asset_id credit_protection_agreement_id uuid Variable characters (255) Boolean Variable characters (255) Variable characters (255) Variable characters (255) Variable characters (255) Number (38,2) Variable characters (255) Variable characters (2) Variable characters (255) Boolean Boolean Date Variable characters (255) Date Date Variable characters (255) Boolean Boolean Boolean Variable characters (255) Boolean Boolean Boolean Boolean Number (5,2) uuid uuid collateral_owned_valuation # # o * o collateral_id date_of_valuations share_value protection_value rabobank_protection_value uuid Date Float Float Float agreement_facility # # * * o agreement_id facility_id allocation product_system lending_limit_only uuid Variable characters (255) Float Variable characters (255) Boolean agreement_contract # # * * agreement_id contract_id allocation product_system uuid Variable characters (255) Float Variable characters (255) agreement_party # # * o agreement_id gcid allocation local_id uuid Long integer Float Variable characters (255)
Stop · of · 1.0×