Discussion

1. Paper submission to DHF2014
   • Travel
   • Deadlines, paper info
2. Importing data into DB
   • Jill’s Marriage/Person data completed
   • Looking at Joseph’s Excel sheet. Will need some more work to convert.
     • Do we want to develop a front-end to the DB? Is there an automated way to do this?
   • Importing XML from Brown book
3. Temporal Data Structures & Measures
4. Bright Monday letter?

To Do

1. Add many changes to the database
   • Join table of person to marriage (M0)
     • PersonID
     • MarriageID
     • Role
       • husband
       • wife
       • proxyHusband
       • proxyWife
       • officiator
     • Root marriage?
   • Occupation table
     • ID
     • Name/Description
   • Occupation Join
     • PersonID
     • OccupationID
     • StartDate
     • EndDate
   • Add role to ChurchOrgMembership
   • More join tables based on people!
2. Where are we getting the occupation/property info? With the marriages?
3. Document the sematics of the database tables with a sentence or two
   • Table Name, brief description, list of fields and description
   • Look for auto generator based on schema of database
4. For Joseph’s Spreadsheet
   • Get the list and stick in the AQ (mine for just AQ)
     • Add to join table and QL
     • Display list of AQ in a page
   • Grab these from the DB:
     • Show our columns from Jill’s data and his columns next to each other for quality check and assurance
5. Think:
   • Ways to get a working set of data we’re interested in
     • Separate database?
     • SQL Views! Look into them in PGSql. Can they be edited?
   • People, M0, M1, M2 marriages, church orgs
     • “shopping carts”

Notes

1. Levels of marriages
   • M0 = 2 person marriage
   • M1 = group marriage, consisting of a few M0 marriages
   • M2 = tribe
   • …