Metal: Difference between revisions
(Created page with " Table design: Inventory Inv_id number -- PK Metal_id number -- fk to metal_type price_id number -- fk to price_list trans_id n...") |
No edit summary |
||
| Line 1: | Line 1: | ||
table design: | |||
Inventory | Inventory | ||
Inv_id number -- PK | Inv_id number -- PK | ||
| Line 10: | Line 11: | ||
Metal_type | Metal_type | ||
Metal_id | Metal_id number -- PK | ||
Metal | Metal string -- Metal_name | ||
Price_list | Price_list | ||
price_id | price_id number -- PK | ||
value | value number --maybe based on penny or something...might string it depending | ||
Transport_container | Transport_container | ||
trans_id | trans_id number -- PK | ||
trans_name | trans_name string | ||
Users | Users | ||
user_id | user_id number -- PK | ||
user_name | user_name string -- username | ||
Lang_id | Lang_id number -- fk language_translate | ||
Language_translate | Language_translate | ||
Lang_id | Lang_id number -- PK | ||
Field_id | Field_id number -- field in page maybe | ||
text_string | text_string string -- text to put in field | ||
Inventory_audit | Inventory_audit | ||
Inv_id number --PK | Inv_id number -- PK | ||
Metal_id number -- fk to metal_type | Metal_id number -- fk to metal_type | ||
price_id number -- fk to price_list | price_id number -- fk to price_list | ||
Revision as of 21:13, 26 September 2014
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
Users
user_id number -- PK user_name string -- username Lang_id number -- fk language_translate
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