Tables [dbo].[al_criteria_def]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count544
Created10:33:02 PM Thursday, February 10, 2011
Last Modified10:34:27 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key pk_al_criteria_def: criteria_idcriteria_idint4
No
positionint4
No
left_parenint4
No
right_parenint4
No
attribute_namenvarchar(255)510
No
attribute_pathnvarchar(2000)4000
Yes
Foreign Keys AL_CRITERIA_DEF_FK02: [dbo].[arg_class_def].class_nameclass_namenvarchar(255)510
No
cust_attr_labelnvarchar(2000)4000
Yes
Foreign Keys AL_CRITERIA_DEF_FK03: [dbo].[arg_sl_operator].operator_idoperator_idint4
No
Foreign Keys AL_CRITERIA_DEF_FK04: [dbo].[arg_sl_connector].connector_idconnector_idint4
No
valuenvarchar(512)1024
Yes
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0                         ')
label_formatint4
No
('0 ')
column_indexint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_al_criteria_def: criteria_idpk_al_criteria_defcriteria_id
Yes
Foreign Keys Foreign Keys
NameColumns
AL_CRITERIA_DEF_FK02class_name->[dbo].[arg_class_def].[class_name]
AL_CRITERIA_DEF_FK03operator_id->[dbo].[arg_sl_operator].[id]
AL_CRITERIA_DEF_FK04connector_id->[dbo].[arg_sl_connector].[id]
SQL Script
CREATE TABLE [dbo].[al_criteria_def]
(
[criteria_id] [int] NOT NULL,
[position] [int] NOT NULL,
[left_paren] [int] NOT NULL,
[right_paren] [int] NOT NULL,
[attribute_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute_path] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[cust_attr_label] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[operator_id] [int] NOT NULL,
[connector_id] [int] NOT NULL,
[value] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__AL_CRITER__VERSI__0F2D40CE] DEFAULT ('0                         '),
[label_format] [int] NOT NULL CONSTRAINT [DF__AL_CRITER__LABEL__10216507] DEFAULT ('0 '),
[column_index] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_criteria_def] ADD CONSTRAINT [pk_al_criteria_def] PRIMARY KEY CLUSTERED ([criteria_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_criteria_def] ADD CONSTRAINT [AL_CRITERIA_DEF_FK02] FOREIGN KEY ([class_name]) REFERENCES [dbo].[arg_class_def] ([class_name])
GO
ALTER TABLE [dbo].[al_criteria_def] ADD CONSTRAINT [AL_CRITERIA_DEF_FK03] FOREIGN KEY ([operator_id]) REFERENCES [dbo].[arg_sl_operator] ([id])
GO
ALTER TABLE [dbo].[al_criteria_def] ADD CONSTRAINT [AL_CRITERIA_DEF_FK04] FOREIGN KEY ([connector_id]) REFERENCES [dbo].[arg_sl_connector] ([id])
GO
Uses
Used By