Previous: item | Unanet Data Model | Next: item_uom_rate |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | item_key | decimal(15) | item | fk_item_uom1 | |
2. | PK | uom_key | decimal(15) | unit_of_measure | fk_item_uom2 |
Column | References | Foreign Key Name | |
Table | Column | ||
item_key | item | item_key | fk_item_uom1 |
uom_key | unit_of_measure | uom_key | fk_item_uom2 |
Table | Column | Foreign Key Name |
item_uom_rate | item_key | fk_item_uom_rate1 |
uom_key | ||
project_item_uom_rate | item_key | fk_project_item_uom_rate2 |
uom_key |
Index Name | Unique | Column Name | Asc Or Desc |
pk_item_uom | true | item_key | Asc |
uom_key |