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

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