Dbmodel: filling tables and strategies

Giswater was designed with Dual-face database model which integrates data from inventory and data from hydraulic model, using two different sides for each asset element: the inventory side (inventory tables) and the EPA side (epa tables), which provides full flexibility to hydraulic modeler to work with hydraulic capabilities without any impact on inventory data for each asset element.

Moreover, you can find their relations acting as a standard DB approach:

• Mapzones tables
• Inventory tables
• Document tables
• Element tables
• O&M tables
• Epa tables
• Plan tables
• Domain-value tables
• Base map tables
• Feature views strategy
• CRM tables

In addition, you can find tables within 'inside logics' working in advanced DB approach:

• System tables
• Config tables
• Catalog tables
• Selector tables