Tables [dbo].[arg_tclgdef]
Properties
PropertyValue
Row Count275
Created12:30:45 PM Sunday, December 05, 2010
Last Modified10:34:34 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key xpkarg_tclgdef: tllgid\tltdidForeign Keys TLLGJOIN01: [dbo].[arg_legaldef].tllgidtllgidbigint8
No
Cluster Primary Key xpkarg_tclgdef: tllgid\tltdidForeign Keys TLTDJOIN01: [dbo].[arg_ltcdef].tltdidIndexes tlindex02: tltdidtltdidbigint8
No
last_update_dateint4
Yes
version_numberint4
Yes
('0')
Foreign Keys FK_ARG_TCLGDEF_TENANT: [dbo].[ca_tenant].tenanttenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkarg_tclgdef: tllgid\tltdidxpkarg_tclgdeftllgid, tltdid
Yes
tlindex02tltdid
Foreign Keys Foreign Keys
NameColumns
FK_ARG_TCLGDEF_TENANTtenant->[dbo].[ca_tenant].[id]
TLLGJOIN01tllgid->[dbo].[arg_legaldef].[lgid]
TLTDJOIN01tltdid->[dbo].[arg_ltcdef].[tdid]
Permissions
TypeActionOwning Principal
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[arg_tclgdef]
(
[tllgid] [bigint] NOT NULL,
[tltdid] [bigint] NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_tclgd__versi__04459E07] DEFAULT ('0'),
[tenant] [binary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_tclgdef] ADD CONSTRAINT [xpkarg_tclgdef] PRIMARY KEY CLUSTERED ([tllgid], [tltdid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tlindex02] ON [dbo].[arg_tclgdef] ([tltdid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_tclgdef] ADD CONSTRAINT [FK_ARG_TCLGDEF_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_tclgdef] ADD CONSTRAINT [TLLGJOIN01] FOREIGN KEY ([tllgid]) REFERENCES [dbo].[arg_legaldef] ([lgid])
GO
ALTER TABLE [dbo].[arg_tclgdef] ADD CONSTRAINT [TLTDJOIN01] FOREIGN KEY ([tltdid]) REFERENCES [dbo].[arg_ltcdef] ([tdid])
GO
GRANT SELECT ON  [dbo].[arg_tclgdef] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_tclgdef] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_tclgdef] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_tclgdef] TO [swcmadmin]
GO
Uses