DBA Data[Home] [Help] [Dependency Information]

TABLE: CSF.CSF_TDS_ROUTE_TO_BE_CALCULATED

Object Details
Object Name: CSF_TDS_ROUTE_TO_BE_CALCULATED
Object Type: TABLE
Owner: CSF
Subobject Name:
Status: VALID


Cache calculated routes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SEGMENT_ID_FROM NUMBER
Yes Segment from defines the start segment from this route.
SIDE_FROM VARCHAR2 (1) Yes Side from defines which road-side the route starts from.
SPOT_FROM VARCHAR2 (3) Yes Spot from defines the spot on the segment from which this route starts.
SRID_FROM NUMBER

The srid for from segment.
LATITUDE_FROM NUMBER

The latitude of source
LONGITUDE_FROM NUMBER

The longitude of source
SEGMENT_ID_TO NUMBER
Yes Segment to defines the end segment for this route.
SIDE_TO VARCHAR2 (1) Yes Side to defines which road-side the route ends.
SPOT_TO VARCHAR2 (3) Yes Spot to defines the spot on the segment where this route ends.
SRID_TO NUMBER

The srid for to segment.
LATITUDE_TO NUMBER

The latitude of destination
LONGITUDE_TO NUMBER

The longitude of destination
USER_ID NUMBER
Yes The user id
FROM_TILE_ID NUMBER
Yes The tile id of the from segment
TO_TILE_ID NUMBER
Yes The tile id of the to segment
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEGMENT_ID_FROM
,      SIDE_FROM
,      SPOT_FROM
,      SRID_FROM
,      LATITUDE_FROM
,      LONGITUDE_FROM
,      SEGMENT_ID_TO
,      SIDE_TO
,      SPOT_TO
,      SRID_TO
,      LATITUDE_TO
,      LONGITUDE_TO
,      USER_ID
,      FROM_TILE_ID
,      TO_TILE_ID
FROM CSF.CSF_TDS_ROUTE_TO_BE_CALCULATED;

Dependencies

[top of page]

CSF.CSF_TDS_ROUTE_TO_BE_CALCULATED does not reference any database object

CSF.CSF_TDS_ROUTE_TO_BE_CALCULATED is referenced by following:

SchemaAPPS
SynonymCSF_TDS_ROUTE_TO_BE_CALCULATED