[dbo].[Equip]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	345
Created	4:57:07 PM Thursday, September 7, 2006
Last Modified	9:03:49 AM Friday, November 22, 2024

Name	Data Type	Max Length (Bytes)	Identity
PriKey	int	4	1 - 1
VIN	varchar(20)	20
Descrip	varchar(20)	20
CubicFT	float	8
Weight	float	8
EqNo	varchar(12)	12
Make	varchar(20)	20
FuelID	varchar(10)	10
Yr	varchar(4)	4
ActDate	datetime	8
Model	varchar(10)	10
Dept	varchar(2)	2
Type	int	4
IsLongDist	smallint	2
EQLevel	int	4
Notes	varchar(max)	max
TractorNo	varchar(12)	12
TractorStatus	int	4
EqStatus	int	4
IsLocal	smallint	2
Length	float	8
Height	float	8
RegisteredOwner	varchar(64)	64
PurchasePrice	money	8
CapacityBucketFID	int	4
HoursAvailableDaily	int	4

	Name	Columns	Unique	Fill Factor
	PK_EQUIP	PriKey		80
	IX_Equip_CapacityBucketFID	CapacityBucketFID

Name	Columns
FK_Equip_CapacityBucket	CapacityBucketFID->[dbo].[CapacityBucket].[CapacityBucketID]
FK_Equip_EqStatus1	EqStatus->[dbo].[EqStatus].[StatusNo]
FK_Equip_EqStatus	TractorStatus->[dbo].[EqStatus].[StatusNo]
FK_EQUIP_EqType	Type->[dbo].[EqType].[TypeNumber]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

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