[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_ROADSEGM_PLACES |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_LF_ROADSEGM_PLACES |
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
Tablespace: | APPS_TS_MEDIA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000083008C00011$$ | LOB | UNIQUE | APPS_TS_MEDIA | |
SYS_IL0000083008C00012$$ | LOB | UNIQUE | APPS_TS_MEDIA |
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 |
ROAD_CENTROID | SDO_GEOMETRY | (1) | ||
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
Cut, paste (and edit) the following text to query this object:
SELECT ROADSEGM_PLACE_ID
, PLACE_SIDE
, ROADSEGMENT_ID
, PLACE_ID
, ROAD_CENTROID
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_ROADSEGM_PLACES;
|
|
|