1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[367],{21168:e=>{e.exports={outercontainer:"Row_outercontainer__eUKwv",outerframe:"Row_outerframe__npjvv",grey:"Row_grey__c_ubA",blue:"Row_blue__IWhxj",adago:"Row_adago__aGjoo"}},80367:(e,a,n)=>{"use strict";n.d(a,{default:()=>N});var r=n(95155);n(12115);var t=n(67642),i=n(5813),l=n(37974),o=n(31380),s=n(43536),m=n(89631),p=n(25702),u=n(98902),y=n(25856),c=n(83387),d=n(81064),_=n(95150),f=n(51250),g=n(56203),b=n(44407),K=n(37687),h=n(23130),S=n(12133),v=n(71093),w=n.n(v),C=n(88756),T=n(25996);let M=[{name:"Master Data",description:"Core reference data for manufacturing sites, chemical materials, production resources, and enterprise structures. These tables define the foundational organizational units and material specifications essential for chemical and pharmaceutical manufacturing operations.",tables:[{name:"plants",className:"PlantsDB",purpose:"Plant master data defining manufacturing sites and production facilities within the enterprise. Contains geographical coordinates, factory calendar assignments, and regional classifications for pharmaceutical and chemical production locations. Essential for supply chain planning and regulatory compliance tracking. Corresponds to S/4 HANA table T001W (Plants/Branches) and T001L (Storage Locations).",primaryKey:["plant_id","source_system","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"plant_name",type:"String",nullable:!0,primaryKey:!1},{name:"location",type:"String",nullable:!0,primaryKey:!1},{name:"latitude",type:"Float",nullable:!0,primaryKey:!1},{name:"longitude",type:"Float",nullable:!0,primaryKey:!1},{name:"factory_calendar_id",type:"String",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:["One-to-many with warehouse","One-to-many with resources","One-to-many with forecast"]},{name:"material_master",className:"MaterialMasterDB",purpose:"Material master data repository for chemical substances, pharmaceutical products, and intermediate materials. Includes product hierarchy classifications, base units of measure, storage requirements, and shelf life specifications. Supports regulatory compliance through transport and storage condition tracking. Corresponds to S/4 HANA tables MARA (General Material Data), MARC (Plant/Material Data), and MARM (Units of Measure).",primaryKey:["material_id","source_system","config_id"],columns:[{name:"material_id",type:"String",nullable:!1,primaryKey:!0},{name:"material_name",type:"String",nullable:!0,primaryKey:!1},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"material_type",type:"String",nullable:!0,primaryKey:!1},{name:"product_stage",type:"String",nullable:!0,primaryKey:!1},{name:"product_hierarchy",type:"String",nullable:!0,primaryKey:!1},{name:"buom",type:"String",nullable:!0,primaryKey:!1},{name:"buom_per_pallet",type:"Float",nullable:!0,primaryKey:!1},{name:"transport_condition",type:"String",nullable:!0,primaryKey:!1,constraints:["cold","normal","COLD","NORMAL"]},{name:"storage_condition",type:"String",nullable:!0,primaryKey:!1,constraints:["cold","normal","COLD","NORMAL"]},{name:"total_shelf_life",type:"Integer",nullable:!0,primaryKey:!1},{name:"launch_date",type:"DateTime",nullable:!0,primaryKey:!1},{name:"current_FG_version",type:"Integer",nullable:!0,primaryKey:!1},{name:"last_FG_version_change",type:"DateTime",nullable:!0,primaryKey:!1},{name:"FG_version_change_dist",type:"String",nullable:!0,primaryKey:!1},{name:"FG_version_change_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:["One-to-many with inventory","One-to-many with batches","One-to-many with forecast"]},{name:"warehouse",className:"WarehouseDB",purpose:"Storage location master data defining warehouse configurations within manufacturing plants. Maintains storage condition requirements for cold chain and ambient temperature materials. Critical for inventory management and regulatory compliance in pharmaceutical environments. Corresponds to S/4 HANA table T001L (Storage Locations) and MLT3 (Material Master Storage View).",primaryKey:["plant_id","source_system","storage_location_id","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"storage_location_id",type:"String",nullable:!1,primaryKey:!0},{name:"storage_location_name",type:"String",nullable:!0,primaryKey:!1},{name:"storage_condition",type:"String",nullable:!0,primaryKey:!1,constraints:["cold","normal","COLD","NORMAL"]},{name:"capacity",type:"Integer",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}
1],relationships:["Many-to-one with plants","One-to-many with inventory"]},{name:"resources",className:"ResourcesDB",purpose:"Production resource master data for manufacturing equipment, reactors, and process lines within chemical facilities. Includes validity periods for equipment qualification and maintenance scheduling. Essential for capacity planning and production recipe assignments in process industries. Corresponds to S/4 HANA tables CRHD (Resource Header), CRCO (Resource Capacity), and KAKO (Capacity Header).",primaryKey:["resource_id","plant_id","source_system","config_id"],columns:[{name:"resource_id",type:"String",nullable:!1,primaryKey:!0},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"resource_name",type:"String",nullable:!0,primaryKey:!1},{name:"valid_from",type:"DateTime",nullable:!0,primaryKey:!1},{name:"valid_to",type:"DateTime",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with plants","One-to-many with capacity","One-to-many with master_recipe_body"]},{name:"bom_header",className:"BillOfMaterialsHeaderDB",purpose:"Header information for bill of materials with primary materials and co-products. Defines the main output material and any secondary products generated during production processes. Essential for material requirements planning and production scheduling in chemical and pharmaceutical manufacturing.",primaryKey:["bom_id","plant_id","source_system","config_id"],columns:[{name:"bom_id",type:"String",nullable:!1,primaryKey:!0},{name:"plant_id",type:"String",nullable:!0,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"primary_material",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"primary_material_source_system",type:"String",nullable:!0,primaryKey:!1,defaultValue:"default_source_system"},{name:"co_products",type:"ARRAY(String)",nullable:!0,primaryKey:!1},{name:"co_products_quantity",type:"ARRAY(Float)",nullable:!0,primaryKey:!1},{name:"valid_from",type:"DateTime",nullable:!0,primaryKey:!1},{name:"valid_to",type:"DateTime",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"primary_material",referencedTable:"material_master",referencedColumn:"material_id"}],relationships:["Many-to-one with plants","Many-to-one with material_master","One-to-many with bom_body"]},{name:"bom_body",className:"BillOfMaterialsBodyDB",purpose:"Detailed component information for bill of materials including input materials and quantities. Defines the specific materials and amounts required to produce the primary material. Critical for material requirements planning and cost calculations in manufacturing operations.",primaryKey:["bom_id","plant_id","source_system","input_material","input_material_source_system","config_id"],columns:[{name:"bom_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"bom_header",column:"bom_id"}},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"input_material",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"input_material_source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"input_quantity",type:"Float",nullable:!0,primaryKey:!1},{name:"conditional_production",type:"Boolean",nullable:!0,primaryKey:!1,defaultValue:"false"},{name:"manufacturing_date_relevant",type:"Boolean",nullable:!0,primaryKey:!1,defaultValue:"false"},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"bom_id",referencedTable:"bom_header",referencedColumn:"bom_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"input_material",referencedTable:"material_master",referencedColumn:"material_id"}],relationships:["Many-to-one with bom_header","Many-to-one with plants","Many-to-one with material_master"]},{name:"master_recipe",className:"MasterRecipeDB",purpose:"Header information for manufacturing recipes defining production processes for specific materials. Links target materials to their production methods and serves as the foundation for process order generation in chemical and pharmaceutical manufacturing.",primaryKey:["plant_id","source_system","recipe_id","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"target_material_id",type:"String",nullable:!0,primaryKey:!1},{name:"recipe_id",type:"String",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}
1],relationships:["Many-to-one with plants","One-to-many with master_recipe_body"]},{name:"master_recipe_body",className:"MasterRecipeBodyDB",purpose:"Detailed operations within master recipes including duration parameters, resource assignments, and cost information. Defines the specific production steps, equipment requirements, and timing for manufacturing processes in chemical and pharmaceutical operations.",primaryKey:["recipe_id","operation_id","plant_id","source_system","config_id"],columns:[{name:"recipe_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"operation_id",type:"String",nullable:!1,primaryKey:!0},{name:"operation_description",type:"String",nullable:!0,primaryKey:!1},{name:"resource",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"resources",column:"resource_id"}},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"setup_duration_type",type:"String",nullable:!0,primaryKey:!1},{name:"setup_duration_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"cleaning_duration_type",type:"String",nullable:!0,primaryKey:!1},{name:"cleaning_duration_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"execution_duration_type",type:"String",nullable:!0,primaryKey:!1},{name:"execution_duration_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"planned_duration_type",type:"String",nullable:!1,primaryKey:!1},{name:"planned_duration_params",type:"JSON",nullable:!1,primaryKey:!1},{name:"setup_cost",type:"Float",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"recipe_id",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"resource",referencedTable:"resources",referencedColumn:"resource_id"}],relationships:["Many-to-one with master_recipe","Many-to-one with plants","Many-to-one with resources"]},{name:"production_version",className:"ProductionVersionDB",purpose:"Links materials to specific production methods combining recipes and BOMs with production parameters. Defines how materials should be manufactured including lot sizing, scheduling parameters, and quality distributions for pharmaceutical and chemical production processes.",primaryKey:["pv_id","source_system","plant_id","config_id"],columns:[{name:"pv_id",type:"String",nullable:!1,primaryKey:!0},{name:"target_material",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"master_recipe",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"bom",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"bom_header",column:"bom_id"}},{name:"input_quantity_dist",type:"String",nullable:!0,primaryKey:!1},{name:"input_quantity_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"output_quantity_dist",type:"String",nullable:!0,primaryKey:!1},{name:"output_quantity_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"planned_duration_type",type:"String",nullable:!0,primaryKey:!1},{name:"planned_duration_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"scrap_distribution_type",type:"String",nullable:!0,primaryKey:!1},{name:"scrap_distribution_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"min_lotsize_value",type:"Float",nullable:!0,primaryKey:!1,defaultValue:"0"},{name:"max_lotsize_value",type:"Float",nullable:!0,primaryKey:!1},{name:"period_length",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"1"},{name:"lot_required_day",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"0"},{name:"rounding_value",type:"Float",nullable:!0,primaryKey:!1},{name:"from_lotsize_validity",type:"Float",nullable:!0,primaryKey:!1,defaultValue:"0"},{name:"to_lotsize_validity",type:"Float",nullable:!0,primaryKey:!1},{name:"valid_from",type:"DateTime",nullable:!0,primaryKey:!1},{name:"valid_to",type:"DateTime",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"target_material",referencedTable:"material_master",referencedColumn:"material_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"master_recipe",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"bom",referencedTable:"bom_header",referencedColumn:"bom_id"}],relationships:["Many-to-one with material_master","Many-to-one with plants","Many-to-one with master_recipe","Many-to-one with bom_header"]}
1,{name:"capacity",className:"CapacityDB",purpose:"Defines resource capacity schedules by weekday and time periods for production planning. Manages available working hours and shifts for manufacturing equipment and facilities, essential for production scheduling and resource optimization in chemical and pharmaceutical operations.",primaryKey:["plant_id","source_system","resource_id","weekday","valid_from","valid_to","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"resource_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"resources",column:"resource_id"}},{name:"weekday",type:"Integer",nullable:!1,primaryKey:!0},{name:"start_time",type:"Integer",nullable:!0,primaryKey:!1},{name:"end_time",type:"Integer",nullable:!0,primaryKey:!1},{name:"valid_from",type:"DateTime",nullable:!1,primaryKey:!0},{name:"valid_to",type:"DateTime",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"resource_id",referencedTable:"resources",referencedColumn:"resource_id"}],relationships:["Many-to-one with plants","Many-to-one with resources"]},{name:"forecast",className:"ForecastDB",purpose:"Stores material demand forecasts by month/year and plant for production planning. Contains projected quantities needed for each material at specific manufacturing locations, enabling effective demand planning and inventory management in supply chain operations.",primaryKey:["material_id","source_system","month","year","plant_id","config_id"],columns:[{name:"material_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"month",type:"Integer",nullable:!1,primaryKey:!0},{name:"year",type:"Integer",nullable:!1,primaryKey:!0},{name:"quantity",type:"Float",nullable:!1,primaryKey:!1},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with material_master","Many-to-one with plants"]},{name:"local_material_master",className:"LocalMaterialMasterDB",purpose:"Plant-specific material master data with sourcing configurations and stock level definitions. Contains local material information including sourcing strategies, safety stock levels, and delivery locations specific to each manufacturing plant.",primaryKey:["plant_id","material_id","source_system","valid_from","valid_to","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"material_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"sourcing",type:"String",nullable:!1,primaryKey:!1},{name:"delivery_storage_location_id",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"warehouse",column:"storage_location_id"}},{name:"min_required_shelf_life_market_in_days",type:"Float",nullable:!0,primaryKey:!1,defaultValue:"0.0"},{name:"strategic_stock",type:"Float",nullable:!1,primaryKey:!1,defaultValue:"0.0"},{name:"strategic_stock_unit",type:"String",nullable:!1,primaryKey:!1,defaultValue:"EA"},{name:"safety_stock",type:"Float",nullable:!1,primaryKey:!1,defaultValue:"0.0"},{name:"safety_stock_unit",type:"String",nullable:!1,primaryKey:!1,defaultValue:"EA"},{name:"iron_stock",type:"Float",nullable:!1,primaryKey:!1,defaultValue:"0.0"},{name:"iron_stock_unit",type:"String",nullable:!1,primaryKey:!1,defaultValue:"EA"},{name:"valid_from",type:"DateTime",nullable:!1,primaryKey:!0},{name:"valid_to",type:"DateTime",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"delivery_storage_location_id",referencedTable:"warehouse",referencedColumn:"storage_location_id"}],relationships:["Many-to-one with plants","Many-to-one with material_master","Many-to-one with warehouse"]},{name:"sourcing_buy_extern",className:"SourcingBuyExternalDB",purpose:"External supplier sourcing information with lead times and order quantities. Defines procurement relationships with external suppliers including order constraints, lead time distributions, and pricing information for materials sourced outside the organization.",primaryKey:["supplier","material_id","source_system","target_plant","config_id"],columns:[{name:"supplier",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"material_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"target_plant",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"min_order_quantity",type:"Integer",nullable:!0,primaryKey:!1},{name:"max_order_quantity",type:"Integer",nullable:!0,primaryKey:!1},{name:"rounding_value",type:"Float",nullable:!0,primaryKey:!1},{name:"lead_time_dist",type:"String",nullable:!0,primaryKey:!1},{name:"lead_time_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"quantity_dist",type:"String",nullable:!0,primaryKey:!1},{name:"quantity_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"procurement_price",type:"Float",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"supplier",referencedTable:"plants",referencedColumn:"plant_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"target_plant",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with plants (supplier)","Many-to-one with material_master","Many-to-one with plants (target_plant)"]},{name:"sourcing_buy_intern",className:"SourcingBuyInternalDB",purpose:"Internal plant-to-plant sourcing relationships for inter-company material transfers. Defines internal supply chain connections between manufacturing plants within the same organization, enabling efficient material flow and production coordination.",primaryKey:["target_plant_id","material_id","source_system","source_plant_id","transport_mode","config_id"],columns:[{name:"target_plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"material_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"source_plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"transport_mode",type:"Integer",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"target_plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"source_plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with plants (target)","Many-to-one with material_master","Many-to-one with plants (source)"]}
1,{name:"transport_modes",className:"TransportModesDB",purpose:"Available transport modes with valid equipment types for material movement. Defines transportation methods and compatible equipment for moving materials between plants and suppliers, supporting logistics planning and cost optimization.",primaryKey:["mode_of_transport_id","config_id"],columns:[{name:"mode_of_transport_id",type:"Integer",nullable:!1,primaryKey:!0},{name:"description",type:"String",nullable:!0,primaryKey:!1},{name:"valid_equipment",type:"ARRAY(String)",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:["One-to-many with transport_routes"]},{name:"transport_routes",className:"TransportRoutesDB",purpose:"Transportation routes between plants with duration distributions for logistics planning. Defines specific pathways for material movement including transport modes, timing parameters, and validity periods for supply chain optimization.",primaryKey:["transport_route_id","config_id"],columns:[{name:"transport_route_id",type:"String",nullable:!1,primaryKey:!0},{name:"source_plant_id",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"target_plant_id",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!0,primaryKey:!1,defaultValue:"default_source_system"},{name:"mode_of_transport_id",type:"Integer",nullable:!0,primaryKey:!1,foreignKey:{table:"transport_modes",column:"mode_of_transport_id"}},{name:"duration_dist_type",type:"String",nullable:!0,primaryKey:!1},{name:"duration_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"valid_from",type:"DateTime",nullable:!0,primaryKey:!1},{name:"valid_to",type:"DateTime",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"source_plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"target_plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"mode_of_transport_id",referencedTable:"transport_modes",referencedColumn:"mode_of_transport_id"}],relationships:["Many-to-one with plants (source)","Many-to-one with plants (target)","Many-to-one with transport_modes"]},{name:"factory_calendar",className:"FactoryCalendarDB",purpose:"Factory calendar definitions managing working days and holidays for production planning. Defines non-working days and alternative working schedules for manufacturing facilities, essential for accurate production scheduling and capacity planning.",primaryKey:["factory_calendar_id","config_id"],columns:[{name:"factory_calendar_id",type:"String",nullable:!1,primaryKey:!0},{name:"days_off",type:"ARRAY(DateTime)",nullable:!0,primaryKey:!1},{name:"act_as",type:"ARRAY(String)",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:["One-to-many with plants"]},{name:"equipment",className:"EquipmentDB",purpose:"Equipment master data including capacity specifications for manufacturing assets. Stores information about production equipment including pallet slot capacity for material handling and storage optimization in manufacturing operations.",primaryKey:["equipment_id","config_id"],columns:[{name:"equipment_id",type:"String",nullable:!1,primaryKey:!0},{name:"equipment_name",type:"String",nullable:!0,primaryKey:!1},{name:"number_of_pallet_slots",type:"Integer",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:[]},{name:"building_maintenance",className:"BuildingMaintenanceDB",purpose:"Building maintenance schedules and durations for manufacturing facilities. Manages facility maintenance cycles and downtime requirements, ensuring proper facility management and production continuity in manufacturing operations.",primaryKey:["plant_id","source_system","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"duration",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"10080"},{name:"cycle_in_days",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"365"},{name:"config_id",type:"String",nullable:!1,primaryKey:!0}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with plants"]},{name:"resource_maintenance",className:"ResourceMaintenanceDB",purpose:"Resource-specific maintenance schedules and cycles for production equipment. Manages maintenance requirements for individual manufacturing resources including duration and frequency parameters for optimal equipment performance.",primaryKey:["plant","source_system","resource_id","config_id"],columns:[{name:"plant",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"resource_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"resources",column:"resource_id"}},{name:"duration",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"2880"},{name:"cycle_in_days",type:"Integer",nullable:!0,primaryKey:!1,defaultValue:"60"},{name:"config_id",type:"String",nullable:!1,primaryKey:!0}],foreignKeys:[{column:"plant",referencedTable:"plants",referencedColumn:"plant_id"},{column:"resource_id",referencedTable:"resources",referencedColumn:"resource_id"}],relationships:["Many-to-one with plants","Many-to-one with resources"]},{name:"precedence_operations",className:"PrecedenceOperationsDB",purpose:"Defines precedence relationships between operations in manufacturing recipes. Establishes operation dependencies and sequencing requirements for production processes, ensuring proper order of manufacturing steps in chemical and pharmaceutical operations.",primaryKey:["recipe_id","operation_id","precedence_recipe_id","precedence_operation_id","plant_id","source_system","config_id"],columns:[{name:"recipe_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"operation_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe_body",column:"operation_id"}},{name:"precedence_recipe_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"precedence_operation_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe_body",column:"operation_id"}},{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"recipe_id",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"operation_id",referencedTable:"master_recipe_body",referencedColumn:"operation_id"},{column:"precedence_recipe_id",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"precedence_operation_id",referencedTable:"master_recipe_body",referencedColumn:"operation_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with master_recipe","Many-to-one with master_recipe_body","Many-to-one with plants"]},{name:"successor_operations",className:"SuccessorOperationsDB",purpose:"Defines successor relationships between operations in manufacturing recipes. Establishes operation sequencing and dependency chains for production processes, complementing precedence relationships for comprehensive process flow control.",primaryKey:["plant_id","source_system","recipe_id","operation_id","successor_recipe_id","successor_operation_id","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"recipe_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"operation_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe_body",column:"operation_id"}},{name:"successor_recipe_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe",column:"recipe_id"}},{name:"successor_operation_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"master_recipe_body",column:"operation_id"}},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"recipe_id",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"operation_id",referencedTable:"master_recipe_body",referencedColumn:"operation_id"},{column:"successor_recipe_id",referencedTable:"master_recipe",referencedColumn:"recipe_id"},{column:"successor_operation_id",referencedTable:"master_recipe_body",referencedColumn:"operation_id"}],relationships:["Many-to-one with plants","Many-to-one with master_recipe","Many-to-one with master_recipe_body"]},{name:"forecast_distributions",className:"ForecastDistributionsDB",purpose:"Statistical distributions for forecast volatility and daily quantity variations. Stores distribution parameters for demand forecasting uncertainty and daily quantity fluctuations, enabling stochastic supply chain planning and risk assessment.",primaryKey:["material_id","source_system","config_id"],columns:[{name:"material_id",type:"String",nullable:!1,primaryKey:!0},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"plant_id",type:"String",nullable:!0,primaryKey:!1},{name:"volatility_dist",type:"String",nullable:!0,primaryKey:!1},{name:"volatility_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"daily_quantity_dist",type:"String",nullable:!0,primaryKey:!1},{name:"daily_quantity_dist_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:["Related to forecast","Related to local_material_master"]},{name:"hierarchy_lookup",className:"HierarchyLookupDB",purpose:"Hierarchical structure definitions with level descriptions for organizational and product hierarchies. Defines hierarchy levels and their meanings for various classification systems used in manufacturing and supply chain management.",primaryKey:["hierarchy","level","config_id"],columns:[{name:"hierarchy",type:"String",nullable:!1,primaryKey:!0},{name:"level",type:"Integer",nullable:!1,primaryKey:!0},{name:"description",type:"String",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[],relationships:[]},{name:"qi_blueprint",className:"QIBlueprintDB",purpose:"Quality inspection blueprints with duration and decision distributions for quality assurance processes. Defines inspection procedures, timing parameters, and decision criteria for quality control in pharmaceutical and chemical manufacturing.",primaryKey:["id","config_id"],columns:[{name:"id",type:"String",nullable:!1,primaryKey:!0},{name:"material_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!0,primaryKey:!1,defaultValue:"default_source_system"},{name:"plant_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"production_version",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"production_version",column:"pv_id"}},{name:"transport_route",type:"String",nullable:!0,primaryKey:!1,foreignKey:{table:"transport_routes",column:"transport_route_id"}},{name:"supplier_id",type:"String",nullable:!0,primaryKey:!1},{name:"inspection_type",type:"String",nullable:!1,primaryKey:!1,constraints:["production","purchase","transport"]},{name:"planned_duration_distribution",type:"String",nullable:!1,primaryKey:!1},{name:"planned_duration_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"usage_decision_distribution",type:"String",nullable:!1,primaryKey:!1},{name:"usage_decision_params",type:"JSON",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"production_version",referencedTable:"production_version",referencedColumn:"pv_id"},{column:"transport_route",referencedTable:"transport_routes",referencedColumn:"transport_route_id"}],relationships:["Many-to-one with material_master","Many-to-one with plants","Many-to-one with production_version","Many-to-one with transport_routes"]}]},{name:"Transactional Data",description:"Real-time operational data capturing inventory positions, production orders, and batch information. These tables maintain current state information for materials management, order processing, and lot traceability in chemical and pharmaceutical manufacturing environments.",tables:[{name:"inventory",className:"InventoryDB",purpose:"Real-time inventory positions tracking material quantities by storage location and batch number. Maintains stock status classifications and date-stamped inventory snapshots for regulatory auditing. Critical for materials management and supply chain visibility in process industries. Corresponds to S/4 HANA tables MARD (Storage Location Stock), MCHB (Batch Stock), and MSKU (Special Stock).",primaryKey:["plant_id","material_id","source_system","storage_location_id","date","config_id"],columns:[{name:"plant_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"plants",column:"plant_id"}},{name:"material_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"batch_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"batches",column:"batch_id"}},{name:"storage_location_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"warehouse",column:"storage_location_id"}},{name:"quantity",type:"Float",nullable:!1,primaryKey:!1},{name:"status",type:"String",nullable:!1,primaryKey:!1},{name:"date",type:"DateTime",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"batch_id",referencedTable:"batches",referencedColumn:"batch_id"},{column:"storage_location_id",referencedTable:"warehouse",referencedColumn:"storage_location_id"}],relationships:["Many-to-one with plants","Many-to-one with material_master","Many-to-one with batches","Many-to-one with warehouse"]},{name:"batches",className:"BatchesDB",purpose:"Batch and lot master data maintaining traceability information for chemical and pharmaceutical products. Tracks manufacturing dates, expiration periods, batch genealogy, and quality status for regulatory compliance. Essential for recall management and product quality assurance in life sciences. Corresponds to S/4 HANA tables MCH1 (Batch Master Record), MCHA (Batch Characteristics), and QALS (Quality Assurance Lot).",primaryKey:["batch_id","config_id"],columns:[{name:"batch_id",type:"String",nullable:!1,primaryKey:!0},{name:"manufacturing_date",type:"DateTime",nullable:!1,primaryKey:!1},{name:"expiration_date",type:"DateTime",nullable:!1,primaryKey:!1},{name:"bix_version",type:"Integer",nullable:!1,primaryKey:!1},{name:"size_at_creation",type:"Float",nullable:!1,primaryKey:!1},{name:"used_amount",type:"Float",nullable:!1,primaryKey:!1},{name:"material_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system"
1,type:"String",nullable:!1,primaryKey:!1,defaultValue:"default_source_system"},{name:"plant_of_creation",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"status",type:"String",nullable:!1,primaryKey:!1,constraints:["restricted","unrestricted","RESTRICTED","UNRESTRICTED"]},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"plant_of_creation",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with material_master","Many-to-one with plants","One-to-many with inventory","One-to-many with batch_history"]},{name:"batch_history",className:"BatchHistoryDB",purpose:"Historical tracking of batch events and status changes for audit trails and traceability. Maintains chronological records of batch operations including status changes, movements, and quality decisions. Essential for regulatory compliance and batch genealogy in pharmaceutical and chemical manufacturing.",primaryKey:["batch_id","type","date","config_id"],columns:[{name:"batch_id",type:"String",nullable:!1,primaryKey:!0,foreignKey:{table:"batches",column:"batch_id"}},{name:"type",type:"String",nullable:!1,primaryKey:!0},{name:"date",type:"DateTime",nullable:!1,primaryKey:!0},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"batch_id",referencedTable:"batches",referencedColumn:"batch_id"}],relationships:["Many-to-one with batches"]},{name:"current_process_orders",className:"CurrentProcessOrdersDB",purpose:"Active process order management for chemical and pharmaceutical manufacturing campaigns. Maintains production scheduling, material reservations, and operation sequences for batch production processes. Includes scrap calculations and material availability tracking for efficient production execution. Corresponds to S/4 HANA tables AUFK (Order Header), AFKO (Order Header PP), RESB (Reservation/Dependent Requirements), and AFRU (Order Confirmations).",primaryKey:["order_id","source_system","config_id"],columns:[{name:"order_id",type:"String",nullable:!1,primaryKey:!0},{name:"pv_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"production_version",column:"pv_id"}},{name:"plant_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"source_system",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_source_system"},{name:"status",type:"String",nullable:!1,primaryKey:!1},{name:"planned_start_date",type:"Float",nullable:!0,primaryKey:!1},{name:"planned_end_date",type:"Float",nullable:!0,primaryKey:!1},{name:"actual_start_date",type:"Float",nullable:!0,primaryKey:!1},{name:"actual_end_date",type:"Float",nullable:!0,primaryKey:!1},{name:"required_date",type:"Float",nullable:!0,primaryKey:!1},{name:"operations",type:"JSON",nullable:!0,primaryKey:!1},{name:"materials_available_since",type:"DateTime",nullable:!0,primaryKey:!1},{name:"reservation_expires_at",type:"DateTime",nullable:!0,primaryKey:!1},{name:"order_scrap",type:"Float",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"pv_id",referencedTable:"production_version",referencedColumn:"pv_id"},{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with production_version","Many-to-one with plants"]},{name:"current_purchase_orders",className:"CurrentPurchaseOrdersDB",purpose:"Active purchase order management for external material procurement. Tracks supplier relationships, delivery schedules, and order fulfillment status for materials sourced from external vendors. Essential for procurement planning and supplier performance monitoring in supply chain operations.",primaryKey:["order_id","config_id"],columns:[{name:"order_id",type:"String",nullable:!1,primaryKey:!0},{name:"plant_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"material_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!0,primaryKey:!1,defaultValue:"default_source_system"},{name:"supplier_id",type:"String",nullable:!1,primaryKey:!1},{name:"quantity",type:"Float",nullable:!1,primaryKey:!1},{name:"status",type:"String",nullable:!1,primaryKey:!1,constraints:["planned","fixed","in_progress","delivered","PLANNED","FIXED","IN_PROGRESS","DELIVERED"]},{name:"planned_ordering_date",type:"Float",nullable:!0,primaryKey:!1},{name:"requested_delivery_date",type:"Float",nullable:!0,primaryKey:!1},{name:"actual_delivery_date",type:"Float",nullable:!0,primaryKey:!1},{name:"actual_quantity",type:"Float",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"plant_id",referencedTable:"plants",referencedColumn:"plant_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"}],relationships:["Many-to-one with plants","Many-to-one with material_master"]},{name:"current_transport_orders",className:"CurrentTransportOrdersDB",purpose:"Active transport order management for inter-plant material movements. Coordinates shipments between manufacturing facilities including route planning, temperature control, and delivery tracking. Critical for multi-plant supply chain coordination and cold chain management in pharmaceutical operations.",primaryKey:["order_id","config_id"],columns:[{name:"order_id",type:"String",nullable:!1,primaryKey:!0},{name:"transport_route_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"transport_routes",column:"transport_route_id"}},{name:"planned_start_date",type:"Float",nullable:!1,primaryKey:!1},{name:"planned_end_date",type:"Float",nullable:!1,primaryKey:!1},{name:"material_id",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"material_master",column:"material_id"}},{name:"source_system",type:"String",nullable:!0,primaryKey:!1,defaultValue:"default_source_system"},{name:"amount",type:"Float",nullable:!1,primaryKey:!1},{name:"source_plant",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"destination_plant",type:"String",nullable:!1,primaryKey:!1,foreignKey:{table:"plants",column:"plant_id"}},{name:"status",type:"String",nullable:!1,primaryKey:!1},{name:"temperature_class",type:"String",nullable:!1,primaryKey:!1},{name:"actual_start_date",type:"Float",nullable:!0,primaryKey:!1},{name:"actual_end_date",type:"Float",nullable:!0,primaryKey:!1},{name:"shipments",type:"ARRAY(String)",nullable:!0,primaryKey:!1},{name:"open_shipments",type:"ARRAY(String)",nullable:!0,primaryKey:!1},{name:"total_price",type:"Float",nullable:!0,primaryKey:!1},{name:"incidents",type:"Float",nullable:!0,primaryKey:!1},{name:"materials_available_since",type:"Float",nullable:!0,primaryKey:!1},{name:"config_id",type:"String",nullable:!1,primaryKey:!0,defaultValue:"default_config"}],foreignKeys:[{column:"transport_route_id",referencedTable:"transport_routes",referencedColumn:"transport_route_id"},{column:"material_id",referencedTable:"material_master",referencedColumn:"material_id"},{column:"source_plant",referencedTable:"plants",referencedColumn:"plant_id"},{column:"destination_plant",referencedTable:"plants",referencedColumn:"plant_id"}],relationships:["Many-to-one with transport_routes","Many-to-one with material_master","Many-to-one with plants (source)","Many-to-one with plants (destination)"]}]}],{Title:x,Text:D,Paragraph:A}=t.A,{Panel:V}=i.A,N=()=>(0,r.jsx)("div",{className:w().body,children:(0,r.jsxs)(C.default,{children:[(0,r.jsx)(T.default,{level:2,alignment:"center",children:"Data Product Guide"}),(0,r.jsxs)("div",{style:{maxWidth:1200,margin:"0 auto",padding:"20px"},children:[(0,r.jsx)(A,{children:"Our blueprint database schema is the core working foundation for IntelliTwin, representing our standard data model that has been specifically developed for the chemical and pharmaceutical industries with broader applications across the process industry. This comprehensive schema is able to represent the unique specifics and complexities of these industries, including batch production, quality control, regulatory compliance, and complex supply chain relationships. The design is strongly inspired by SAP ECC and S/4 HANA as core ERP systems, ensuring compatibility and seamless integration with existing enterprise infrastru
1ctures."}),(0,r.jsx)(A,{children:"Through our deployment and development projects, it has become evident that this database schema is a true data asset, as it includes all relevant global supply chain parameters with regards to planning and simulation - covering everything from material master data to production recipes, capacity planning, and multi-plant coordination, provided costs are not the primary consideration. Our consulting team of experts has refined this schema through extensive real-world implementations, ensuring it captures the essential elements needed for effective supply chain modeling and simulation in complex manufacturing environments."}),(0,r.jsx)(A,{children:"This comprehensive database schema documentation provides detailed information about all tables, columns, relationships, and constraints in our supply chain simulation system. The database follows a multi-tenant architecture with temporal data support and flexible parameter storage using JSON columns."}),(0,r.jsx)(p.A,{dataSource:M,renderItem:e=>(0,r.jsx)(p.A.Item,{style:{display:"block",padding:"24px 0"},children:(0,r.jsxs)(s.A,{title:(0,r.jsx)(x,{level:3,style:{margin:0},children:e.name}),style:{width:"100%"},children:[(0,r.jsx)(A,{type:"secondary",style:{marginBottom:24},children:e.description}),(0,r.jsx)("div",{children:e.tables.map(e=>(e=>(0,r.jsxs)(s.A,{title:(0,r.jsxs)("div",{children:[(e=>{let a={marginRight:8,color:"var(--adago-color)"};switch(e){case"plants":return(0,r.jsx)(u.A,{style:a});case"material_master":return(0,r.jsx)(y.A,{style:a});case"warehouse":return(0,r.jsx)(c.A,{style:a});case"resources":return(0,r.jsx)(d.A,{style:a});case"inventory":return(0,r.jsx)(_.A,{style:a});case"batches":return(0,r.jsx)(f.A,{style:a});case"current_process_orders":return(0,r.jsx)(g.A,{style:a});default:return(0,r.jsx)(b.A,{style:a})}})(e.name),(0,r.jsx)("strong",{children:e.name}),(0,r.jsxs)(D,{type:"secondary",style:{marginLeft:8},children:["(",e.className,")"]})]}),size:"small",style:{marginBottom:16},children:[(0,r.jsx)(A,{type:"secondary",children:e.purpose}),(0,r.jsxs)(m.A,{size:"small",column:1,bordered:!0,style:{marginBottom:16},children:[(0,r.jsx)(m.A.Item,{label:"Primary Key",children:(0,r.jsx)("div",{children:e.primaryKey.map((e,a)=>(0,r.jsx)(l.A,{icon:(0,r.jsx)(K.A,{}),style:{backgroundColor:"var(--adago-color)",color:"white",borderColor:"var(--adago-color)"},children:e},a))})}),e.foreignKeys.length>0&&(0,r.jsx)(m.A.Item,{label:"Foreign Keys",children:(0,r.jsx)("div",{children:e.foreignKeys.map((e,a)=>(0,r.jsxs)(l.A,{icon:(0,r.jsx)(h.A,{}),style:{backgroundColor:"var(--accent-color)",color:"white",borderColor:"var(--accent-color)"},children:[e.column," â ",e.referencedTable,".",e.referencedColumn]},a))})}),e.relationships.length>0&&(0,r.jsx)(m.A.Item,{label:"Relationships",children:(0,r.jsx)("div",{children:e.relationships.map((e,a)=>(0,r.jsx)(l.A,{icon:(0,r.jsx)(S.A,{}),style:{backgroundColor:"var(--text-color)",color:"white",borderColor:"var(--text-color)"},children:e},a))})})]}),(0,r.jsx)(i.A,{size:"small",ghost:!0,defaultActiveKey:["columns"],children:(0,r.jsx)(V,{header:(0,r.jsxs)("strong",{children:["Columns (",e.columns.length,")"]}),children:(e=>{let a=e.map((e,a)=>({key:a,name:(0,r.jsxs)("div",{children:[(0,r.jsx)("strong",{children:e.name}),e.primaryKey&&(0,r.jsx)(l.A,{style:{marginLeft:8,backgroundColor:"var(--adago-color)",color:"white",borderColor:"var(--adago-color)"},children:"PK"}),e.foreignKey&&(0,r.jsx)(l.A,{style:{marginLeft:8,backgroundColor:"var(--accent-color)",color:"white",borderColor:"var(--accent-color)"},children:"FK"})]}),type:e.type,nullable:e.nullable?"Yes":"No",defaultValue:e.defaultValue||"-",constraints:(0,r.jsxs)("div",{children:[e.constraints&&e.constraints.length>0&&(0,r.jsx)("div",{children:e.constraints.map((e,a)=>(0,r.jsx)(l.A,{style:{marginBottom:4,backgroundColor:"var(--text-color)",color:"white",borderColor:"var(--text-color)"},children:e},a))}),e.foreignKey&&(0,r.jsxs)(l.A,{style:{marginBottom:4,backgroundColor:"var(--accent-color)",color:"white",borderColor:"var(--accent-color)"},children:["â ",e.foreignKey.table,".",e.foreignKey.column]})]})}));return(0,r.jsx)(o.A,{columns:[{title:"Name",dataIndex:"name",key:"name",width:"20%"},{title:"Type",dataIndex:"type",key:"type",width:"20%"},{title:"Nullable",dataIndex:"nullable",key:"nullable",width:"10%"},{title:"Default",dataIndex:"defaultValue",key:"defaultValue",width:"15%"},{title:"Constraints",dataIndex:"constraints",key:"constraints",width:"35%"}],dataSource:a,pagination:!1,size:"small",bordered:!0,style:{backgroundColor:"var(--background-grey)",borderColor:"var(--adago-color)"}})})(e.columns)},"columns")})]},e.name))(e))})]})},e.name)})]})]})})},88756:(e,a,n)=>{"use strict";
1n.r(a),n.d(a,{BackgroundContext:()=>o,default:()=>s});var r=n(95155),t=n(12115),i=n(21168),l=n.n(i);let o=(0,t.createContext)(""),s=e=>{let{backgroundColor:a,children:n}=e;return(0,r.jsx)(o.Provider,{value:a||"",children:(0,r.jsx)("div",{className:"".concat(l().outercontainer," ").concat(a?l()[a]:""),children:(0,r.jsx)("div",{className:l().outerframe,children:n})})})}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.