Table ESEC.ESECDBA.ESEC_ARCHIVE_LOGS Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ARCH_SEQ varchar2 300
ESEC_ARCHIVE_LOG_FILES.ARCH_SEQ ARCH_LOGS_ARCH_LOG_FILES_FK
TABLE_NAME varchar2 90  √  null
ESEC_PARTITION_CONFIG.TABLE_NAME Implied Constraint
PARTITION_NAME varchar2 150  √  null
SUBPARTITION_NAME varchar2 300  √  null
START_DATE date 7  √  null
END_DATE date 7  √  null
STATUS varchar2 30  √  null
IMPORTED varchar2 24  √  null
IMPORT_TABLE varchar2 90  √  null
VERSION varchar2 15  √  null

Table contained 7,753 rows at Tue May 04 17:09 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
ARCH_SEQ Primary key Asc ESEC_ARCH_LOGS_PK
END_DATE + START_DATE Performance Asc/Asc ESEC_ARCH_LOGS_END_START_IDX
TABLE_NAME Performance Asc ESEC_ARCH_LOGS_TABLE_NAME_IDX

Close relationships: