...
The SQL database has two tables called "Zone" and "Rules". Users are allowed to select a "zone_id" from the zone table and then 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 |
...