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

TABLE: CSF.CSF_LF_ROADSEGM_PLACES_AU

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


DEFINITION
Intersection table required since one Segment can be located in multiple places (e.g. road on admin boundary) and one place contains multiple segments.
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ROADSEGM_PLACE_ID NUMBER (30) Yes Surrogate key used for primary unique identifiers
PLACE_SIDE VARCHAR2 (1)
Specifies side of roadsegment to which Place belongs
ROADSEGMENT_ID NUMBER (30) Yes Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
PLACE_ID NUMBER (30) Yes Unique key that identifies the place
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
Query Text

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


SELECT ROADSEGM_PLACE_ID
,      PLACE_SIDE
,      ROADSEGMENT_ID
,      PLACE_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_LF_ROADSEGM_PLACES_AU;

Dependencies

[top of page]

CSF.CSF_LF_ROADSEGM_PLACES_AU does not reference any database object

CSF.CSF_LF_ROADSEGM_PLACES_AU is referenced by following:

SchemaAPPS
SynonymCSF_LF_ROADSEGM_PLACES_AU