Tables [dbo].[Equipment]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:20 AM Thursday, March 21, 2019
Last Modified1:02:02 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
EquipmentIDint4
False
EquipmentNumbervarchar(32)32
True
CustomerIDint4
False
SerialNumbervarchar(30)30
True
Makevarchar(64)64
True
Modelvarchar(64)64
True
Remarksvarchar(1024)1024
True
Locationvarchar(128)128
True
OfficeOpendatetime8
True
OfficeClosedatetime8
True
ModifyDatedatetime8
False
(getdate())
CreateDatedatetime8
False
(getdate())
IsActivebit1
False
((1))
Historybit1
False
CREATE TABLE [dbo].[Equipment]
(
[EquipmentID] [int] NOT NULL,
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Make] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OfficeOpen] [datetime] NULL,
[OfficeClose] [datetime] NULL,
[ModifyDate] [datetime] NOT NULL CONSTRAINT [DF_Equipment_ModifyDate] DEFAULT (getdate()),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Equipment_CreateDate] DEFAULT (getdate()),
[IsActive] [bit] NOT NULL CONSTRAINT [DF_Equipment_IsActive] DEFAULT ((1)),
[History] [bit] NOT NULL
) ON [PRIMARY]
GO