Database scheme for managing people.

database-architecture.json

{
  "postals": {
    "84111": "d257df6d-5fca-70a5-9d7e-a0bab213f7aa"
  },
  "names": {
    "316e37df-71ef-06d6-6606-fc3cfc58e4e4": {
      "first": "John",
      "last": "Smith",
      "person": "940eca25-7bf9-82db-7974-03ed857d1615"
    }
  },
  "dates": {
    "12141991": {
      "person": {
        "deaths": [""],
        "births": ["940eca25-7bf9-82db-7974-03ed857d1615"]
      },
      "callings": {
        "starts": [],
        "ends": []
      }
    },
    "12142001": {
      "person": {
        "deaths": ["940eca25-7bf9-82db-7974-03ed857d1615"],
        "births": [""]
      },
      "callings": {
        "starts": [],
        "ends": []
      }
    }
  },
  "locations": {
    "d257df6d-5fca-70a5-9d7e-a0bab213f7aa": {
      "street1": "123 Ipsum Street",
      "street2": "",
      "state": "7baa8029-5525-8eaa-df44-f6ad2c77bd8e",
      "postal": 84111,
      "country": "9e1c5261-ade3-fbe8-06bc-8aa47f4996a2"
    }
  },
  "callings": {
    "50a1a992-e1d3-44d1-21bb-229878229e94": {
      "name": "Mattis Sollicitudin",
      "people": ["940eca25-7bf9-82db-7974-03ed857d1615"]
    }
  },
  "people": {
    "940eca25-7bf9-82db-7974-03ed857d1615": {
      "name": "316e37df-71ef-06d6-6606-fc3cfc58e4e4",
      "birth": {
        "date": "12141991",
        "location": "d257df6d-5fca-70a5-9d7e-a0bab213f7aa"
      },
      "death": {
        "date": "12142001",
        "location": "d257df6d-5fca-70a5-9d7e-a0bab213f7aa"
      },
      "photo": "my-photo.jpg",
      "bio": "Nullam quis risus eget urna mollis ornare vel eu leo.",
      "callings": ["50a1a992-e1d3-44d1-21bb-229878229e94"]
    }
  }
}