I am in a small city and we now have to have some mechanism to account for our signs - all signs in the city control.

So.... I have tried to figure out a design schema, but am getting frustrated that I can't seem to get it even close.

What we need to do is

  • account for each sign
    • what type
    • when purchased
    • who purchased from
    • cost of sign
    • type of facing (new or refurb)

    • account for where and when it was put in the field
    • date installed
    • post installed on
    • location of installation
    • direction sign in facing
    • GPS coordinates
    • date removed (make it inactive?? or ??)