CALM
Physical data modelOverview
SVG ↓ Logical model →
fk_related_party_address fk_ufcp_asset_asset fk_real_estate_asset_asset fk_real_estate_location fk_real_estate_revenue_contract fk_real_estate_agriculture_asset fk_real_estate_commercial_asset fk_real_estate_mortgage fk_aircraft_asset_asset fk_commodity_asset_asset fk_commodity_evaluation fk_equipment_asset_asset fk_equipment_evaluation fk_intangible_asset_asset fk_receivables_asset_asset fk_receivables_evaluation fk_ship_asset_asset fk_project_asset_asset fk_inventory_asset_asset fk_inventory_evaluation fk_financial_asset_asset fk_financial_valuation fk_valuation_asset fk_asset_owner_asset fk_asset_owner_owner fk_credit_agreement_customer fk_agreement_credit_agreement fk_agreement_customer fk_collateral_asset fk_collateral_agreement fk_collateral_owned_valuation fk_agreement_facility fk_agreement_contract fk_agreement_party address id street house_number postal_code city country uuid varchar(255) varchar(20) varchar(20) varchar(255) varchar(2) <pk> related_party gcid name business_line location wwid client_owner onboard_location portfolio_code address_id bigint varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) uuid <pk> <fk> asset id asset_type asset_category name created_at description damage_insurance documentation_id documentation_id_available documentation_system currency valuation_method uuid varchar(31) varchar(20) varchar(255) timestamp(6) with time zone varchar(2000) varchar(3) varchar(255) varchar(3) varchar(20) varchar(3) varchar(50) <pk> ufcp_asset id ufcp_type type_of_provider provider_description under_asset_protection_scheme asset_protection_scheme_name materiality_threshold gcid valuation_percentage provider_rrr uuid varchar(30) varchar(20) varchar(2000) boolean varchar(255) double precision bigint double precision varchar(255) <pk,fk> real_estate_asset 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 varchar(255) varchar(2) varchar(255) integer integer varchar(255) varchar(2000) varchar(255) varchar(255) boolean boolean varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) double precision double precision double precision boolean boolean boolean date boolean integer boolean boolean boolean boolean <pk,fk> real_estate_location asset_id item_index zipcode house_nr city country_code energy_label cadastral_id cadastral_service vbo_id date_of_issuance uuid integer varchar(255) varchar(255) varchar(255) varchar(2) varchar(255) varchar(255) varchar(255) varchar(255) date <pk,fk> <pk> 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 varchar(255) double precision varchar(255) date date boolean <pk,fk> <pk> real_estate_agriculture_asset 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 varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) double precision varchar(255) date date varchar(3) double precision varchar(255) varchar(255) varchar(255) varchar(255) <pk,fk> 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 double precision varchar(255) varchar(255) double precision varchar(255) varchar(255) varchar(255) double precision double precision double precision date <pk,fk> real_estate_mortgage asset_id item_index mortgage_type rank_of_security amount our_share registration_number uuid integer varchar(255) integer double precision double precision varchar(255) <pk,fk> <pk> aircraft_asset id revenue_contract_remaining_term engine_manufacturer type_of_engine number_of_engines state_of_completion year_of_construction type_of_aircraft uuid double precision varchar(255) varchar(255) integer varchar(255) date varchar(255) <pk,fk> commodity_asset 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 varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(2000) varchar(255) varchar(2000) varchar(255) varchar(255) varchar(255) <pk,fk> commodity_evaluation commodity_id date_of_evaluation quality_evaluation comments uuid date varchar(255) varchar(2000) <pk,fk> <pk> equipment_asset id equipment_type equipment_valuation uuid varchar(255) varchar(255) <pk,fk> equipment_evaluation equipment_id date_of_evaluation quality_evaluation comments uuid date varchar(255) varchar(2000) <pk,fk> <pk> intangible_asset id intangible_type uuid varchar(255) <pk,fk> receivables_asset id receivables_type uuid varchar(255) <pk,fk> receivables_evaluation receivables_id date_of_evaluation quality_evaluation comments uuid date varchar(255) varchar(2000) <pk,fk> <pk> ship_asset 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 varchar(255) varchar(255) varchar(255) varchar(255) double precision varchar(255) varchar(255) varchar(255) varchar(255) integer <pk,fk> 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 varchar(255) varchar(255) varchar(255) varchar(255) date varchar(255) varchar(255) bigint <pk,fk> inventory_asset id inventory_type storage_place storage_place_description storage_agreement storage_agreement_description uuid varchar(255) varchar(255) varchar(2000) varchar(255) varchar(2000) <pk,fk> inventory_evaluation inventory_id date_of_evaluation quality_evaluation comments uuid date varchar(255) varchar(2000) <pk,fk> <pk> financial_asset id financial_type cash_blocked name_of_bank account_number minimum_balance_percentage equity_listing isin_code shares uuid varchar(255) varchar(255) varchar(255) varchar(34) double precision varchar(255) varchar(255) double precision <pk,fk> financial_valuation financial_id date_of_valuations share_value protection_value rabobank_protection_value uuid date double precision double precision double precision <pk,fk> <pk> valuation id asset_id valuation valuation_date uuid uuid double precision timestamp(6) with time zone <pk> <fk> asset_owner asset_id owner_gcid uuid bigint <pk,fk1> <pk,fk2> customer gcid name business_line location wwid client_owner onboard_location portfolio_code bigint varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) varchar(255) <pk> credit_agreement id gcid description agreement_id syndicate our_part varchar(255) bigint varchar(2000) varchar(255) boolean double precision <pk> <fk> credit_protection_agreement id credit_agreement_id gcid protection_level syndicate description uuid varchar(255) bigint varchar(255) boolean varchar(2000) <pk> <ak,fk1> <fk2> collateral 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 varchar(255) boolean varchar(255) varchar(255) varchar(255) varchar(255) numeric(38,2) varchar(255) varchar(2) varchar(255) boolean boolean date varchar(255) date date varchar(255) boolean boolean boolean varchar(255) boolean boolean boolean boolean numeric(5,2) uuid uuid <pk> <fk1> <fk2> collateral_owned_valuation collateral_id date_of_valuations share_value protection_value rabobank_protection_value uuid date double precision double precision double precision <pk,fk> <pk> agreement_facility agreement_id facility_id allocation product_system lending_limit_only uuid varchar(255) double precision varchar(255) boolean <pk,fk> <pk> agreement_contract agreement_id contract_id allocation product_system uuid varchar(255) double precision varchar(255) <pk,fk> <pk> agreement_party agreement_id gcid allocation local_id uuid bigint double precision varchar(255) <pk,fk> <pk>
Stop · of · 1.0×