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