ListMaker Project

On entry to system:


Web Pages

Page "Log in":

Username: ____________
Password: ____________

[New User?] [Login] [Close]

Page "Item Entry":

Entry: __________________
Category: [drop-down list with last entry saved] [View This Category]
(ideally drop-down list will include # of entries, e.g. "Books to buy (5)")
[Add Item] [New Category] [Close]

Page "View Category":

[Drop down list of categories with 'current' selected] [View]
# table of items in category [edit] [delete]
[Edit Category List]

Page "Admin Categories":

# table of items in category [edit] [delete]
[add new category]


Database Schema

Table users
userIDserial
usernamevarchar
passwordvarchar
emailvarchar
userlevelint
  
Table category
catIDserial
catNamevarchar
userIDvarchar
  
Table item
itemIDserial
itemNamevarchar
catIDint
  
Table auxInfo
auxIDserial
keyvarchar
valuevarchar
  
Table auxMapping
auxMapIDserial
itemIDint
auxIDint



Cookies


Page Template