Tables [dbo].[Signature_Authority_DE]
Signature Authority Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Signature_Authority_DE_ID: IDIndexes TWstat_Signature_Authority_DE_DefinitionSetID_ID, TWstat_Signature_Authority_DE_EntryName_ID, TWstat_Signature_Authority_DE_IsCurrentFLAG_ID, TWstat_Signature_Authority_DE_IsInactiveFLAG_ID(4)IDnumeric(8,0)5NOT NULL1 - 1Key to the Signature_Authority_DE table.
Foreign Keys FK_Signature_Authority_DE_EnterpriseEntryID_Dictionary_Entry_EnterpriseEntryID: [dbo].[Dictionary_Entry].EnterpriseEntryIDEnterpriseEntryIDnumeric(16,0)9NULL allowedMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Signature_Authority_DE_DefinitionSetID_IDForeign Keys FK_Signature_Authority_DE_DefinitionSetID_Definition_Set_DefinitionSetID: [dbo].[Definition_Set].DefinitionSetIDDefinitionSetIDnumeric(8,0)5NULL allowedPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entrynumeric(8,0)5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
EntryCodechar(10)10NOT NULLEntry Code
Indexes TWstat_Signature_Authority_DE_EntryName_IDEntryNamevarchar(255)255NOT NULLEntry Name
EntryMnemonicchar(10)10NOT NULLEntry Mnemonic
Indexes TWstat_Signature_Authority_DE_IsInactiveFLAG_IDCheck Constraints CK_Signature_Authority_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Signature_Authority_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Indexes TWstat_Signature_Authority_DE_IsCurrentFLAG_IDCheck Constraints CK_Signature_Authority_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
Indexes TWstat_Signature_Authority_DE_HigherIsBetterRankingHigherIsBetterRankingint4NOT NULL(0)Rank