Data Dictionary
>
FPSBASE Tables
> FPSBASE.GEN_COLORS
Table FPSBASE.GEN_COLORS"
List of the 140 standard HTML CSS colors. We use only these 140 standard colors in FPS applications.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Referenced by: FPSADMIN.EQP_MNT_SCHED_STATUSES (COLOR) FPSADMIN.ETP_L1_OPERATIONAL_STATES (COLOR) FPSADMIN.THP_IGNORE_REASONS (COLOR) FPSADMIN.WIP_DELTA_TYPES (COLOR) FPSADMIN.WIP_MOVE_TYPES (COLOR) FPSADMIN.WIP_PROCESS_STATES (COLOR) FPSAPP.DASH_G_GANTT_LEGEND_ITEMS (COLOR) FPSAPP.SCH_G_SCHED_STATES (COLOR) FPSBASE.MSO_RULE_CLASSES (COLOR) FPSINPUT.EQP_PORT_MODES (COLOR) FPSINPUT.GEN_CUSTOMERS (COLOR) FPSINPUT.RTG_DURABLE_STATES (COLOR) FPSINPUT.WIP_HOLD_GROUPS (COLOR) FPSINPUT.WIP_LOT_GROUPS (COLOR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
COLOR |
VARCHAR2(24) |
The HTML CSS color name used in various FPSADMIN, FPSINPUT, and FPSAPP C and G tables to associate a color with a field. Usually the column name is bg_color. Each of these columns has a foreign key referencing GEN_COLORS which enforces that this must be one of the 140 standard HTML CSS color names. |
|
|
COLOR_FAMILY |
VARCHAR2(6) |
N |
The color family from HTML CSS standards which is one of ten basic colors. |
|
HEX_CODE |
VARCHAR2(7) |
N |
The hex code has the format of # then six hexadecimal characters. |