search

retreat-dev / retreat-dev-general

The retreat general
0 stars 0 forks source link

DB table "church_inventory" implementation #12

Open retreat-dev opened 2 years ago

retreat-dev commented 2 years ago

To provide the church inventory centric.

Implementations:

  1. add a new column name "ChurchSerialNum" into the table "member"
  2. update the records in table "member" (ChurchSerialNum) with "church_inventory" (SerialNum) based on the field "Church" in "member".
  3. "Church Record Management" provides the "Sync Church Display Name" button to sync the table "member" with the field "Church" according to "chuch_inventory" records.
  4. any record change at "Church Record Management", and the corresponding church display name will be updated table "retreat".
retreat-dev commented 2 years ago

updated "church_inventory"."SerialNum" -> "member"."ChurchSerialNum"

For members that registered with "church" value as "other", there are 5 records and no action for them.