Tables [dbo].[asset_group_process_schedule]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:08:09 AM Wednesday, March 07, 2007
Last Modified11:10:00 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKasset_group_process_schedule: asset_grp_proc_sched_rec_idasset_grp_proc_sched_rec_idbinary(16)16
No
Foreign Keys $asset_r00001b1900000000: [dbo].[vunerability_asset_group].asset_group_idasset_group_idbinary(16)16
No
Foreign Keys $asset_r00001b0f00000000: [dbo].[process_schedule].process_schedule_idprocess_schedule_idbinary(16)16
No
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKasset_group_process_schedule: asset_grp_proc_sched_rec_idXPKasset_group_process_scheduleasset_grp_proc_sched_rec_id
Yes
Foreign Keys Foreign Keys
NameColumns
$asset_r00001b0f00000000process_schedule_id->[dbo].[process_schedule].[process_schedule_id]
$asset_r00001b1900000000asset_group_id->[dbo].[vunerability_asset_group].[asset_group_id]
SQL Script
CREATE TABLE [dbo].[asset_group_process_schedule]
(
[asset_grp_proc_sched_rec_id] [binary] (16) NOT NULL,
[asset_group_id] [binary] (16) NOT NULL,
[process_schedule_id] [binary] (16) NOT 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].[asset_group_process_schedule] ADD CONSTRAINT [XPKasset_group_process_schedule] PRIMARY KEY CLUSTERED ([asset_grp_proc_sched_rec_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_group_process_schedule] ADD CONSTRAINT [$asset_r00001b0f00000000] FOREIGN KEY ([process_schedule_id]) REFERENCES [dbo].[process_schedule] ([process_schedule_id])
GO
ALTER TABLE [dbo].[asset_group_process_schedule] ADD CONSTRAINT [$asset_r00001b1900000000] FOREIGN KEY ([asset_group_id]) REFERENCES [dbo].[vunerability_asset_group] ([asset_group_id])
GO
Uses