To Do
- Kathleen will be out until June 16, with limited contact
- Add place to everything in the DB (see below)
- Work with Joseph on structure of the database and getting the data into good format
- He will look up IDs (in the last name search) of the people he’s modified, since some were wrong because the list I gave him didn’t account for middle names stored in the GivenName field (ex: he has wrong id for William Wines Phelps: I gave him a William Phelps who was likely a descendent of William Wines Phelps, since the search for William Phelps didn’t match William Wines Phelps. Since that was the only one, he updated the information as if that person was William Wines. But, we need to make sure the IDs are correctly matched in case they actually do exist in the DB (as William Wines does), so that when we suck them in, we don’t have people as their own children, etc.
- Start working on the abstract for DHF14. Kathleen will be out of contact until after due date, but has given us her proposal to IATH so that we can use text from that for the abstract. Joseph will also help, but we need to figure out travel if we get accepted and want to go for the symposium.
Database Organization
- Created an organization scheme to consider, shown below:
.
Table Structure for DB
- Marriage
- ID
- Type (enum)
- Sealing: time
- Sealing: eternity
- Civic: civil
- PlaceID
- HusbandID
- HusbandProxyID
- WifeID
- WifeProxyID
- DivorceDate (Civil Divorce)
- CancelledDate (Church recognized cancellation of sealing)
- OfficiatorID
- PrivateNotes
- PublicNotes
- Non-Marital Sealings
- ID
- PlaceID
- AdopteeID (Person being sealed)
- AdopteeProxyID
- MarriageID (Couple to whom the person is being sealed)
- MarriageProxyID
- OfficiatorID
- Date
- Type (enum)
- Adoption
- Natural (biological sealing - child gets sealed to their biological parents)
- PrivateNotes
- PublicNotes
- Non-Marital Temple Rites
- ID
- PlaceID
- Date
- PersonID (Person undergoing rite)
- Type (enum)
- Washing and Annointing (may be split into Washing, Annointing, and Blessing)
- Endowment
- Second Annointing
- AnnointedToID (For second annointing, the person is annointed to someone else, usually husband)
- CopyOfBlessing (boolean of whether a copy of the blessing is available)
- PrivateNotes
- PublicNotes
- Non-Marital Temple Rites Officiators
- Non-Marital Temple Rite ID (which rite were they officiating)
- PersonID (ID of officiator)
- Role (What role did they play in the rite)
- PrivateNotes
- PublicNotes
- Places
- ID
- Building/Street Address
- Town/City
- State
- Zip (if available)
- Latitude
- Longitude
- PrivateNotes
- PublicNotes
- Mission (did not finish discussing this)
- Date
- PlaceID
- PersonID
- CompanionID (person who went with them… should they be linked in another way?)