Tables [dbo].[Sysuser]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)712
Created4:57:08 PM Thursday, September 7, 2006
Last Modified7:36:13 PM Thursday, August 29, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
EMPNOvarchar(16)16
No
Indexes IX_SysUser_FirstLastNames: FIRSTNAME\LASTNAMEIndexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_2: SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_1: SysUserID\STATUS\FIRSTNAME\LASTNAMELASTNAMEvarchar(26)26
No
Indexes IX_SysUser_FirstLastNames: FIRSTNAME\LASTNAMEIndexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_2: SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_1: SysUserID\STATUS\FIRSTNAME\LASTNAMEFIRSTNAMEvarchar(16)16
Yes
MIDNAMEvarchar(1)1
Yes
FUELPINvarchar(10)10
Yes
COMIDvarchar(10)10
Yes
HIREDATEdatetime8
Yes
EFFECTDATEdatetime8
Yes
Indexes IX_SysUser_EMAIL: EMAILEMAILvarchar(50)50
Yes
Foreign Keys FK_Sysuser_STATUS: [dbo].[Status].STATUSIndexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_1: SysUserID\STATUS\FIRSTNAME\LASTNAMESTATUSint4
No
LNHAULPCTsmallint2
Yes
DRVCLASSvarchar(20)20
Yes
DRVNOvarchar(15)15
Yes
VANNOvarchar(12)12
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMESUNDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEMONDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMETUESDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEWEDNESDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMETHURSDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEFRIDAYsmallint2
Yes
Indexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMESATURDAYsmallint2
Yes
COMMENTSvarchar(max)max
Yes
VoiceMailBoxNovarchar(5)5
Yes
Cluster Primary Key PK_Sysuser: SysUserIDIndexes IX_SysUser_DaysOfWeek: SUNDAY\MONDAY\TUESDAY\WEDNESDAY\THURSDAY\FRIDAY\SATURDAY\STATUS\SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_2: SysUserID\FIRSTNAME\LASTNAMEStatistics STATS_SysUser_1: SysUserID\STATUS\FIRSTNAME\LASTNAMESysUserIDint4
No
1 - 1
Foreign Keys FK_Sysuser_DriverTypes: [dbo].[DriverTypes].DTPriKeyDTPriKeyint4
Yes
Foreign Keys FK_Sysuser_Division: [dbo].[Division].DivisionFIDDivisionFIDint4
Yes
AdvanceCapTripmoney8
Yes
AdvanceCapOrdermoney8
Yes
AllowOverlappingServiceHoursbit1
No
((0))
Foreign Keys FK_Sysuser_CapacityBucket: [dbo].[CapacityBucket].CapacityBucketFIDIndexes IX_SysUser_CapacityBucketFID: CapacityBucketFIDCapacityBucketFIDint4
Yes
Foreign Keys FK_Sysuser_MssTimeZone: [dbo].[MssTimeZone].MssTimeZoneFIDMssTimeZoneFIDint4
Yes
Foreign Keys FK_Sysuser_XmlSystemTimeclock: [dbo].[XmlSystemTimeclock].XmlSystemTimeclockFidXmlSystemTimeclockFidint4
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_Sysuser: SysUserIDPK_SysuserSysUserID
Yes
80
IX_SysUser_CapacityBucketFIDCapacityBucketFID
IX_SysUser_DaysOfWeekSUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, STATUS, SysUserID, FIRSTNAME, LASTNAME
IX_SysUser_EMAILEMAIL
IX_SysUser_FirstLastNamesFIRSTNAME, LASTNAME
Statistics Statistics
NameColumns
STATS_SysUser_1SysUserID, STATUS, FIRSTNAME, LASTNAME
STATS_SysUser_2SysUserID, FIRSTNAME, LASTNAME
Foreign Keys Foreign Keys
NameColumns
FK_Sysuser_CapacityBucketCapacityBucketFID->[dbo].[CapacityBucket].[CapacityBucketID]
FK_Sysuser_DivisionDivisionFID->[dbo].[Division].[DivisionID]
FK_Sysuser_DriverTypesDTPriKey->[dbo].[DriverTypes].[DTPriKey]
FK_Sysuser_MssTimeZoneMssTimeZoneFID->[dbo].[MssTimeZone].[MssTimeZoneID]
FK_Sysuser_STATUSSTATUS->[dbo].[Status].[PriKey]
FK_Sysuser_XmlSystemTimeclockXmlSystemTimeclockFid->[dbo].[XmlSystemTimeclock].[XmlSystemTimeclockId]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[Sysuser]
(
[EMPNO] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LASTNAME] [varchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FIRSTNAME] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MIDNAME] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FUELPIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COMID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HIREDATE] [datetime] NULL,
[EFFECTDATE] [datetime] NULL,
[EMAIL] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATUS] [int] NOT NULL,
[LNHAULPCT] [smallint] NULL,
[DRVCLASS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRVNO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VANNO] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SUNDAY] [smallint] NULL,
[MONDAY] [smallint] NULL,
[TUESDAY] [smallint] NULL,
[WEDNESDAY] [smallint] NULL,
[THURSDAY] [smallint] NULL,
[FRIDAY] [smallint] NULL,
[SATURDAY] [smallint] NULL,
[COMMENTS] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VoiceMailBoxNo] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SysUserID] [int] NOT NULL IDENTITY(1, 1),
[DTPriKey] [int] NULL,
[DivisionFID] [int] NULL,
[AdvanceCapTrip] [money] NULL,
[AdvanceCapOrder] [money] NULL,
[AllowOverlappingServiceHours] [bit] NOT NULL CONSTRAINT [DF_Sysuser_AllowOverlappingServiceHours] DEFAULT ((0)),
[CapacityBucketFID] [int] NULL,
[MssTimeZoneFID] [int] NULL,
[XmlSystemTimeclockFid] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [PK_Sysuser] PRIMARY KEY CLUSTERED  ([SysUserID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SysUser_CapacityBucketFID] ON [dbo].[Sysuser] ([CapacityBucketFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SysUser_EMAIL] ON [dbo].[Sysuser] ([EMAIL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SysUser_FirstLastNames] ON [dbo].[Sysuser] ([FIRSTNAME], [LASTNAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SysUser_DaysOfWeek] ON [dbo].[Sysuser] ([STATUS], [SysUserID], [FIRSTNAME], [LASTNAME]) INCLUDE ([FRIDAY], [MONDAY], [SATURDAY], [SUNDAY], [THURSDAY], [TUESDAY], [WEDNESDAY]) ON [PRIMARY]
GO
CREATE STATISTICS [STATS_SysUser_2] ON [dbo].[Sysuser] ([SysUserID], [FIRSTNAME], [LASTNAME])
GO
CREATE STATISTICS [STATS_SysUser_1] ON [dbo].[Sysuser] ([SysUserID], [STATUS], [FIRSTNAME], [LASTNAME])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_CapacityBucket] FOREIGN KEY ([CapacityBucketFID]) REFERENCES [dbo].[CapacityBucket] ([CapacityBucketID])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_Division] FOREIGN KEY ([DivisionFID]) REFERENCES [dbo].[Division] ([DivisionID])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_DriverTypes] FOREIGN KEY ([DTPriKey]) REFERENCES [dbo].[DriverTypes] ([DTPriKey])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_MssTimeZone] FOREIGN KEY ([MssTimeZoneFID]) REFERENCES [dbo].[MssTimeZone] ([MssTimeZoneID])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_STATUS] FOREIGN KEY ([STATUS]) REFERENCES [dbo].[Status] ([PriKey])
GO
ALTER TABLE [dbo].[Sysuser] ADD CONSTRAINT [FK_Sysuser_XmlSystemTimeclock] FOREIGN KEY ([XmlSystemTimeclockFid]) REFERENCES [dbo].[XmlSystemTimeclock] ([XmlSystemTimeclockId])
GO
GRANT SELECT ON  [dbo].[Sysuser] TO [MssExec]
GRANT INSERT ON  [dbo].[Sysuser] TO [MssExec]
GRANT DELETE ON  [dbo].[Sysuser] TO [MssExec]
GRANT UPDATE ON  [dbo].[Sysuser] TO [MssExec]
GO
Uses
Used By