...
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_ID | Zone |
---|---|
200 | Stanislaus |
201 | Brower |
202 | Alton |
Rules
Demog | Rules |
---|---|
200 | IsDisabled=True |
200 | isRequired=False |
201 | IsDisabled=False |
201 | isRequired=True |
Instructions
This example makes use of the below-given apps.
...