Data Dictionary
>
FPSBASE Tables
> FPSBASE.RTG_PATH_PRDS
Table FPSBASE.RTG_PATH_PRDS"
See comments in RTG_REF_PATH_PRDS view.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: START_FACILITY, START_PRD, CURRENT_FACILITY, CURRENT_PRD, DEST_FACILITY, DEST_PRD
-
Foreign keys: RTG_PATH_PRDS_FK_DEST_FAC: DEST_FACILITY REFERENCES FPSINPUT.GEN_FACILITIES (FACILITY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_FACILITY |
VARCHAR2(6) |
N |
|
|
START_PRD |
VARCHAR2(64) |
N |
|
|
CURRENT_FACILITY |
VARCHAR2(6) |
N |
|
|
CURRENT_PRD |
VARCHAR2(64) |
N |
|
|
DEST_FACILITY |
VARCHAR2(6) |
N |
Facility where the lot will go after it completes its route in the current facility. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT) |