View ESEC.ESECDBA.ATTACHMENTS_RPT_V 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
ATTACHMENT_ID number 22
ATTACHMENTS.ATTACHMENT_ID Implied Constraint
NAME varchar2 765  √  null
SOURCE_REFERENCE varchar2 192  √  null
TYPE varchar2 96  √  null
SUB_TYPE varchar2 96  √  null
FILE_EXTENSION varchar2 96  √  null
ATTACHMENT_DESCRIPTION varchar2 765  √  null
DATA clob 4000  √  null
DATE_CREATED date 7
DATE_MODIFIED date 7
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT ATTACHMENTS.ATTACHMENT_ID, ATTACHMENTS.NAME, ATTACHMENTS.SRC_REF, ATTACHMENTS.TYP, ATTACHMENTS.SUB_TYP, ATTACHMENTS.FILE_EXT, ATTACHMENTS.ATTACHMENT_DESC, ATTACHMENTS.DATA, ATTACHMENTS.DATE_CREATED, ATTACHMENTS.DATE_MODIFIED, ATTACHMENTS.CREATED_BY, ATTACHMENTS.MODIFIED_BY
FROM ATTACHMENTS

Close relationships: