View shrdb.LAWFS.EFSDEVICESVIEW 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
ADDRESS nvarchar2 2000
STATUS number 22
ISLOGICAL number 22
DEVICETYPE number 22
DEVICETYPE_NAME nvarchar2 256  √  null
MEDIUM nvarchar2 256  √  null
DEVICETYPE_DELETED number 22  √  null
NEXTDEVICE_ID number 22  √  null
NEXTDEVICE nvarchar2 256  √  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, EFSDEVICES.ADDRESS, EFSDEVICES.STATUS, EFSDEVICES.ISLOGICAL, EFSDEVICES.DEVICETYPE, EFSDEVICETYPESVIEW.DOCNAME DEVICETYPE_NAME, EFSDEVICETYPESVIEW.MEDIUM, EFSDEVICETYPESVIEW.ISDELETED DEVICETYPE_DELETED, EFSDEVICES.NEXTDEVICE NEXTDEVICE_ID, NEXTDEVICE.DOCNAME NEXTDEVICE FROM EFSDELIVERYUSERS, EFSDEVICES LEFT OUTER JOIN EFSDOCUMENTS ON EFSDOCUMENTS.DOCID = EFSDEVICES.DOCID LEFT OUTER JOIN EFSDEVICETYPESVIEW ON EFSDEVICES.DEVICETYPE = EFSDEVICETYPESVIEW.DOCID LEFT OUTER JOIN EFSDOCUMENTS NEXTDEVICE ON ( (NEXTDEVICE.OWNERID = EFSDOCUMENTS.OWNERID) AND (NEXTDEVICE.DOCTYPE = 2) AND (NEXTDEVICE.DOCID = EFSDEVICES.NEXTDEVICE)) WHERE ( EFSDOCUMENTS.DOCTYPE = 2 ) AND ( EFSDOCUMENTS.OWNERID = EFSDELIVERYUSERS.OWNERID )
 
Possibly Referenced Tables/Views:
EFSDELIVERYUSERS EFSDEVICES EFSDEVICETYPESVIEW EFSDOCUMENTS 


Close relationships: