fields for ancient greek people and places
Met with LB and LM to discuss how to structure data in excel for eventual use on interactive map
People table, parent field : to be separated into parent-male-mortal, parent-female-mortal, parent-male-god, parent-female-god, parent-male-step, parent-female-step, parent-other; each field can have zero or more values separated by commas;
People table, parent-reference field : to be separated as described above for parent field
Places table
name field is key, identical to the name field in the people table
place-of-birth and place-of-birth-reference fields : zero or one text value
place-of-death and place-of-death-reference fields : zero or one text value
place
and place-reference
fields : one text value each, the places appear in chronological order
Eventually we'll need to create a person-names table so that we can have one canonical spelling and n variant spellings of a person-name. That will be populated manually.
Eventually these will be processed into xml structures.