Metal: Difference between revisions
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
Operations: | Operations: | ||
#login | #login | ||
#add transport container | #add transport container (only admin) | ||
#add price list | #add price list (only admin) | ||
#add Metal_type | #add Metal_type (only admin) | ||
#add inventory | #add inventory (user and up) | ||
#add user (admin priv) | #add user (admin priv) | ||
#view audit (only admin) -- need to think about paging and/or limits | #view audit (only admin) -- need to think about paging and/or limits | ||
#add tax info (only admin) | |||
#view inventory (user and default page) | |||
| Line 30: | Line 33: | ||
Transport_container | Transport_container | ||
trans_id number -- PK | trans_id number -- PK | ||
trans_name string | trans_name string -- trans name,crew | ||
Tax_info | |||
tax_id number --PK | |||
tax_calc number -- tax rate | |||
Users | Users | ||
Revision as of 21:27, 26 September 2014
Operations:
- login
- add transport container (only admin)
- add price list (only admin)
- add Metal_type (only admin)
- add inventory (user and up)
- add user (admin priv)
- view audit (only admin) -- need to think about paging and/or limits
- add tax info (only admin)
- view inventory (user and default page)
table design:
Inventory
Inv_id number -- PK Metal_id number -- fk to metal_type price_id number -- fk to price_list trans_id number -- fk to transport_container user_id_last_mod number -- fk to users time_stamp date -- last edit date
Metal_type
Metal_id number -- PK Metal string -- Metal_name
Price_list
price_id number -- PK value number --maybe based on penny or something...might string it depending
Transport_container
trans_id number -- PK trans_name string -- trans name,crew
Tax_info
tax_id number --PK tax_calc number -- tax rate
Users
user_id number -- PK user_name string -- username Lang_id number -- fk language_translate
User_priv
uniq_id number -- PK priv_level number -- 1 admin, 2 user user_id number -- fk users
Language_translate
Lang_id number -- PK Field_id number -- field in page maybe text_string string -- text to put in field
Inventory_audit
Inv_id number -- PK Metal_id number -- fk to metal_type price_id number -- fk to price_list trans_id number -- fk to transport_container user_id_last_mod number -- fk to users time_edit date -- when entry was updated