Skip to content
This repository has been archived by the owner on Nov 19, 2020. It is now read-only.

Database changes

khuranabalvinder edited this page Jun 20, 2013 · 14 revisions

Links to commits for database changes - Adding tables for Regimen and Regimen Categories, Adding regimenTemplateConfigured to Programs

Making audit fields consistent across all tables

Adding column 'push' to programs table to indicate whether it is push based or pull based

Adding columns 'catchment Population', 'longitude', 'latitude' to geographic_Zones

Adding columns 'productGroupId' to products table

Adding delivery zone ID field to role_assignments

Removing isa from program product table and adding programProductId to program product isa

Adding table for facility allocation program products

Added unique constraint to facility allocation program products on facilityId and programProductId and added not null constraint to programProductId on program_product_isa table

Clone this wiki locally