
[dbo].[system_configuration]
CREATE TABLE [dbo].[system_configuration]
(
[unit_id] [binary] (16) NOT NULL,
[application_type_id] [binary] (16) NULL,
[code_version_number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[password_expiration_day_count] [smallint] NULL,
[nonrepeating_password_count] [smallint] NULL,
[nonrepeating_password_day_count] [smallint] NULL,
[minimum_password_length] [smallint] NULL,
[minimum_user_name_length] [smallint] NULL,
[maximum_user_name_length] [smallint] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[system_configuration] ADD CONSTRAINT [XPKsystem_configuration] PRIMARY KEY CLUSTERED ([unit_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[system_configuration] ADD CONSTRAINT [$syste_r00001ad500000000] FOREIGN KEY ([application_type_id]) REFERENCES [dbo].[application_type] ([application_type_id])
GO