|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
|
| |
|
| Operations for pages: | | [[Metal: 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
| |
| #trip detail
| |
|
| |
|
| table design:
| | [[Metal: Table Design]] |
|
| |
|
| Inventory
| | [[Metal: Development Notes]] |
| 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
| |
| trip_id number -- fk to trip_detail
| |
| 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
| |
| | |
| Trip_detail
| |
| trip_id number -- PK
| |
| trip_detail string -- site to border, border to process, process to border, border to site
| |
| | |
| 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
| |
| 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_edit date -- when entry was updated
| |