View shrdb.LAWFS.EFSDOCPROPSVIEW 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  √  null
DOCNAME nvarchar2 256  √  null
DOCTYPE number 22  √  null
ISDELETED number 22  √  null
PROPNAME nvarchar2 256
PROPVALUE nvarchar2 1500
PROPDESCRIPT nvarchar2 1500  √  null
PROPCANEDIT number 22

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT EFSDOCUMENTS.DOCID, EFSDOCUMENTS.OWNERID, EFSDELIVERYUSERS.OWNER_NAME, EFSDOCUMENTS.DOCNAME, EFSDOCUMENTS.DOCTYPE, 0 ISDELETED, EFSDOCPROPS.PROPNAME, EFSDOCPROPS.PROPVALUE, EFSDOCPROPS.PROPDESCRIPT, EFSDOCPROPS.PROPCANEDIT FROM EFSDOCPROPS LEFT OUTER JOIN EFSDOCUMENTS ON (EFSDOCUMENTS.DOCID = EFSDOCPROPS.DOCID) LEFT OUTER JOIN EFSDELIVERYUSERS ON (EFSDOCUMENTS.OWNERID = EFSDELIVERYUSERS.OWNERID)
 
Possibly Referenced Tables/Views:
EFSDELIVERYUSERS EFSDOCPROPS EFSDOCUMENTS 


Close relationships: