Table: ITG_SETTINGS_CONTAINERS
Name Null? Type
-------------------------------- -------- --------------------------------------------
SETTINGS_CONTAINER_ID NOT NULL NUMBER(19)
VERSION NOT NULL NUMBER(19)
CONTAINER_KEY_HASH NOT NULL VARCHAR2(32 CHAR)
KEY_ATTRIBUTE_ID NUMBER(19)
PARENT_CONTAINER_ID NUMBER(19)
SOURCE VARCHAR2(255 CHAR)
SOURCE_TYPE_CODE VARCHAR2(255 CHAR)
CREATED_BY NOT NULL NUMBER(19)
CREATION_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(19)
LAST_UPDATE_DATE NOT NULL DATE
Table: PPM.ITG_SETTINGS_ATTRIBUTES
Name Null? Type
----------------------------------- -------- --------------------------------------------
SETTINGS_ATTRIBUTE_ID NOT NULL NUMBER(19)
VERSION NOT NULL NUMBER(19)
NAME NOT NULL VARCHAR2(255 CHAR)
CLASSTYPE VARCHAR2(200 CHAR)
VALUE VARCHAR2(3999 CHAR)
SOURCE VARCHAR2(255 CHAR)
SOURCE_TYPE_CODE VARCHAR2(255 CHAR)
CREATED_BY NOT NULL NUMBER(19)
CREATION_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(19)
LAST_UPDATE_DATE NOT NULL DATE
les contraintes des tables sont:
__________________________
TABLE: ITG_SETTINGS_ATTRIBUTES
SYS_C00277758 ENABLED C SETTINGS_ATTRIBUTE_ID
SYS_C00277759 ENABLED C VERSION
SYS_C00277760 ENABLED C NAME
SYS_C00277761 ENABLED C CREATED_BY
SYS_C00277762 ENABLED C CREATION_DATE
SYS_C00277763 ENABLED C LAST_UPDATED_BY
SYS_C00277764 ENABLED C LAST_UPDATE_DATE
SYS_C00278765 ENABLED P SETTINGS_ATTRIBUTE_ID 1
-------------------------------------------------------------------------
TABLE: ITG_SETTINGS_CONTAINERS
SYS_C00277765 ENABLED C SETTINGS_CONTAINER_ID
SYS_C00277766 ENABLED C VERSION
SYS_C00277767 ENABLED C CONTAINER_KEY_HASH
SYS_C00277768 ENABLED C CREATED_BY
SYS_C00277769 ENABLED C CREATION_DATE
SYS_C00277770 ENABLED C LAST_UPDATED_BY
SYS_C00277771 ENABLED C LAST_UPDATE_DATE
SYS_C00278766 ENABLED P SETTINGS_CONTAINER_ID 1
FKBB09B98B25A0E939 ENABLED R PARENT_CONTAINER_ID 1
FKBB09B98BC6590244 DISABLED R KEY_ATTRIBUTE_ID 1
SYS_C00278767 ENABLED U CONTAINER_KEY_HASH 1
Partager