[Home] [Help] [Dependency Information]
Object Name: | CSF_TDS_SEGM_NODES_WM |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
Intersection table required since one Node can be part of multiple segments and one Segment is composed of two node.
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT_NODE_ID | NUMBER | (30) | Yes | Unique identifier for Segment Node table |
SEGM_NODE_TYPE | NUMBER | (1) | Yes | Defines wether a node Starting = 0 or Ending = 1 |
NODE_ID | NUMBER | (30) | Yes | The TDS NODE ID defines the unique identifier of the entity. |
SEGMENT_ID | NUMBER | (30) | Yes | Unique identifier to segment |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_NODE_ID
, SEGM_NODE_TYPE
, NODE_ID
, SEGMENT_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_TDS_SEGM_NODES_WM;
CSF.CSF_TDS_SEGM_NODES_WM does not reference any database object
CSF.CSF_TDS_SEGM_NODES_WM is referenced by following:
|
|
|