Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:57:20 AM Thursday, March 21, 2019 |
Last Modified | 1:02:02 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Default |
---|---|---|---|---|
EquipmentID | int | 4 | False | |
EquipmentNumber | varchar(32) | 32 | True | |
CustomerID | int | 4 | False | |
SerialNumber | varchar(30) | 30 | True | |
Make | varchar(64) | 64 | True | |
Model | varchar(64) | 64 | True | |
Remarks | varchar(1024) | 1024 | True | |
Location | varchar(128) | 128 | True | |
OfficeOpen | datetime | 8 | True | |
OfficeClose | datetime | 8 | True | |
ModifyDate | datetime | 8 | False | (getdate()) |
CreateDate | datetime | 8 | False | (getdate()) |
IsActive | bit | 1 | False | ((1)) |
History | bit | 1 | False |