On entry to system:
| # | table of items in category | [edit] [delete] |
| # | table of items in category | [edit] [delete] |
| Table users | |
|---|---|
| userID | serial |
| username | varchar |
| password | varchar |
| varchar | |
| userlevel | int |
| Table category | |
| catID | serial |
| catName | varchar |
| userID | varchar |
| Table item | |
| itemID | serial |
| itemName | varchar |
| catID | int/TD |
| Table auxInfo | |
| auxID | serial |
| key | varchar |
| value | varchar |
| Table auxMapping | |
| auxMapID | serial |
| itemID | int |
| auxID | int |