Tables [dbo].[tng_field_storage]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:34 AM Wednesday, March 07, 2007
Last Modified11:09:46 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Indexes $tng_f_u00000c9400000000: uuidIndexes baseidx_tng_field_storage: uuiduuidbinary(16)16
No
int1int4
Yes
((0))
int2int4
Yes
((0))
int3int4
Yes
((0))
int4int4
Yes
((0))
int5int4
Yes
((0))
int6int4
Yes
((0))
int7int4
Yes
((0))
int8int4
Yes
((0))
int9int4
Yes
((0))
int10int4
Yes
((0))
int11int4
Yes
((0))
int12int4
Yes
((0))
int13int4
Yes
((0))
int14int4
Yes
((0))
int15int4
Yes
((0))
int16int4
Yes
((0))
int17int4
Yes
((0))
int18int4
Yes
((0))
int19int4
Yes
((0))
int20int4
Yes
((0))
int21int4
Yes
((0))
int22int4
Yes
((0))
int23int4
Yes
((0))
int24int4
Yes
((0))
int25int4
Yes
((0))
int26int4
Yes
((0))
int27int4
Yes
((0))
int28int4
Yes
((0))
int29int4
Yes
((0))
int30int4
Yes
((0))
int31int4
Yes
((0))
int32int4
Yes
((0))
int33int4
Yes
((0))
int34int4
Yes
((0))
int35int4
Yes
((0))
int36int4
Yes
((0))
int37int4
Yes
((0))
int38int4
Yes
((0))
int39int4
Yes
((0))
int40int4
Yes
((0))
int41int4
Yes
((0))
int42int4
Yes
((0))
int43int4
Yes
((0))
int44int4
Yes
((0))
int45int4
Yes
((0))
int46int4
Yes
((0))
int47int4
Yes
((0))
int48int4
Yes
((0))
int49int4
Yes
((0))
int50int4
Yes
((0))
int51int4
Yes
((0))
int52int4
Yes
((0))
int53int4
Yes
((0))
int54int4
Yes
((0))
int55int4
Yes
((0))
int56int4
Yes
((0))
int57int4
Yes
((0))
int58int4
Yes
((0))
int59int4
Yes
((0))
int60int4
Yes
((0))
int61int4
Yes
((0))
int62int4
Yes
((0))
int63int4
Yes
((0))
int64int4
Yes
((0))
int65int4
Yes
((0))
int66int4
Yes
((0))
int67int4
Yes
((0))
int68int4
Yes
((0))
int69int4
Yes
((0))
int70int4
Yes
((0))
int71int4
Yes
((0))
int72int4
Yes
((0))
int73int4
Yes
((0))
int74int4
Yes
((0))
int75int4
Yes
((0))
int76int4
Yes
((0))
int77int4
Yes
((0))
int78int4
Yes
((0))
int79int4
Yes
((0))
int80int4
Yes
((0))
int81int4
Yes
((0))
int82int4
Yes
((0))
int83int4
Yes
((0))
int84int4
Yes
((0))
int85int4
Yes
((0))
int86int4
Yes
((0))
int87int4
Yes
((0))
int88int4
Yes
((0))
int89int4
Yes
((0))
int90int4
Yes
((0))
int91int4
Yes
((0))
int92int4
Yes
((0))
int93int4
Yes
((0))
int94int4
Yes
((0))
int95int4
Yes
((0))
int96int4
Yes
((0))
int97int4
Yes
((0))
int98int4
Yes
((0))
int99int4
Yes
((0))
int100int4
Yes
((0))
str1varchar(128)128
Yes
('')
str2varchar(128)128
Yes
('')
str3varchar(128)128
Yes
('')
str4varchar(128)128
Yes
('')
str5varchar(128)128
Yes
('')
str6varchar(128)128
Yes
('')
str7varchar(128)128
Yes
('')
str8varchar(128)128
Yes
('')
str9varchar(128)128
Yes
('')
str10varchar(128)128
Yes
('')
str11varchar(128)128
Yes
('')
str12varchar(128)128
Yes
('')
str13varchar(128)128
Yes
('')
Indexes Indexes
NameColumnsUnique
$tng_f_u00000c9400000000uuid
Yes
baseidx_tng_field_storageuuid
Yes
Permissions
TypeActionOwning Principal
GrantInsertuniadmin
GrantDeletewvadmin
GrantInsertwvadmin
GrantDeleteuniadmin
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
GrantSelectwvadmin
GrantUpdatewvadmin
GrantSelectwvuser
SQL Script
CREATE TABLE [dbo].[tng_field_storage]
(
[uuid] [binary] (16) NOT NULL,
[int1] [int] NULL CONSTRAINT [DF__tng_field___int1__66960AE6] DEFAULT ((0)),
[int2] [int] NULL CONSTRAINT [DF__tng_field___int2__678A2F1F] DEFAULT ((0)),
[int3] [int] NULL CONSTRAINT [DF__tng_field___int3__687E5358] DEFAULT ((0)),
[int4] [int] NULL CONSTRAINT [DF__tng_field___int4__69727791] DEFAULT ((0)),
[int5] [int] NULL CONSTRAINT [DF__tng_field___int5__6A669BCA] DEFAULT ((0)),
[int6] [int] NULL CONSTRAINT [DF__tng_field___int6__6B5AC003] DEFAULT ((0)),
[int7] [int] NULL CONSTRAINT [DF__tng_field___int7__6C4EE43C] DEFAULT ((0)),
[int8] [int] NULL CONSTRAINT [DF__tng_field___int8__6D430875] DEFAULT ((0)),
[int9] [int] NULL CONSTRAINT [DF__tng_field___int9__6E372CAE] DEFAULT ((0)),
[int10] [int] NULL CONSTRAINT [DF__tng_field__int10__6F2B50E7] DEFAULT ((0)),
[int11] [int] NULL CONSTRAINT [DF__tng_field__int11__701F7520] DEFAULT ((0)),
[int12] [int] NULL CONSTRAINT [DF__tng_field__int12__71139959] DEFAULT ((0)),
[int13] [int] NULL CONSTRAINT [DF__tng_field__int13__7207BD92] DEFAULT ((0)),
[int14] [int] NULL CONSTRAINT [DF__tng_field__int14__72FBE1CB] DEFAULT ((0)),
[int15] [int] NULL CONSTRAINT [DF__tng_field__int15__73F00604] DEFAULT ((0)),
[int16] [int] NULL CONSTRAINT [DF__tng_field__int16__74E42A3D] DEFAULT ((0)),
[int17] [int] NULL CONSTRAINT [DF__tng_field__int17__75D84E76] DEFAULT ((0)),
[int18] [int] NULL CONSTRAINT [DF__tng_field__int18__76CC72AF] DEFAULT ((0)),
[int19] [int] NULL CONSTRAINT [DF__tng_field__int19__77C096E8] DEFAULT ((0)),
[int20] [int] NULL CONSTRAINT [DF__tng_field__int20__78B4BB21] DEFAULT ((0)),
[int21] [int] NULL CONSTRAINT [DF__tng_field__int21__79A8DF5A] DEFAULT ((0)),
[int22] [int] NULL CONSTRAINT [DF__tng_field__int22__7A9D0393] DEFAULT ((0)),
[int23] [int] NULL CONSTRAINT [DF__tng_field__int23__7B9127CC] DEFAULT ((0)),
[int24] [int] NULL CONSTRAINT [DF__tng_field__int24__7C854C05] DEFAULT ((0)),
[int25] [int] NULL CONSTRAINT [DF__tng_field__int25__7D79703E] DEFAULT ((0)),
[int26] [int] NULL CONSTRAINT [DF__tng_field__int26__7E6D9477] DEFAULT ((0)),
[int27] [int] NULL CONSTRAINT [DF__tng_field__int27__7F61B8B0] DEFAULT ((0)),
[int28] [int] NULL CONSTRAINT [DF__tng_field__int28__0055DCE9] DEFAULT ((0)),
[int29] [int] NULL CONSTRAINT [DF__tng_field__int29__014A0122] DEFAULT ((0)),
[int30] [int] NULL CONSTRAINT [DF__tng_field__int30__023E255B] DEFAULT ((0)),
[int31] [int] NULL CONSTRAINT [DF__tng_field__int31__03324994] DEFAULT ((0)),
[int32] [int] NULL CONSTRAINT [DF__tng_field__int32__04266DCD] DEFAULT ((0)),
[int33] [int] NULL CONSTRAINT [DF__tng_field__int33__051A9206] DEFAULT ((0)),
[int34] [int] NULL CONSTRAINT [DF__tng_field__int34__060EB63F] DEFAULT ((0)),
[int35] [int] NULL CONSTRAINT [DF__tng_field__int35__0702DA78] DEFAULT ((0)),
[int36] [int] NULL CONSTRAINT [DF__tng_field__int36__07F6FEB1] DEFAULT ((0)),
[int37] [int] NULL CONSTRAINT [DF__tng_field__int37__08EB22EA] DEFAULT ((0)),
[int38] [int] NULL CONSTRAINT [DF__tng_field__int38__09DF4723] DEFAULT ((0)),
[int39] [int] NULL CONSTRAINT [DF__tng_field__int39__0AD36B5C] DEFAULT ((0)),
[int40] [int] NULL CONSTRAINT [DF__tng_field__int40__0BC78F95] DEFAULT ((0)),
[int41] [int] NULL CONSTRAINT [DF__tng_field__int41__0CBBB3CE] DEFAULT ((0)),
[int42] [int] NULL CONSTRAINT [DF__tng_field__int42__0DAFD807] DEFAULT ((0)),
[int43] [int] NULL CONSTRAINT [DF__tng_field__int43__0EA3FC40] DEFAULT ((0)),
[int44] [int] NULL CONSTRAINT [DF__tng_field__int44__0F982079] DEFAULT ((0)),
[int45] [int] NULL CONSTRAINT [DF__tng_field__int45__108C44B2] DEFAULT ((0)),
[int46] [int] NULL CONSTRAINT [DF__tng_field__int46__118068EB] DEFAULT ((0)),
[int47] [int] NULL CONSTRAINT [DF__tng_field__int47__12748D24] DEFAULT ((0)),
[int48] [int] NULL CONSTRAINT [DF__tng_field__int48__1368B15D] DEFAULT ((0)),
[int49] [int] NULL CONSTRAINT [DF__tng_field__int49__145CD596] DEFAULT ((0)),
[int50] [int] NULL CONSTRAINT [DF__tng_field__int50__1550F9CF] DEFAULT ((0)),
[int51] [int] NULL CONSTRAINT [DF__tng_field__int51__16451E08] DEFAULT ((0)),
[int52] [int] NULL CONSTRAINT [DF__tng_field__int52__17394241] DEFAULT ((0)),
[int53] [int] NULL CONSTRAINT [DF__tng_field__int53__182D667A] DEFAULT ((0)),
[int54] [int] NULL CONSTRAINT [DF__tng_field__int54__19218AB3] DEFAULT ((0)),
[int55] [int] NULL CONSTRAINT [DF__tng_field__int55__1A15AEEC] DEFAULT ((0)),
[int56] [int] NULL CONSTRAINT [DF__tng_field__int56__1B09D325] DEFAULT ((0)),
[int57] [int] NULL CONSTRAINT [DF__tng_field__int57__1BFDF75E] DEFAULT ((0)),
[int58] [int] NULL CONSTRAINT [DF__tng_field__int58__1CF21B97] DEFAULT ((0)),
[int59] [int] NULL CONSTRAINT [DF__tng_field__int59__1DE63FD0] DEFAULT ((0)),
[int60] [int] NULL CONSTRAINT [DF__tng_field__int60__1EDA6409] DEFAULT ((0)),
[int61] [int] NULL CONSTRAINT [DF__tng_field__int61__1FCE8842] DEFAULT ((0)),
[int62] [int] NULL CONSTRAINT [DF__tng_field__int62__20C2AC7B] DEFAULT ((0)),
[int63] [int] NULL CONSTRAINT [DF__tng_field__int63__21B6D0B4] DEFAULT ((0)),
[int64] [int] NULL CONSTRAINT [DF__tng_field__int64__22AAF4ED] DEFAULT ((0)),
[int65] [int] NULL CONSTRAINT [DF__tng_field__int65__239F1926] DEFAULT ((0)),
[int66] [int] NULL CONSTRAINT [DF__tng_field__int66__24933D5F] DEFAULT ((0)),
[int67] [int] NULL CONSTRAINT [DF__tng_field__int67__25876198] DEFAULT ((0)),
[int68] [int] NULL CONSTRAINT [DF__tng_field__int68__267B85D1] DEFAULT ((0)),
[int69] [int] NULL CONSTRAINT [DF__tng_field__int69__276FAA0A] DEFAULT ((0)),
[int70] [int] NULL CONSTRAINT [DF__tng_field__int70__2863CE43] DEFAULT ((0)),
[int71] [int] NULL CONSTRAINT [DF__tng_field__int71__2957F27C] DEFAULT ((0)),
[int72] [int] NULL CONSTRAINT [DF__tng_field__int72__2A4C16B5] DEFAULT ((0)),
[int73] [int] NULL CONSTRAINT [DF__tng_field__int73__2B403AEE] DEFAULT ((0)),
[int74] [int] NULL CONSTRAINT [DF__tng_field__int74__2C345F27] DEFAULT ((0)),
[int75] [int] NULL CONSTRAINT [DF__tng_field__int75__2D288360] DEFAULT ((0)),
[int76] [int] NULL CONSTRAINT [DF__tng_field__int76__2E1CA799] DEFAULT ((0)),
[int77] [int] NULL CONSTRAINT [DF__tng_field__int77__2F10CBD2] DEFAULT ((0)),
[int78] [int] NULL CONSTRAINT [DF__tng_field__int78__3004F00B] DEFAULT ((0)),
[int79] [int] NULL CONSTRAINT [DF__tng_field__int79__30F91444] DEFAULT ((0)),
[int80] [int] NULL CONSTRAINT [DF__tng_field__int80__31ED387D] DEFAULT ((0)),
[int81] [int] NULL CONSTRAINT [DF__tng_field__int81__32E15CB6] DEFAULT ((0)),
[int82] [int] NULL CONSTRAINT [DF__tng_field__int82__33D580EF] DEFAULT ((0)),
[int83] [int] NULL CONSTRAINT [DF__tng_field__int83__34C9A528] DEFAULT ((0)),
[int84] [int] NULL CONSTRAINT [DF__tng_field__int84__35BDC961] DEFAULT ((0)),
[int85] [int] NULL CONSTRAINT [DF__tng_field__int85__36B1ED9A] DEFAULT ((0)),
[int86] [int] NULL CONSTRAINT [DF__tng_field__int86__37A611D3] DEFAULT ((0)),
[int87] [int] NULL CONSTRAINT [DF__tng_field__int87__389A360C] DEFAULT ((0)),
[int88] [int] NULL CONSTRAINT [DF__tng_field__int88__398E5A45] DEFAULT ((0)),
[int89] [int] NULL CONSTRAINT [DF__tng_field__int89__3A827E7E] DEFAULT ((0)),
[int90] [int] NULL CONSTRAINT [DF__tng_field__int90__3B76A2B7] DEFAULT ((0)),
[int91] [int] NULL CONSTRAINT [DF__tng_field__int91__3C6AC6F0] DEFAULT ((0)),
[int92] [int] NULL CONSTRAINT [DF__tng_field__int92__3D5EEB29] DEFAULT ((0)),
[int93] [int] NULL CONSTRAINT [DF__tng_field__int93__3E530F62] DEFAULT ((0)),
[int94] [int] NULL CONSTRAINT [DF__tng_field__int94__3F47339B] DEFAULT ((0)),
[int95] [int] NULL CONSTRAINT [DF__tng_field__int95__403B57D4] DEFAULT ((0)),
[int96] [int] NULL CONSTRAINT [DF__tng_field__int96__412F7C0D] DEFAULT ((0)),
[int97] [int] NULL CONSTRAINT [DF__tng_field__int97__4223A046] DEFAULT ((0)),
[int98] [int] NULL CONSTRAINT [DF__tng_field__int98__4317C47F] DEFAULT ((0)),
[int99] [int] NULL CONSTRAINT [DF__tng_field__int99__440BE8B8] DEFAULT ((0)),
[int100] [int] NULL CONSTRAINT [DF__tng_field__int10__45000CF1] DEFAULT ((0)),
[str1] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str1__45F4312A] DEFAULT (''),
[str2] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str2__46E85563] DEFAULT (''),
[str3] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str3__47DC799C] DEFAULT (''),
[str4] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str4__48D09DD5] DEFAULT (''),
[str5] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str5__49C4C20E] DEFAULT (''),
[str6] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str6__4AB8E647] DEFAULT (''),
[str7] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str7__4BAD0A80] DEFAULT (''),
[str8] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str8__4CA12EB9] DEFAULT (''),
[str9] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___str9__4D9552F2] DEFAULT (''),
[str10] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__str10__4E89772B] DEFAULT (''),
[str11] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__str11__4F7D9B64] DEFAULT (''),
[str12] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__str12__5071BF9D] DEFAULT (''),
[str13] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__str13__5165E3D6] DEFAULT ('')
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$tng_f_u00000c9400000000] ON [dbo].[tng_field_storage] ([uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_tng_field_storage] ON [dbo].[tng_field_storage] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_field_storage] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_field_storage] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_field_storage] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_field_storage] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_field_storage] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_field_storage] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_field_storage] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_field_storage] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_field_storage] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_field_storage] TO [wvuser]
GO
Uses
Used By