IMC-Datenmodell v1
Kern-Tabellen, Namenskonventionen und geplante v2-Module.
Kanon
DDL-Referenz: projects/rest_data_platform/reference/imc/IMC_Schema_v1.sql
Migration im App-Repo: apps/web/supabase/migrations/20260327120000_imc_astra_v1.sql
v1 (deployed lokal)
22 Tabellen + 3 Views, u. a.:
imc_wind_farms,imc_farm_design,imc_farm_milestonesimc_ports,imc_vessels,imc_data_sources- Views:
imc_v_farm_overview,imc_v_vessels_anylogic,imc_v_capex_breakdown
Multi-Tenant: imc_wind_farms.account_id → Team-Account.
v2 (geplant)
Nach DPP-Feldliste / Workshop:
- BOM/LCA, ERA5/Metocean, Decom-Sequenz, DPP/AAS-Export-Tabellen