Data Dictionary
>
FPSBASE Tables
> FPSBASE.MNT_TECHNICIANS
Table FPSBASE.MNT_TECHNICIANS"
Maintenance technicians who can perform event_id they have the certifications for.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: MNT_TECH_USERNAME
-
Foreign keys: MNT_TECHNICIANS_FK_USER: MNT_TECH_USERNAME REFERENCES FPSINPUT.GEN_USERS (USERNAME)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_TECH_USERNAME |
VARCHAR2(64) |
N |
The unique identifier of a technician that also needs to exist in GEN_USERS. |
|
BURDEN_RATE |
NUMBER(12,2) |
Priority of the technician if a priority wants to be provided. |