View shrdb.LAWFS.EFSDEVICETYPESVIEW 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
DOCID number 22  √  null
EFSDEVICETYPES.DOCID Implied Constraint R
OWNERID number 22  √  null
EFSDELIVERYUSERS.OWNERID Implied Constraint R
OWNER_NAME nvarchar2 450
DOCNAME nvarchar2 256  √  null
DOCDESCRIPT nvarchar2 2000  √  null
ISDELETED number 22  √  null
DRIVER nvarchar2 1500
MIME_TYPE nvarchar2 1500
MEDIUM nvarchar2 256
CONFIRMREQ number 22
MAXLEN number 22  √  null
ATTACHMENTS number 22
DEVICES number 22  √  null
DTACCESS number 22
DEFINITION blob 4000  √  null

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT EFSDOCUMENTS.DOCID, EFSDOCUMENTS.OWNERID, EFSDELIVERYUSERS.OWNER_NAME, EFSDOCUMENTS.DOCNAME, EFSDOCUMENTS.DOCDESCRIPT, 0 ISDELETED, EFSDEVICETYPES.DRIVER, EFSDEVICETYPES.MIME_TYPE, EFSDEVICETYPES.MEDIUM, EFSDEVICETYPES.CONFIRMREQ, EFSDEVICETYPES.MAXLEN, EFSDEVICETYPES.ATTACHMENTS, (SELECT COUNT(*) FROM EFSDEVICES WHERE (EFSDEVICES.DEVICETYPE = EFSDOCUMENTS.DOCID)) AS DEVICES, EFSDEVICETYPES.DTACCESS, EFSDEVICETYPES.DEFINITION FROM EFSDELIVERYUSERS, EFSDEVICETYPES LEFT OUTER JOIN EFSDOCUMENTS ON EFSDOCUMENTS.DOCID = EFSDEVICETYPES.DOCID WHERE ( EFSDOCUMENTS.DOCTYPE = 1 ) AND ( EFSDOCUMENTS.OWNERID = EFSDELIVERYUSERS.OWNERID )
 
Possibly Referenced Tables/Views:
EFSDELIVERYUSERS EFSDEVICES EFSDEVICETYPES EFSDOCUMENTS 


Close relationships: