shrdb.LAWFS contains 299 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
ANNOTATION	ANNOTATION	blob	4000	√		null
ANNOTATION	ANNOTATION_GUID	nvarchar2	100
ANNOTATION	ANNOTATION_ID	number	22
ANNOTATION	CREATE_DATE	date	7
ANNOTATION	LAST_UPDATE_DATE	date	7	√		null
ANNOTATION	LAST_UPDATED_BY	nvarchar2	60	√		null
ANNOTATION	MODULE_ID	nvarchar2	100	√		null
ANNOTATION	NODE_ID	nvarchar2	100	√		null
ANNOTATION	TEMPLATE_GUID	nvarchar2	100
ANNOTATION	USER_NAME	nvarchar2	60
DEVICEONLYUSERLIST	USERID	number	22
DEVICEONLYUSERLIST	USERNAME	nvarchar2	250	√		null
EFSDELIVERYUSERS	OWNER_NAME	nvarchar2	450
EFSDELIVERYUSERS	OWNERID	number	22
EFSDEVICEPREFS	DEVICEID	number	22
EFSDEVICEPREFS	MEDIUM	nvarchar2	256
EFSDEVICEPREFS	OWNERID	number	22
EFSDEVICES	ADDRESS	nvarchar2	2000
EFSDEVICES	DEVICETYPE	number	22
EFSDEVICES	DOCID	number	22
EFSDEVICES	ISLOGICAL	number	22			0
EFSDEVICES	NEXTDEVICE	number	22	√		null
EFSDEVICES	STATUS	number	22
EFSDEVICESVIEW	ADDRESS	nvarchar2	2000
EFSDEVICESVIEW	DEVICETYPE	number	22
EFSDEVICESVIEW	DEVICETYPE_DELETED	number	22	√		null
EFSDEVICESVIEW	DEVICETYPE_NAME	nvarchar2	256	√		null
EFSDEVICESVIEW	DOCDESCRIPT	nvarchar2	2000	√		null
EFSDEVICESVIEW	DOCID	number	22	√		null
EFSDEVICESVIEW	DOCNAME	nvarchar2	256	√		null
EFSDEVICESVIEW	ISDELETED	number	22	√		null
EFSDEVICESVIEW	ISLOGICAL	number	22
EFSDEVICESVIEW	MEDIUM	nvarchar2	256	√		null
EFSDEVICESVIEW	NEXTDEVICE	nvarchar2	256	√		null
EFSDEVICESVIEW	NEXTDEVICE_ID	number	22	√		null
EFSDEVICESVIEW	OWNER_NAME	nvarchar2	450
EFSDEVICESVIEW	OWNERID	number	22	√		null
EFSDEVICESVIEW	STATUS	number	22
EFSDEVICETYPES	ATTACHMENTS	number	22			0
EFSDEVICETYPES	CONFIRMREQ	number	22
EFSDEVICETYPES	DEFINITION	blob	4000	√		null
EFSDEVICETYPES	DOCID	number	22
EFSDEVICETYPES	DRIVER	nvarchar2	1500
EFSDEVICETYPES	DTACCESS	number	22			0
EFSDEVICETYPES	MAXLEN	number	22	√		null
EFSDEVICETYPES	MEDIUM	nvarchar2	256
EFSDEVICETYPES	MIME_TYPE	nvarchar2	1500
EFSDEVICETYPESVIEW	ATTACHMENTS	number	22
EFSDEVICETYPESVIEW	CONFIRMREQ	number	22
EFSDEVICETYPESVIEW	DEFINITION	blob	4000	√		null
EFSDEVICETYPESVIEW	DEVICES	number	22	√		null
EFSDEVICETYPESVIEW	DOCDESCRIPT	nvarchar2	2000	√		null
EFSDEVICETYPESVIEW	DOCID	number	22	√		null
EFSDEVICETYPESVIEW	DOCNAME	nvarchar2	256	√		null
EFSDEVICETYPESVIEW	DRIVER	nvarchar2	1500
EFSDEVICETYPESVIEW	DTACCESS	number	22
EFSDEVICETYPESVIEW	ISDELETED	number	22	√		null
EFSDEVICETYPESVIEW	MAXLEN	number	22	√		null
EFSDEVICETYPESVIEW	MEDIUM	nvarchar2	256
EFSDEVICETYPESVIEW	MIME_TYPE	nvarchar2	1500
EFSDEVICETYPESVIEW	OWNER_NAME	nvarchar2	450
EFSDEVICETYPESVIEW	OWNERID	number	22	√		null
EFSDOCPROPS	DOCID	number	22
EFSDOCPROPS	PROPCANEDIT	number	22			0
EFSDOCPROPS	PROPDESCRIPT	nvarchar2	1500	√		null
EFSDOCPROPS	PROPNAME	nvarchar2	256
EFSDOCPROPS	PROPVALUE	nvarchar2	1500
EFSDOCPROPSVIEW	DOCID	number	22	√		null
EFSDOCPROPSVIEW	DOCNAME	nvarchar2	256	√		null
EFSDOCPROPSVIEW	DOCTYPE	number	22	√		null
EFSDOCPROPSVIEW	ISDELETED	number	22	√		null
EFSDOCPROPSVIEW	OWNER_NAME	nvarchar2	450	√		null
EFSDOCPROPSVIEW	OWNERID	number	22	√		null
EFSDOCPROPSVIEW	PROPCANEDIT	number	22
EFSDOCPROPSVIEW	PROPDESCRIPT	nvarchar2	1500	√		null
EFSDOCPROPSVIEW	PROPNAME	nvarchar2	256
EFSDOCPROPSVIEW	PROPVALUE	nvarchar2	1500
EFSDOCUMENTS	DOCDESCRIPT	nvarchar2	2000	√		null
EFSDOCUMENTS	DOCID	number	22
EFSDOCUMENTS	DOCNAME	nvarchar2	256
EFSDOCUMENTS	DOCTYPE	number	22
EFSDOCUMENTS	OWNERID	number	22
EFSSYSTEMCONFIG	NAME	varchar2	500
EFSSYSTEMCONFIG	VALUE	varchar2	500	√		null
ENPATTRLIST	ATTRCATEGORY	number	22
ENPATTRLIST	ATTRDESC	nvarchar2	500
ENPATTRLIST	ATTRID	number	22
ENPBATREE	CREATIONDATE	date	7	√		now
ENPBATREE	ENTRYCATEGORY	number	22
ENPBATREE	ENTRYDESC	nvarchar2	100	√		null
ENPBATREE	ENTRYOWNER	number	22	√		null
ENPBATREE	ENTRYPARENT	number	22	√		null
ENPBATREE	ENTRYPUBLIC	number	22			1
ENPBATREE	ENTRYSTRING	nvarchar2	200
ENPBATREE	ENTRYSUBTYPE	number	22	√		-1
ENPBATREE	HIERARCHY	varchar2	900	√		null
ENPBATREE	LVL	number	22	√		null
ENPBATREE	TREEENTRYID	number	22
ENPCATATTRS	ATTRDESC	nvarchar2	500	√		null
ENPCATATTRS	ATTRID	number	22	√		null
ENPCATATTRS	CATEGORYDESC	nvarchar2	100	√		null
ENPCATATTRS	CATEGORYID	number	22
ENPCATEGORIES	CATEGORYDESC	nvarchar2	100	√		null
ENPCATEGORIES	CATEGORYID	number	22
ENPCATLISTHELPER	CATEGORYID	number	22
ENPDELIVERYLOG	DETAILS	nvarchar2	2000	√		null
ENPDELIVERYLOG	DEVICE_ID	number	22	√		null
ENPDELIVERYLOG	DOCUMENT_ID	number	22	√		null
ENPDELIVERYLOG	DOCUMENT_TYPE	number	22	√		null
ENPDELIVERYLOG	EVENT_ID	number	22
ENPDELIVERYLOG	MESSAGE	nvarchar2	200	√		null
ENPDELIVERYLOG	TIMESTMP	date	7			now
ENPDELIVERYLOG	TRACKING	nvarchar2	25
ENPDELIVERYLOG	USERID	number	22
ENPDELIVERYLOGVIEW	DETAILS	nvarchar2	2000	√		null
ENPDELIVERYLOGVIEW	DEVICE_ID	number	22	√		null
ENPDELIVERYLOGVIEW	DEVICE_TYPE	nvarchar2	200
ENPDELIVERYLOGVIEW	DOCUMENT_ID	number	22	√		null
ENPDELIVERYLOGVIEW	DOCUMENT_TYPE	number	22	√		null
ENPDELIVERYLOGVIEW	EVENT_ID	number	22
ENPDELIVERYLOGVIEW	MESSAGE	nvarchar2	200	√		null
ENPDELIVERYLOGVIEW	TIMESTMP	date	7
ENPDELIVERYLOGVIEW	TRACKING	nvarchar2	25
ENPDELIVERYLOGVIEW	USERID	number	22
ENPENTRYACCESS	ACCESSID	number	22
ENPENTRYACCESS	ACCESSTYPEID	number	22
ENPENTRYACCESS	TREEENTRYID	number	22
ENPENTRYACCESSLIST	ACCESSID	number	22
ENPENTRYACCESSLIST	ENTRYTYPE	number	22
ENPENTRYACCESSLIST	TREEENTRYID	number	22
ENPENTRYACCESSLIST	USERNAME	nvarchar2	250	√		null
ENPENTRYACCESSTYPES	ACCESSTYPEDESC	nvarchar2	50	√		null
ENPENTRYACCESSTYPES	ACCESSTYPEID	number	22
ENPENTRYACCESSUSERSROLES	TREEENTRYID	number	22
ENPENTRYACCESSUSERSROLES	USERNAME	nvarchar2	250	√		null
ENPENTRYATTR	ATTRBINARYVALUE	blob	4000	√		null
ENPENTRYATTR	ATTRCATEGORY	number	22
ENPENTRYATTR	ATTRDATEVALUE	date	7	√		null
ENPENTRYATTR	ATTRFLOATVALUE	number	22	√		null
ENPENTRYATTR	ATTRID	number	22
ENPENTRYATTR	ATTRINTVALUE	number	22	√		null
ENPENTRYATTR	ATTRSTRINGVALUE	nvarchar2	850	√		null
ENPENTRYATTR	TREEENTRYID	number	22
ENPGROUPMAP	GROUPID	number	22
ENPGROUPMAP	USERID	number	22
ENPLOGSOURCES	LOGSOURCEDESC	nvarchar2	50	√		null
ENPLOGSOURCES	LOGSOURCEID	number	22
ENPLOGTABLE	LOGDATA	blob	4000	√		null
ENPLOGTABLE	LOGDATATYPE	number	22	√		null
ENPLOGTABLE	LOGMSG	nvarchar2	2000
ENPLOGTABLE	LOGRELID	number	22
ENPLOGTABLE	LOGSEV	number	22
ENPLOGTABLE	LOGSOURCEID	number	22
ENPLOGTABLE	TIMESTMP	date	7	√		now
ENPREFCATS	REFCATEGORY	number	22
ENPREFCATS	REFERENCEID	number	22
ENPREFCATS	TREECATEGORY	number	22
ENPREFCATS	TREEENTRYID	number	22
ENPREFERENCECV	CTYPE	number	22	√		null
ENPREFERENCECV	REFCOUNT	number	22	√		null
ENPREFERENCECV	TREEENTRYID	number	22	√		null
ENPREFERENCES	REFERENCEID	number	22
ENPREFERENCES	TREEENTRYID	number	22
ENPREFLISTVIEW	TREEENTRYID	number	22
ENPSEQNUM	SEQNAME	nvarchar2	20
ENPSEQNUM	SEQNUM	number	22
ENPSTATSLOG	STATSTYPE	number	22
ENPSTATSLOG	STATSVALUE	number	22
ENPSTATSLOG	TREEENTRYID	number	22
ENPSTATSLOGTYPES	STATSDESC	nvarchar2	500
ENPSTATSLOGTYPES	STATSTYPE	number	22
ENPSTATSREPORT	ENTRYCATEGORY	number	22
ENPSTATSREPORT	ENTRYDESC	nvarchar2	100	√		null
ENPSTATSREPORT	ENTRYSTRING	nvarchar2	200
ENPSTATSREPORT	STATSDESC	nvarchar2	500
ENPSTATSREPORT	STATSVALUE	number	22
ENPSTATSREPORT	TREEENTRYID	number	22
ENPTRANSACTSUB	SUBCOMMENT	nvarchar2	200	√		null
ENPTRANSACTSUB	SUBDELIVERY	nvarchar2	500	√		null
ENPTRANSACTSUB	SUBEXTRDATA	nvarchar2	100	√		null
ENPTRANSACTSUB	SUBFLAG1	number	22	√		null
ENPTRANSACTSUB	SUBFLAG2	number	22	√		null
ENPTRANSACTSUB	SUBFORM	nvarchar2	50
ENPTRANSACTSUB	SUBHKEY	nvarchar2	100
ENPTRANSACTSUB	SUBID	number	22
ENPTRANSACTSUB	SUBKEYFIELD	nvarchar2	20
ENPTRANSACTSUB	SUBKEYVAL	nvarchar2	2000	√		null
ENPTRANSACTSUB	SUBM1VAL	number	38,7	√		null
ENPTRANSACTSUB	SUBM2VAL	number	38,7	√		null
ENPTRANSACTSUB	SUBMPREV	number	38,7	√		null
ENPTRANSACTSUB	SUBOPERATOR	number	22
ENPTRANSACTSUB	SUBTRANSOURCE	number	22
ENPTRANSACTSUB	SUBUSER	nvarchar2	50
ENPTRANSACTSUB	SUBUSERTYPE	number	22
ENPTREEATTRS	ATTRBINARYVALUE	blob	4000	√		null
ENPTREEATTRS	ATTRCATEGORY	number	22	√		null
ENPTREEATTRS	ATTRDATEVALUE	date	7	√		null
ENPTREEATTRS	ATTRFLOATVALUE	number	22	√		null
ENPTREEATTRS	ATTRID	number	22	√		null
ENPTREEATTRS	ATTRINTVALUE	number	22	√		null
ENPTREEATTRS	ATTRSTRINGVALUE	nvarchar2	850	√		null
ENPTREEATTRS	CREATIONDATE	date	7	√		null
ENPTREEATTRS	ENTRYCATEGORY	number	22
ENPTREEATTRS	ENTRYDESC	nvarchar2	100	√		null
ENPTREEATTRS	ENTRYOWNER	number	22	√		null
ENPTREEATTRS	ENTRYPARENT	number	22	√		null
ENPTREEATTRS	ENTRYPUBLIC	number	22
ENPTREEATTRS	ENTRYSTRING	nvarchar2	200
ENPTREEATTRS	ENTRYSUBTYPE	number	22	√		null
ENPTREEATTRS	HIERARCHY	varchar2	900	√		null
ENPTREEATTRS	LVL	number	22	√		null
ENPTREEATTRS	TREEENTRYID	number	22
ENPUSERGROUPLIST	GROUPID	number	22	√		null
ENPUSERGROUPLIST	GROUPNAME	nvarchar2	250	√		null
ENPUSERGROUPLIST	USERID	number	22	√		null
ENPUSERGROUPLIST	USERNAME	nvarchar2	250	√		null
ENPUSERLISTVIEW	USERID	number	22
ENPUSERLISTVIEW	USERNAME	nvarchar2	250	√		null
ENPUSERMAP	ENTRYTYPE	number	22
ENPUSERMAP	EXTERNALUSERNAME	nvarchar2	250	√		null
ENPUSERMAP	USERID	number	22
ENPUSERMAP	USERNAME	nvarchar2	250	√		null
ENPUSERMAP	USERTYPE	number	22	√		null
ENPUSERTOKEN	CREATIONDATE	date	7	√		now
ENPUSERTOKEN	TOKENKEY	nvarchar2	80
ENPUSERTOKEN	USERINFO	blob	4000	√		null
ENPUSERTOKEN	USERIP	nvarchar2	60
LBICONNECTIONS	CONNECTIONDESCRIPTION	nvarchar2	1000	√		null
LBICONNECTIONS	CONNECTIONENABLED	varchar2	1
LBICONNECTIONS	CONNECTIONGUID	nvarchar2	100
LBICONNECTIONS	CONNECTIONID	number	22
LBICONNECTIONS	CONNECTIONNAME	nvarchar2	100
LBICONNECTIONS	CONNECTIONTYPE	nvarchar2	60
LBICONNECTIONS	CONNECTIONXML	blob	4000	√		null
SPACE	CREATE_DATE	date	7
SPACE	CREATED_BY	nvarchar2	60
SPACE	LAST_UPDATE_DATE	date	7	√		null
SPACE	LAST_UPDATED_BY	nvarchar2	60	√		null
SPACE	OWNED_BY_ROLE	nvarchar2	60
SPACE	SPACE_GUID	nvarchar2	100
SPACE	SPACE_ID	number	22
SPACE	SPACE_NAME	nvarchar2	100
SPACE	SPACE_XML	blob	4000	√		null
SPACEACCESS	ACCESS_NAME	nvarchar2	60
SPACEACCESS	ACCESSTYPE	number	22
SPACEACCESS	GUID	nvarchar2	100
SYSTEMVARIABLE	CREATE_DATE	date	7
SYSTEMVARIABLE	LAST_UPDATE_DATE	date	7	√		null
SYSTEMVARIABLE	SYSTEMVARIABLE_GUID	nvarchar2	100
SYSTEMVARIABLE	SYSTEMVARIABLE_ID	number	22
SYSTEMVARIABLE	SYSTEMVARIABLE_NAME	nvarchar2	100
SYSTEMVARIABLE	SYSTEMVARIABLE_XML	blob	4000	√		null
SYSTEMVARIABLE	USER_NAME	nvarchar2	60
TEMPLATEACCESS	ACCESS_NAME	nvarchar2	60
TEMPLATEACCESS	ACCESSTYPE	number	22
TEMPLATEACCESS	GUID	nvarchar2	100
TEMPLATEVIEW	CREATE_DATE	date	7
TEMPLATEVIEW	CREATED_BY	nvarchar2	60
TEMPLATEVIEW	GUID	nvarchar2	100
TEMPLATEVIEW	LAST_UPDATE_DATE	date	7	√		null
TEMPLATEVIEW	LAST_UPDATED_BY	nvarchar2	60	√		null
TEMPLATEVIEW	OWNED_BY_ROLE	nvarchar2	60
TEMPLATEVIEW	PUBLISHED	varchar2	1
TEMPLATEVIEW	TEMPLATE_ID	number	22
TEMPLATEVIEW	TEMPLATE_NAME	nvarchar2	100
TEMPLATEVIEW	TEMPLATE_XML	blob	4000	√		null
TEMPLATEVIEW	THUMBNAIL	blob	4000	√		null
USERPREFERENCES	APPLICATION_ID	nvarchar2	100
USERPREFERENCES	CREATE_DATE	date	7
USERPREFERENCES	CREATED_BY	nvarchar2	60
USERPREFERENCES	LAST_UPDATE_DATE	date	7	√		null
USERPREFERENCES	LAST_UPDATED_BY	nvarchar2	60	√		null
USERPREFERENCES	USER_ID	nvarchar2	60
USERPREFERENCES	USERPREFERENCES_ID	number	22
USERPREFERENCES	USERPREFERENCES_XML	blob	4000	√		null
USERVIEW	CREATE_DATE	date	7
USERVIEW	LAST_UPDATE_DATE	date	7	√		null
USERVIEW	TEMPLATE_GUID	nvarchar2	100
USERVIEW	THUMBNAIL	blob	4000	√		null
USERVIEW	USER_NAME	nvarchar2	60
USERVIEW	VIEW_GUID	nvarchar2	100
USERVIEW	VIEW_ID	number	22
USERVIEW	VIEW_NAME	nvarchar2	100
USERVIEW	VIEW_XML	blob	4000	√		null
USERVIEWSEARCH	CREATE_DATE	date	7
USERVIEWSEARCH	CREATED_BY	nvarchar2	60	√		null
USERVIEWSEARCH	ID	number	22
USERVIEWSEARCH	LAST_UPDATE_DATE	date	7	√		null
USERVIEWSEARCH	LAST_UPDATED_BY	nvarchar2	60	√		null
USERVIEWSEARCH	SEARCH_ITEMS	nvarchar2	1000	√		null
USERVIEWSEARCH	USER_VIEW_ID	nvarchar2	100
USERVIEWSEARCH	VIEW_ID	nvarchar2	100
VIEWSEARCH	CREATE_DATE	date	7
VIEWSEARCH	CREATED_BY	nvarchar2	60	√		null
VIEWSEARCH	LAST_UPDATE_DATE	date	7	√		null
VIEWSEARCH	LAST_UPDATED_BY	nvarchar2	60	√		null
VIEWSEARCH	SEARCH_ITEMS	nvarchar2	1000	√		null
VIEWSEARCH	VIEW_ID	nvarchar2	100
VIEWSEARCH	VIEWSEARCH_ID	number	22