[dbo].[tspan]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	22
Created	11:07:35 AM Wednesday, March 07, 2007
Last Modified	9:09:04 PM Friday, December 05, 2008

Name	Data Type	Max Length (Bytes)
id	int	4
sym	nvarchar(60)	120
code	nvarchar(10)	20
start_year	nvarchar(5)	10
start_month	nvarchar(5)	10
start_day	nvarchar(5)	10
start_hour	nvarchar(5)	10
start_minute	nvarchar(5)	10
end_year	nvarchar(5)	10
end_month	nvarchar(5)	10
end_day	nvarchar(5)	10
end_hour	nvarchar(5)	10
end_minute	nvarchar(5)	10
trigger_year	nvarchar(5)	10
trigger_month	nvarchar(5)	10
trigger_day	nvarchar(5)	10
trigger_hour	nvarchar(5)	10
trigger_minute	nvarchar(5)	10
nx_desc	nvarchar(240)	480
last_mod_dt	int	4
last_mod_by	binary(16)	16

	Name	Columns	Unique
	XPKtspan	id
	tspan_x0	sym
	tspan_x1	code

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group

SQL Script

CREATE TABLE [dbo].[tspan]
(
[id] [int] NOT NULL,
[sym] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[code] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[start_year] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[start_month] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[start_day] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[start_hour] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[start_minute] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_year] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_month] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_day] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_hour] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[end_minute] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[trigger_year] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[trigger_month] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[trigger_day] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[trigger_hour] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[trigger_minute] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nx_desc] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tspan] ADD CONSTRAINT [XPKtspan] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [tspan_x1] ON [dbo].[tspan] ([code]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [tspan_x0] ON [dbo].[tspan] ([sym]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tspan] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[tspan] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[tspan] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[tspan] TO [service_desk_admin_group]
GO