Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The SQL database has two tables called "Zone" and "Rules". Users are allowed to select a "zone_id" from the Zone table and use the "zone_id" as a foreign key to select the rules associated with that "zone_id". In the Zone table, "zone_id" is the primary key and "Demog" isĀ the foreign key in the Rules table. Please see below the structure of Zones and Rules tables.

ZoneĀ 

Zone_IDZone
200Stanislaus
201Brower
202Alton

Rules

DemogRules
200IsDisabled=True
200isRequired=False
201IsDisabled=False
201isRequired=True

Instructions

This example makes use of the below-given apps.

...