[dbo].[Vehicles]
| Property | Value |
|---|---|
| Collation | Latin1_General_CI_AS |
| Row Count (~) | 0 |
| Created | 10:45:54 PM February 26, 2017 |
| Last Modified | 10:45:54 PM February 26, 2017 |
| Key | Name | Data Type | Max Length (Bytes) | Allow Nulls | Identity |
|---|---|---|---|---|---|
 | VehicleID | int | 4 | False | 1 - 1 |
| VIN | nvarchar(50) | 100 | True | ||
| VehicleMake | nvarchar(50) | 100 | True | ||
| VehicleModel | nvarchar(50) | 100 | True | ||
| VehicleYear | int | 4 | True | ||
| PurchaseOdometer | int | 4 | True | ||
| CurrentOdometer | int | 4 | True | ||
| TypeStyle | nvarchar(255) | 510 | True | ||
| LocationID | int | 4 | True | ||
| DeptID | int | 4 | True | ||
| PurchaseDate | datetime | 8 | True | ||
| PurchaseCost | money | 8 | True | ||
| VendorID | int | 4 | True | ||
| InsurerID | int | 4 | True | ||
| VehicleColor | nvarchar(255) | 510 | True | ||
| VehicleLicenseNumber | nvarchar(255) | 510 | True | ||
| VehicleNotes | ntext | max | True | ||
| EmployeeDriverID | int | 4 | True | ||
| timestamp | timestamp | 8 | True |
| Key | Name | Key Columns | Unique |
|---|---|---|---|
| PK_Vehicles | VehicleID | True |
CREATE TABLE [dbo].[Vehicles]
(
[VehicleID] [int] NOT NULL IDENTITY(1, 1),
[VIN] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleMake] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleModel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleYear] [int] NULL,
[PurchaseOdometer] [int] NULL,
[CurrentOdometer] [int] NULL,
[TypeStyle] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[LocationID] [int] NULL,
[DeptID] [int] NULL,
[PurchaseDate] [datetime] NULL,
[PurchaseCost] [money] NULL,
[VendorID] [int] NULL,
[InsurerID] [int] NULL,
[VehicleColor] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[VehicleLicenseNumber] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[VehicleNotes] [ntext] COLLATE Latin1_General_CI_AS NULL,
[EmployeeDriverID] [int] NULL,
[timestamp] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Vehicles] ADD CONSTRAINT [PK_Vehicles] PRIMARY KEY CLUSTERED ([VehicleID]) ON [PRIMARY]
GO
(
[VehicleID] [int] NOT NULL IDENTITY(1, 1),
[VIN] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleMake] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleModel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[VehicleYear] [int] NULL,
[PurchaseOdometer] [int] NULL,
[CurrentOdometer] [int] NULL,
[TypeStyle] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[LocationID] [int] NULL,
[DeptID] [int] NULL,
[PurchaseDate] [datetime] NULL,
[PurchaseCost] [money] NULL,
[VendorID] [int] NULL,
[InsurerID] [int] NULL,
[VehicleColor] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[VehicleLicenseNumber] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL,
[VehicleNotes] [ntext] COLLATE Latin1_General_CI_AS NULL,
[EmployeeDriverID] [int] NULL,
[timestamp] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Vehicles] ADD CONSTRAINT [PK_Vehicles] PRIMARY KEY CLUSTERED ([VehicleID]) ON [PRIMARY]
GO