SchemaSpy Analysis of shrdb.LAWFS - Constraints Generated by
SchemaSpy
24 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
FK_ATTRCAT ENPATTRLIST.ATTRCATEGORY ENPCATEGORIES.CATEGORYID Cascade on delete 
FK_DELIVERYLOG ENPDELIVERYLOG.USERID ENPUSERMAP.USERID Cascade on delete 
FK_EFSDEVICEPREFS1 EFSDEVICEPREFS.DEVICEID EFSDEVICES.DOCID Cascade on delete 
FK_EFSDEVICEPREFS2 EFSDEVICEPREFS.OWNERID EFSDELIVERYUSERS.OWNERID Cascade on delete 
FK_EFSDEVICES1 EFSDEVICES.DOCID EFSDOCUMENTS.DOCID Cascade on delete 
FK_EFSDEVICES2 EFSDEVICES.DEVICETYPE EFSDEVICETYPES.DOCID Cascade on delete 
FK_EFSDEVICETYPES EFSDEVICETYPES.DOCID EFSDOCUMENTS.DOCID Cascade on delete 
FK_EFSDOCPROPS EFSDOCPROPS.DOCID EFSDOCUMENTS.DOCID Cascade on delete 
FK_EFSDOCUMENTS EFSDOCUMENTS.OWNERID EFSDELIVERYUSERS.OWNERID Cascade on delete 
FK_ENPACCBATREE ENPENTRYACCESS.TREEENTRYID ENPBATREE.TREEENTRYID Cascade on delete 
FK_ENPBATREE_PARENT_ID ENPBATREE.ENTRYPARENT ENPBATREE.TREEENTRYID Cascade on delete 
FK_ENPENTACCID ENPENTRYACCESS.ACCESSID ENPUSERMAP.USERID Cascade on delete 
FK_ENPENTACCTYP ENPENTRYACCESS.ACCESSTYPEID ENPENTRYACCESSTYPES.ACCESSTYPEID Cascade on delete 
FK_ENPENTRYATTR_ENPATTRLIST ENPENTRYATTR.ATTRCATEGORY
ENPENTRYATTR.ATTRID
ENPATTRLIST.ATTRCATEGORY
ENPATTRLIST.ATTRID
Cascade on delete 
FK_ENPENTRYATTR_ENPBATREE ENPENTRYATTR.TREEENTRYID ENPBATREE.TREEENTRYID Cascade on delete 
FK_ENPREFERENCES1 ENPREFERENCES.TREEENTRYID ENPBATREE.TREEENTRYID Cascade on delete 
FK_ENPREFERENCES2 ENPREFERENCES.REFERENCEID ENPBATREE.TREEENTRYID Cascade on delete 
FK_ENTRYCAT_ENTRYID ENPBATREE.ENTRYCATEGORY ENPCATEGORIES.CATEGORYID Restrict delete 
FK_LOGSOURCES ENPLOGTABLE.LOGSOURCEID ENPLOGSOURCES.LOGSOURCEID Cascade on delete 
FK_STATSLOGTREE ENPSTATSLOG.TREEENTRYID ENPBATREE.TREEENTRYID Cascade on delete 
FK_STATSLOGTYPE ENPSTATSLOG.STATSTYPE ENPSTATSLOGTYPES.STATSTYPE Cascade on delete 
FK_USERMAP ENPBATREE.ENTRYOWNER ENPUSERMAP.USERID Cascade on delete 
FK_USERMAP1 ENPGROUPMAP.USERID ENPUSERMAP.USERID Cascade on delete 
FK_USERMAP2 ENPGROUPMAP.GROUPID ENPUSERMAP.USERID Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected