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