Schema for COOL database "oracle://devdb10;schema=lcg_cool;dbname=COOL_REF"


SQL*Plus Report

TABLES


TABLE_NAME
COOL_REF_DB_ATTRIBUTES
COOL_REF_NODES
COOL_REF_NODES_SEQ
COOL_REF_TAGS
COOL_REF_F0002_IOVS
COOL_REF_F0002_IOVS_SEQ
COOL_REF_F0003_IOVS
COOL_REF_F0003_IOVS_SEQ
COOL_REF_F0003_TAGS
COOL_REF_F0003_TAGS_SEQ
COOL_REF_F0003_IOV2TAG


INDEXES


TABLE_NAME INDEX_NAME UNIQUENES
COOL_REF_DB_ATTRIBUTES COOL_REF_DB_ATTRIBUTES_PK UNIQUE
COOL_REF_NODES COOL_REF_NODES_PATH_UK UNIQUE
COOL_REF_NODES COOL_REF_NODES_PK UNIQUE
COOL_REF_NODES_SEQ COOL_REF_NODES_SEQ_PK UNIQUE
COOL_REF_TAGS COOL_REF_TAGS_PK UNIQUE
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CO_2INDX NONUNIQUE
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CSU_3INDX NONUNIQUE
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_PK UNIQUE
COOL_REF_F0002_IOVS_SEQ COOL_REF_F0002_IOVS_SEQ_PK UNIQUE
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CO_2INDX NONUNIQUE
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CSU_3INDX NONUNIQUE
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_OCSU_4INDX UNIQUE
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_PK UNIQUE
COOL_REF_F0003_IOVS_SEQ COOL_REF_F0003_IOVS_SEQ_PK UNIQUE
COOL_REF_F0003_TAGS COOL_REF_F0003_TAGS_NAME_UK UNIQUE
COOL_REF_F0003_TAGS COOL_REF_F0003_TAGS_PK UNIQUE
COOL_REF_F0003_TAGS_SEQ COOL_REF_F0003_TAGS_SEQ_PK UNIQUE
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_4INDX NONUNIQUE
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_PK UNIQUE


CONSTRAINTS


TABLE_NAME CONSTRAINT_NAME TYPE R_CONSTRAINT_NAME INDEX_NAME
COOL_REF_DB_ATTRIBUTES COOL_REF_DB_ATTRIBUTES_PK P   COOL_REF_DB_ATTRIBUTES_PK
COOL_REF_NODES COOL_REF_NODES_PK P   COOL_REF_NODES_PK
COOL_REF_NODES_SEQ COOL_REF_NODES_SEQ_PK P   COOL_REF_NODES_SEQ_PK
COOL_REF_TAGS COOL_REF_TAGS_PK P   COOL_REF_TAGS_PK
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_PK P   COOL_REF_F0002_IOVS_PK
COOL_REF_F0002_IOVS_SEQ COOL_REF_F0002_IOVS_SEQ_PK P   COOL_REF_F0002_IOVS_SEQ_PK
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_PK P   COOL_REF_F0003_IOVS_PK
COOL_REF_F0003_IOVS_SEQ COOL_REF_F0003_IOVS_SEQ_PK P   COOL_REF_F0003_IOVS_SEQ_PK
COOL_REF_F0003_TAGS COOL_REF_F0003_TAGS_PK P   COOL_REF_F0003_TAGS_PK
COOL_REF_F0003_TAGS_SEQ COOL_REF_F0003_TAGS_SEQ_PK P   COOL_REF_F0003_TAGS_SEQ_PK
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_PK P   COOL_REF_F0003_IOV2TAG_PK
COOL_REF_NODES COOL_REF_NODES_PARENT_FK R COOL_REF_NODES_PK  
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_O_FK R COOL_REF_F0003_IOVS_PK  
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_T_FK R COOL_REF_F0003_TAGS_PK  


INDEXED COLUMNS


