Search Results

All 19 tables in the Security & Access Control category. Table Type Columns Key ADFSIDS BASE TABLE 4 AccessControl BASE TABLE 11 AccessToken BASE TABLE 10 AuthGuid BASE TABLE 4 Certificate BASE TABLE 7 FederatedCredential BASE TABLE 7 ...

All 13 tables in the Identity & NHD Platform category. Table Type Columns Key NHD_IDENTITY_Application BASE TABLE 53 NHD_IDENTITY_Authorization BASE TABLE 9 NHD_IDENTITY_Scope BASE TABLE 7 NHD_IDENTITY_Token BASE TABLE 12 NHD_Identity_Applic...

All 10 tables in the Trees & Navigation category. Table Type Columns Key Bookmark BASE TABLE 4 MAPPING BASE TABLE 4 MappingContinuum BASE TABLE 5 Permalinks BASE TABLE 6 SPOTLIGHT BASE TABLE 3 TABNAME BASE TABLE 14 TREE BASE TABLE 22 ...

All 48 tables in the Miscellaneous category. Table Type Columns Key AIAssistantRequest BASE TABLE 11 AOV BASE TABLE 4 APIAPPLICATION BASE TABLE 3 APIToken BASE TABLE 4 AiSuggestion BASE TABLE 16 AiSuggestionFault BASE TABLE 9 CHECKIN B...

Full column listings for the 1 key table in this category. ATTACHMENT (26 columns) # Column Type Length Nullable Default 1 ATid int NO 2 ATBlob varbinary -1 YES 3 ATFilename nvarchar 4000 YES 4 ATDateCreated datetime YES 5 ATNote nvarchar ...

All 13 tables in the Attachments & Files category. Table Type Columns Key ATTACHMENT BASE TABLE 26 KEY ATTACHMENTACTION BASE TABLE 8 Attachment_Metadata BASE TABLE 1 DocumentCreation BASE TABLE 6 FILES BASE TABLE 10 PdfTemplate BASE TABLE ...

Full column listings for the 1 key table in this category. AUDIT (15 columns) # Column Type Length Nullable Default 1 AID int NO 2 AFaultid int NO 3 AUnum int NO 4 ADate datetime YES 5 AValue nvarchar 4000 YES 6 ATo nvarchar -1 YES ...

All 19 tables in the Audit & Logging category. Table Type Columns Key AUDIT BASE TABLE 15 KEY AUDITEVENT BASE TABLE 7 AUDITFAULT BASE TABLE 11 AnonRequestLog BASE TABLE 5 AuditPasswordField BASE TABLE 6 BackgroundTask BASE TABLE 14 CUST...

Full column listings for the 1 key table in this category. Licence (38 columns) # Column Type Length Nullable Default 1 LID int NO 2 LType int NO ((0)) 3 LDesc nvarchar 500 YES 4 LCount int NO ((0)) 5 Larea int NO ((0)) 6 LSite int NO (...

All 7 tables in the Software & Licences category. Table Type Columns Key AzureLicences BASE TABLE 3 LICENCEHISTORY BASE TABLE 12 Licence BASE TABLE 38 KEY LicenceChange BASE TABLE 8 LicenceMatch BASE TABLE 4 LicenceRole BASE TABLE 4 Lic...

Full column listings for the 3 key tables in this category. CONTRACT (19 columns) # Column Type Length Nullable Default 1 CNid int NO 2 CNcompanynum int YES 3 cnphone1 nvarchar 4000 YES 4 cnphone2 nvarchar 4000 YES 5 cnphone3 nvarchar 4000...

All 16 tables in the Contracts & Recurring category. Table Type Columns Key CONTRACT BASE TABLE 19 KEY CONTRACTDETAIL BASE TABLE 30 KEY CONTRACTHEADER BASE TABLE 98 KEY CONTRACTPERIODHISTORY BASE TABLE 8 CONTRACTPLAN BASE TABLE 9 CONTRACTPLA...

Full column listings for the 3 key tables in this category. MileStone (17 columns) # Column Type Length Nullable Default 1 MSTid int NO 2 MSTFaultId int YES 3 MSTName nvarchar 1000 YES 4 MSTSequence int YES 5 MSTStartDate datetime YES ...

All 8 tables in the Projects & Milestones category. Table Type Columns Key MileStone BASE TABLE 17 KEY MileStoneDependency BASE TABLE 3 PROJECTNOTE BASE TABLE 5 KEY ProjectSetupLines BASE TABLE 10 TASK BASE TABLE 10 KEY TaskMonitor BASE TABL...

Full column listings for the 2 key tables in this category. LIVECHATHEADER (34 columns) # Column Type Length Nullable Default 1 LCHid int NO 2 LCHname nvarchar 255 YES 3 LCHsectionid int YES 4 LCHistech bit YES 5 LCHisclosed bit YES ((0)...

All 17 tables in the Live Chat category. Table Type Columns Key CHATMESSAGE BASE TABLE 7 ChatBanner BASE TABLE 6 ChatInputSuggestion BASE TABLE 5 ChatMatchingData BASE TABLE 5 ChatPopupMessage BASE TABLE 4 ChatProfile BASE TABLE 55 Cha...

Full column listings for the 2 key tables in this category. CHANGESEQ (40 columns) # Column Type Length Nullable Default 1 id int NO 2 lastseq int YES 3 faults int YES 4 actions int YES 5 requesttype int YES 6 tstatus int YES 7 s...

All 13 tables in the Releases & Change Management category. Table Type Columns Key CABHEADER BASE TABLE 9 CABMEMBER BASE TABLE 9 CHANGELG BASE TABLE 19 CHANGESEQ BASE TABLE 40 KEY CabRole BASE TABLE 6 RELEASE BASE TABLE 20 KEY RELEASECOM...