iVend Database Database : SecCustomSecurityFeatureSubFunction Table

Creation Date

10/8/2018 5:57 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

22

Data Space Used

8.00 KB

Index Space Used

24.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

CustomSecuritySubFunctionKey

VarWChar

50

SecuritySubFunctionKey

VarWChar

50

AccessLevel

Integer

4

FeatureType

Integer

4

Localization

Integer

4

((0))

Index

Description

Primary

Unique

IX_SecCustomSecurityFeatureSubFunction

PK_SecCustomSecurityFeatureSubFunction

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SecCustomSecurityFeatureSubFunction](

[CustomSecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[AccessLevel] [int] NOT NULL,

[FeatureType] [int] NOT NULL,

[Localization] [int] NOT NULL,

CONSTRAINT [PK_SecCustomSecurityFeatureSubFunction] PRIMARY KEY CLUSTERED

(

[CustomSecuritySubFunctionKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[SecCustomSecurityFeatureSubFunction] ADD CONSTRAINT [DF_SecCustomSecurityFeatureSubFunction_Localization] DEFAULT ((0)) FOR [Localization]