TABLE_NAME INDEX_NAME COL_NAME COL_POS DESC
COOL_REF_DB_ATTRIBUTES COOL_REF_DB_ATTRIBUTES_PK DB_ATTRIBUTE_NAME 1 ASC
COOL_REF_NODES COOL_REF_NODES_PATH_UK NODE_FULLPATH 1 ASC
COOL_REF_NODES COOL_REF_NODES_PK NODE_ID 1 ASC
COOL_REF_NODES_SEQ COOL_REF_NODES_SEQ_PK SEQUENCE_NAME 1 ASC
COOL_REF_TAGS COOL_REF_TAGS_PK TAG_ID 1 ASC
COOL_REF_TAGS COOL_REF_TAGS_PK NODE_ID 2 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CO_2INDX CHANNEL_ID 1 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CO_2INDX OBJECT_ID 2 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CSU_3INDX CHANNEL_ID 1 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CSU_3INDX IOV_SINCE 2 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_CSU_3INDX IOV_UNTIL 3 ASC
COOL_REF_F0002_IOVS COOL_REF_F0002_IOVS_PK OBJECT_ID 1 ASC
COOL_REF_F0002_IOVS_SEQ COOL_REF_F0002_IOVS_SEQ_PK SEQUENCE_NAME 1 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CO_2INDX CHANNEL_ID 1 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CO_2INDX OBJECT_ID 2 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CSU_3INDX CHANNEL_ID 1 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CSU_3INDX IOV_SINCE 2 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_CSU_3INDX IOV_UNTIL 3 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_OCSU_4INDX OBJECT_ID 1 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_OCSU_4INDX CHANNEL_ID 2 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_OCSU_4INDX IOV_SINCE 3 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_OCSU_4INDX IOV_UNTIL 4 ASC
COOL_REF_F0003_IOVS COOL_REF_F0003_IOVS_PK OBJECT_ID 1 ASC
COOL_REF_F0003_IOVS_SEQ COOL_REF_F0003_IOVS_SEQ_PK SEQUENCE_NAME 1 ASC
COOL_REF_F0003_TAGS COOL_REF_F0003_TAGS_NAME_UK TAG_NAME 1 ASC
COOL_REF_F0003_TAGS COOL_REF_F0003_TAGS_PK TAG_ID 1 ASC
COOL_REF_F0003_TAGS_SEQ COOL_REF_F0003_TAGS_SEQ_PK SEQUENCE_NAME 1 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_4INDX TAG_ID 1 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_4INDX CHANNEL_ID 2 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_4INDX IOV_SINCE 3 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_4INDX IOV_UNTIL 4 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_PK TAG_ID 1 ASC
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_PK OBJECT_ID 2 ASC


FOREIGN KEY COLUMNS


TABLE_NAME CONSTRAINT_NAME R_CONSTRAINT_NAME COL_NAME COL_POS R_COL_NAME R_COL_POS
COOL_REF_NODES COOL_REF_NODES_PARENT_FK COOL_REF_NODES_PK NODE_PARENTID 1 NODE_ID 1
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_O_FK COOL_REF_F0003_IOVS_PK OBJECT_ID 1 OBJECT_ID 1
COOL_REF_F0003_IOV2TAG COOL_REF_F0003_IOV2TAG_T_FK COOL_REF_F0003_TAGS_PK TAG_ID 1 TAG_ID 1





SQL*Plus Report

TABLE COOL_REF_DB_ATTRIBUTES


Name Null? Type
DB_ATTRIBUTE_NAME NOT NULL VARCHAR2(255)
DB_ATTRIBUTE_VALUE   VARCHAR2(4000)

SQL*Plus Report

TABLE COOL_REF_NODES


