Footprints Data Model |
Table |
Name | sys_component |
Comment |
A lookup table for System Component. System Component is used to identify an area of the system. The primary use is when a component is updating system information with a transaction that is not initiated from a customer or agent. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
sys_component_id | int |
The unique identifier for an instance of System Component. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. |
Yes | No |
sys_component_name | varchar(255) | The name of the System Component. | No | No |
sys_component_descr | varchar(512) |
A descriptive name of the System Component. This descriptive name may be localized. |
No | No |