Tables [dbo].[si_ci_legdoc_rel]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count67
Created6:13:22 PM Tuesday, May 05, 2009
Last Modified5:09:46 AM Tuesday, December 01, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
ci_uuidbinary(16)16
No
legaldoc_uuidbinary(16)16
No
ci_namenvarchar(100)200
Yes
legaldoc_namenvarchar(100)200
Yes
Indexes ix_si_ci_legdoc_rel_1: data_sourcedata_sourcenvarchar(128)256
Yes
versionint4
Yes
Indexes Indexes
NameColumns
ix_si_ci_legdoc_rel_1data_source
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantReferencesaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[si_ci_legdoc_rel]
(
[ci_uuid] [binary] (16) NOT NULL,
[legaldoc_uuid] [binary] (16) NOT NULL,
[ci_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[legaldoc_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[version] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_si_ci_legdoc_rel_1] ON [dbo].[si_ci_legdoc_rel] ([data_source]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[si_ci_legdoc_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_ci_legdoc_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_ci_legdoc_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_ci_legdoc_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_ci_legdoc_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_ci_legdoc_rel] TO [aipublic]
GO
Uses