Tables [dbo].[ci_sla]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:13:07 AM Wednesday, March 07, 2007
Last Modified9:20:27 PM Friday, December 05, 2008
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
last_mod_dtint4
Yes
last_mod_bybinary(16)16
Yes
Cluster Primary Key PK__ci_sla__64C467BB: own_resource_uuidown_resource_uuidbinary(16)16
No
sla_idnvarchar(50)100
Yes
sla_categorynvarchar(50)100
Yes
sla_typenvarchar(50)100
Yes
sla_statusnvarchar(50)100
Yes
sla_versionnvarchar(15)30
Yes
sla_date_activeint4
Yes
sla_start_dateint4
Yes
sla_end_dateint4
Yes
delint4
Yes
((0))
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 PK__ci_sla__64C467BB: own_resource_uuidPK__ci_sla__64C467BBown_resource_uuid
Yes
Permissions
TypeActionOwning Principal
GrantInsertcmdb_admin
GrantDeletepublic
GrantInsertpublic
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantDeletecmdb_admin
GrantSelectpublic
GrantUpdatepublic
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
GrantSelectcmdb_admin
GrantUpdatecmdb_admin
SQL Script
CREATE TABLE [dbo].[ci_sla]
(
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[own_resource_uuid] [binary] (16) NOT NULL,
[sla_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_status] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_version] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sla_date_active] [int] NULL,
[sla_start_date] [int] NULL,
[sla_end_date] [int] NULL,
[del] [int] NULL CONSTRAINT [DF__ci_sla__del__55D035A1] DEFAULT ((0)),
[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
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ci_sla] ADD CONSTRAINT [PK__ci_sla__64C467BB] PRIMARY KEY CLUSTERED ([own_resource_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ci_sla] TO [cmdb_admin]
GRANT INSERT ON  [dbo].[ci_sla] TO [cmdb_admin]
GRANT DELETE ON  [dbo].[ci_sla] TO [cmdb_admin]
GRANT UPDATE ON  [dbo].[ci_sla] TO [cmdb_admin]
GRANT SELECT ON  [dbo].[ci_sla] TO [public]
GRANT INSERT ON  [dbo].[ci_sla] TO [public]
GRANT DELETE ON  [dbo].[ci_sla] TO [public]
GRANT UPDATE ON  [dbo].[ci_sla] TO [public]
GRANT SELECT ON  [dbo].[ci_sla] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[ci_sla] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[ci_sla] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[ci_sla] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ci_sla] TO [service_desk_ro_group]
GO
Uses