Tables [dbo].[UEROLLBK10220DATA]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created11:07:38 AM Wednesday, March 07, 2007
Last Modified11:07:38 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
UECHECKEDOUTint4
Yes
UECHECKEDOUTTIMEdatetime8
Yes
UEDBIDint4
No
UEMODTIMEdatetime8
Yes
UENUMEMPTYREQUIREDint4
Yes
UEPUBSTAGEint4
Yes
UEPUBTIMEdatetime8
Yes
UEASSETIDint4
Yes
UEAUTHORnvarchar(255)510
Yes
UEBASEnvarchar(255)510
Yes
UEBGCOLORnvarchar(255)510
Yes
UEBYTE_COUNTint4
Yes
UECREATED_BYnvarchar(255)510
Yes
UECREATION_DATEdatetime8
Yes
UEDATE_EXPIRESdatetime8
Yes
UEDESCRIPTIONnvarchar(1000)2000
Yes
UEFRAME_NUMBERint4
Yes
UEFRAME_RATEint4
Yes
UEHEIGHTint4
Yes
UEKEYWORDSnvarchar(255)510
Yes
UELAST_MODIFIED_BYnvarchar(255)510
Yes
UELOOPbit1
Yes
UEMAJOR_TYPEnvarchar(255)510
Yes
UEMENUbit1
Yes
UEMINOR_TYPEnvarchar(255)510
Yes
UENAMEnvarchar(255)510
Yes
UEPARENTIDint4
Yes
UEQUALITYnvarchar(255)510
Yes
UESALIGNnvarchar(255)510
Yes
UESCALEnvarchar(255)510
Yes
UESUBJECTnvarchar(255)510
Yes
UESWF_VERSIONint4
Yes
UETITLEnvarchar(255)510
Yes
UEVERCOMMENTnvarchar(1000)2000
Yes
UEVERSIONint4
Yes
UEWIDTHint4
Yes
UEWORKFLOW_IDint4
Yes
Permissions
TypeActionOwning Principal
GrantDeleteportaldba_group
GrantInsertportaldba_group
GrantSelectportaldba_group
GrantUpdateportaldba_group
SQL Script
CREATE TABLE [dbo].[UEROLLBK10220DATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEASSETID] [int] NULL,
[UEAUTHOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEBASE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEBGCOLOR] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEBYTE_COUNT] [int] NULL,
[UECREATED_BY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UECREATION_DATE] [datetime] NULL,
[UEDATE_EXPIRES] [datetime] NULL,
[UEDESCRIPTION] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFRAME_NUMBER] [int] NULL,
[UEFRAME_RATE] [int] NULL,
[UEHEIGHT] [int] NULL,
[UEKEYWORDS] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UELAST_MODIFIED_BY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UELOOP] [bit] NULL,
[UEMAJOR_TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEMENU] [bit] NULL,
[UEMINOR_TYPE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UENAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPARENTID] [int] NULL,
[UEQUALITY] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESALIGN] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESCALE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESUBJECT] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UESWF_VERSION] [int] NULL,
[UETITLE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEVERCOMMENT] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEVERSION] [int] NULL,
[UEWIDTH] [int] NULL,
[UEWORKFLOW_ID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[UEROLLBK10220DATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[UEROLLBK10220DATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[UEROLLBK10220DATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[UEROLLBK10220DATA] TO [portaldba_group]
GO
Uses