Table ESEC.ESECDBA.ESEC_ARCHIVE_LOGS Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
ARCH_SEQ varchar2 300
ESEC_ARCHIVE_LOG_FILES
TABLE_NAME varchar2 90  √  null
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
ARCH_SEQ Primary key Asc
END_DATE + START_DATE Performance Asc/Asc
TABLE_NAME Performance Asc

Close relationships: