|
|
| Line 2: |
Line 2: |
| [[Metal: Operations For Pages]] | | [[Metal: Operations For Pages]] |
|
| |
|
| table design:
| | [[Metal: 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
| |
| 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
| |