[dbo].[si_legdoc

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	16
Created	6:13:22 PM Tuesday, May 05, 2009
Last Modified	5:09:46 AM Tuesday, December 01, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

6:13:22 PM Tuesday, May 05, 2009

Last Modified

5:09:46 AM Tuesday, December 01, 2009

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$	legaldoc_uuid	binary(16)	16
	ext_company	nvarchar(100)	200
	int_company	nvarchar(100)	200
	eff_date	datetime	8
$Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	term_date	datetime	8
	description	nvarchar(100)	200
$Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	status	nvarchar(255)	510
$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$	data_source	nvarchar(128)	256
	vendor	nvarchar(100)	200
	leinact	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$

legaldoc_uuid

binary(16)

ext_company

nvarchar(100)

200

int_company

nvarchar(100)

200

eff_date

datetime

$Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

term_date

datetime

description

nvarchar(100)

200

$Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

status

nvarchar(255)

510

$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$ $Indexes IX_si_legdoc_prop_1: data_source\status\term_date$

data_source

nvarchar(128)

256

vendor

nvarchar(100)

200

leinact

int

	Name	Columns	Unique
$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$	PK_si_legdoc_prop	legaldoc_uuid, data_source
	IX_si_legdoc_prop_1	data_source, status, term_date

Name

Columns

Unique

$Cluster Primary Key PK_si_legdoc_prop: legaldoc_uuid\data_source$

PK_si_legdoc_prop

legaldoc_uuid, data_source

IX_si_legdoc_prop_1

data_source, status, term_date

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Delete	siadmins
Grant	Insert	siadmins
Grant	References	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic
Grant	References	siadmins
Grant	Select	siadmins
Grant	Update	siadmins

Type

Action

Owning Principal

Grant

Delete

aiadmin

Grant

Insert

aiadmin

Grant

Delete

siadmins

Grant

Insert

siadmins

Grant

References

aiadmin

Grant

Select

aiadmin

Grant

Update

aiadmin

Grant

Select

aipublic

Grant

References

siadmins

Grant

Select

siadmins

Grant

Update

siadmins

SQL Script

CREATE TABLE [dbo].[si_legdoc_prop]
(
[legaldoc_uuid] [binary] (16) NOT NULL,
[ext_company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[int_company] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[eff_date] [datetime] NULL,
[term_date] [datetime] NULL,
[description] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[vendor] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[leinact] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[si_legdoc_prop] ADD CONSTRAINT [PK_si_legdoc_prop] PRIMARY KEY CLUSTERED ([legaldoc_uuid], [data_source]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_si_legdoc_prop_1] ON [dbo].[si_legdoc_prop] ([data_source], [status], [term_date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[si_legdoc_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_legdoc_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_legdoc_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_legdoc_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_legdoc_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_legdoc_prop] TO [aipublic]
GRANT REFERENCES ON  [dbo].[si_legdoc_prop] TO [siadmins]
GRANT SELECT ON  [dbo].[si_legdoc_prop] TO [siadmins]
GRANT INSERT ON  [dbo].[si_legdoc_prop] TO [siadmins]
GRANT DELETE ON  [dbo].[si_legdoc_prop] TO [siadmins]
GRANT UPDATE ON  [dbo].[si_legdoc_prop] TO [siadmins]
GO