Name Null? Type
NODE_ID NOT NULL NUMBER(10)
NODE_PARENTID   NUMBER(10)
NODE_NAME   VARCHAR2(255)
NODE_FULLPATH   VARCHAR2(255)
NODE_DESCRIPTION   VARCHAR2(255)
NODE_ISLEAF   NUMBER(1)
NODE_INSTIME   VARCHAR2(255)
FOLDER_PAYLOADSPEC   VARCHAR2(4000)
FOLDER_VERSIONING   NUMBER(10)
FOLDER_IOVTABLENAME   VARCHAR2(255)
FOLDER_TAGTABLENAME   VARCHAR2(255)
FOLDER_IOV2TAGTABLENAME   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_NODES_SEQ


Name Null? Type
SEQUENCE_NAME NOT NULL VARCHAR2(255)
CURRENT_VALUE   NUMBER(10)
LASTMOD_DATE   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_TAGS


Name Null? Type
TAG_ID NOT NULL NUMBER(10)
NODE_ID NOT NULL NUMBER(10)
TAG_NAME   VARCHAR2(255)
TAG_DESCRIPTION   VARCHAR2(255)
SYS_INSTIME   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_F0002_IOVS


Name Null? Type
OBJECT_ID NOT NULL NUMBER(10)
CHANNEL_ID   NUMBER(10)
IOV_SINCE   NUMBER(20)
IOV_UNTIL   NUMBER(20)
SYS_INSTIME   VARCHAR2(255)
ORIGINAL_ID   NUMBER(10)
NEW_HEAD_ID   NUMBER(10)
A_BOOL   NUMBER(1)
A_SHRT   NUMBER(5)
A_USHRT   NUMBER(5)
A_INT   NUMBER(10)
A_UINT   NUMBER(10)
A_LONG   NUMBER(10)
A_ULONG   NUMBER(10)
A_ULONGLONG   NUMBER(20)
A_FLOAT   BINARY_FLOAT
A_DOUBLE   BINARY_DOUBLE
A_STRING   VARCHAR2(4000)

SQL*Plus Report

TABLE COOL_REF_F0002_IOVS_SEQ


Name Null? Type
SEQUENCE_NAME NOT NULL VARCHAR2(255)
CURRENT_VALUE   NUMBER(10)
LASTMOD_DATE   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_F0003_IOVS


Name Null? Type
OBJECT_ID NOT NULL NUMBER(10)
CHANNEL_ID   NUMBER(10)
IOV_SINCE   NUMBER(20)
IOV_UNTIL   NUMBER(20)
SYS_INSTIME   VARCHAR2(255)
ORIGINAL_ID   NUMBER(10)
NEW_HEAD_ID   NUMBER(10)
A_BOOL   NUMBER(1)
A_SHRT   NUMBER(5)
A_USHRT   NUMBER(5)
A_INT   NUMBER(10)
A_UINT   NUMBER(10)
A_LONG   NUMBER(10)
A_ULONG   NUMBER(10)
A_ULONGLONG   NUMBER(20)
A_FLOAT   BINARY_FLOAT
A_DOUBLE   BINARY_DOUBLE
A_STRING   VARCHAR2(4000)

SQL*Plus Report

TABLE COOL_REF_F0003_IOVS_SEQ


Name Null? Type
SEQUENCE_NAME NOT NULL VARCHAR2(255)
CURRENT_VALUE   NUMBER(10)
LASTMOD_DATE   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_F0003_TAGS


Name Null? Type
TAG_ID NOT NULL NUMBER(10)
TAG_NAME   VARCHAR2(255)
TAG_DESCRIPTION   VARCHAR2(255)
SYS_INSTIME   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_F0003_TAGS_SEQ


Name Null? Type
SEQUENCE_NAME NOT NULL VARCHAR2(255)
CURRENT_VALUE   NUMBER(10)
LASTMOD_DATE   VARCHAR2(255)

SQL*Plus Report

TABLE COOL_REF_F0003_IOV2TAG


Name Null? Type
TAG_ID NOT NULL NUMBER(10)
OBJECT_ID NOT NULL NUMBER(10)
CHANNEL_ID   NUMBER(10)
IOV_SINCE   NUMBER(20)
IOV_UNTIL   NUMBER(20)
SYS_INSTIME   VARCHAR2(255)