inv.item_categories
| Documentation | Inventory |
| Schema | inv |
| Name | item_categories |
| Module | Inventory |
List of item categories
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | item_category_id | int | Item category ID | |||||
| Item category ID |
||||||||
| 2 | category_name | nvarchar(50) | Item category name | |||||
| Item category name |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.items | inv.item_categories | inv.items.category_id = inv.item_categories.item_category_id | FK_items_item_categories |
|
|
inv.items.category_id = inv.item_categories.item_category_id Name: FK_items_item_categories |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_item_categories | item_category_id | ||
Used by
| Name |
|---|
|
inv.item_categories
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31