Metal: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Operations: | Operations for pages: | ||
#login | #login | ||
#add transport container (only admin) | #add transport container (only admin) | ||
#add price list (only admin) | #add price list (only admin) | ||
#add | #add metal_type (only admin) | ||
#add inventory (user and up) | #add inventory (user and up) | ||
#add user (admin priv) | #add user (admin priv) | ||
| Line 10: | Line 10: | ||
#add tax info (only admin) | #add tax info (only admin) | ||
#view inventory (user and default page) | #view inventory (user and default page) | ||
#other imports to populate tables --text file imports | |||
| Line 18: | Line 18: | ||
Inv_id number -- PK | Inv_id number -- PK | ||
Metal_id number -- fk to metal_type | Metal_id number -- fk to metal_type | ||
Weight number -- material transported weight | |||
price_id number -- fk to price_list | price_id number -- fk to price_list | ||
trans_id number -- fk to transport_container | trans_id number -- fk to transport_container | ||
tax_id number -- fk to tax_info | |||
user_id_last_mod number -- fk to users | user_id_last_mod number -- fk to users | ||
time_stamp date -- last edit date | time_stamp date -- last edit date | ||
| Line 36: | Line 38: | ||
Tax_info | Tax_info | ||
tax_id number --PK | tax_id number -- PK | ||
tax_calc number -- tax rate | tax_calc number -- tax rate | ||
Revision as of 21:34, 26 September 2014
Operations for pages:
- 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)
- other imports to populate tables --text file imports
table design:
Inventory
Inv_id number -- PK Metal_id number -- fk to metal_type Weight number -- material transported weight price_id number -- fk to price_list trans_id number -- fk to transport_container tax_id number -- fk to tax_info 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