Maintenance CycleMaintenance Type
| Business Data Model Data Model |
| Description | The maintenance that is performed on the item master. For example: Removing an item no longer in demand Updating item status |
| Attributes | |
| Maintenance Cycle |
|
| Maintenance Type |
|
| Relationship | |
 Item Maintenance_Item Master_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Maintenance Cycle
| Description | Indicates the maintenance cycle used for the inventory supply item, such as the number of times to sharpen after five uses. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Maintenance Type
| Description | Indicates the type of maintenance performed on the inventory supply item. This is different than the maintenance cycle in the sense that it can describe the number of maintenance cycles that can be performed before disposing of the inventory supply item |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Item Maintenance_Item Master_FK
| Is Identifying Relationship | true |
| Child Table | Item Master Maintenance |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Item Master |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |