Table creation and Field order

[wmunsell]

Curious to know where exactly in the code, the tables and fields are being created? I assume that the order of fields within the application UI is the same as the order of the fields within the database. my thought is that if i reorder the fields within the database, the order will be reflected within the UI.

my ultimate goal is to reorder the fields within the UI. if this can be achieved using a different methodology, I'm all ears. in the example screen shot, i would like to have purchase date come before expiration date.