[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_ROADSEGM_PLACES_WM |
---|---|
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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_WM;
CSF.CSF_LF_ROADSEGM_PLACES_WM does not reference any database object
CSF.CSF_LF_ROADSEGM_PLACES_WM is referenced by following:
|
|
|