Tables [dbo].[Equip]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)345
Created4:57:07 PM Thursday, September 7, 2006
Last Modified9:17:27 AM Friday, November 8, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_EQUIP: PriKeyPriKeyint4
No
1 - 1
VINvarchar(20)20
Yes
Descripvarchar(20)20
No
CubicFTfloat8
Yes
Weightfloat8
Yes
EqNovarchar(12)12
No
Makevarchar(20)20
Yes
FuelIDvarchar(10)10
Yes
Yrvarchar(4)4
Yes
ActDatedatetime8
Yes
Modelvarchar(10)10
Yes
Deptvarchar(2)2
Yes
Foreign Keys FK_EQUIP_EqType: [dbo].[EqType].TypeTypeint4
No
IsLongDistsmallint2
Yes
EQLevelint4
Yes
Notesvarchar(max)max
Yes
TractorNovarchar(12)12
Yes
Foreign Keys FK_Equip_EqStatus: [dbo].[EqStatus].TractorStatusTractorStatusint4
Yes
Foreign Keys FK_Equip_EqStatus1: [dbo].[EqStatus].EqStatusEqStatusint4
No
IsLocalsmallint2
Yes
Lengthfloat8
Yes
Heightfloat8
Yes
RegisteredOwnervarchar(64)64
Yes
PurchasePricemoney8
Yes
Foreign Keys FK_Equip_CapacityBucket: [dbo].[CapacityBucket].CapacityBucketFIDIndexes IX_Equip_CapacityBucketFID: CapacityBucketFIDCapacityBucketFIDint4
Yes
HoursAvailableDailyint4
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_EQUIP: PriKeyPK_EQUIPPriKey
Yes
80
IX_Equip_CapacityBucketFIDCapacityBucketFID
Foreign Keys Foreign Keys
NameColumns
FK_Equip_CapacityBucketCapacityBucketFID->[dbo].[CapacityBucket].[CapacityBucketID]
FK_Equip_EqStatus1EqStatus->[dbo].[EqStatus].[StatusNo]
FK_Equip_EqStatusTractorStatus->[dbo].[EqStatus].[StatusNo]
FK_EQUIP_EqTypeType->[dbo].[EqType].[TypeNumber]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[Equip]
(
[PriKey] [int] NOT NULL IDENTITY(1, 1),
[VIN] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Descrip] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CubicFT] [float] NULL,
[Weight] [float] NULL,
[EqNo] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Make] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FuelID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Yr] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActDate] [datetime] NULL,
[Model] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dept] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [int] NOT NULL,
[IsLongDist] [smallint] NULL,
[EQLevel] [int] NULL,
[Notes] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TractorNo] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TractorStatus] [int] NULL,
[EqStatus] [int] NOT NULL,
[IsLocal] [smallint] NULL,
[Length] [float] NULL,
[Height] [float] NULL,
[RegisteredOwner] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PurchasePrice] [money] NULL,
[CapacityBucketFID] [int] NULL,
[HoursAvailableDaily] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Equip] ADD CONSTRAINT [PK_EQUIP] PRIMARY KEY CLUSTERED  ([PriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Equip_CapacityBucketFID] ON [dbo].[Equip] ([CapacityBucketFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Equip] ADD CONSTRAINT [FK_Equip_CapacityBucket] FOREIGN KEY ([CapacityBucketFID]) REFERENCES [dbo].[CapacityBucket] ([CapacityBucketID])
GO
ALTER TABLE [dbo].[Equip] ADD CONSTRAINT [FK_Equip_EqStatus1] FOREIGN KEY ([EqStatus]) REFERENCES [dbo].[EqStatus] ([StatusNo])
GO
ALTER TABLE [dbo].[Equip] ADD CONSTRAINT [FK_Equip_EqStatus] FOREIGN KEY ([TractorStatus]) REFERENCES [dbo].[EqStatus] ([StatusNo])
GO
ALTER TABLE [dbo].[Equip] ADD CONSTRAINT [FK_EQUIP_EqType] FOREIGN KEY ([Type]) REFERENCES [dbo].[EqType] ([TypeNumber])
GO
GRANT SELECT ON  [dbo].[Equip] TO [MssExec]
GRANT INSERT ON  [dbo].[Equip] TO [MssExec]
GRANT DELETE ON  [dbo].[Equip] TO [MssExec]
GRANT UPDATE ON  [dbo].[Equip] TO [MssExec]
GO
Uses
Used By