Create a foreign table for packages, in which packages name, desc, amount, will be stored.
Its foreign key will be brought into organization table, and starting date of package, ending date of package and due date of subscription of package will also be stored.
System will generate alert according to these dates and can also stop working if we'll program this way.
Note: Packages can be different for Branches of same orgaization as well.
Create a foreign table for packages, in which packages name, desc, amount, will be stored.
Its foreign key will be brought into organization table, and starting date of package, ending date of package and due date of subscription of package will also be stored.
System will generate alert according to these dates and can also stop working if we'll program this way.
Note: Packages can be different for Branches of same orgaization as well.