| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| Id | varchar(36) | NO | PRI | ||
| ProjectId | varchar(36) | NO | |||
| Category | varchar(255) | NO | |||
| AssetType | varchar(255) | NO | |||
| Name | varchar(128) | YES | UNI | ||
| TagNumber | varchar(255) | NO | |||
| Description | varchar(255) | NO | |||
| Catalog | varchar(64) | NO | |||
| Manufacturer | varchar(255) | NO | |||
| ModelNumber | varchar(255) | NO | |||
| WarrantyGuarantorParts | varchar(255) | NO | |||
| WarrantyDurationParts | varchar(255) | NO | |||
| WarrantyGuarantorLabor | varchar(255) | NO | |||
| WarrantyDurationLabor | varchar(255) | NO | |||
| WarrantyDurationUnit | varchar(255) | NO | |||
| ExtSystem | varchar(255) | NO | |||
| ExtObject | varchar(255) | NO | |||
| ExtIdentifier | varchar(255) | NO | |||
| ReplacementCost | varchar(255) | NO | |||
| ExpectedLife | varchar(255) | NO | |||
| DurationUnit | varchar(255) | NO | |||
| WarrantyDescription | varchar(255) | NO | |||
| NominalLength | decimal(10,2) | NO | |||
| NominalWidth | decimal(10,2) | NO | |||
| NominalHeight | decimal(10,2) | NO | |||
| NominalElevation | decimal(10,2) | NO | |||
| ModelReference | varchar(255) | NO | |||
| Shape | varchar(255) | NO | |||
| Size | varchar(255) | NO | |||
| Color | varchar(255) | NO | |||
| Finish | varchar(255) | NO | |||
| Grade | varchar(255) | NO | |||
| Material | varchar(255) | NO | |||
| Constituents | text | NO | |||
| Features | varchar(255) | NO | |||
| AccessibilityPerformance | varchar(255) | NO | |||
| CodePerformance | varchar(255) | NO | |||
| SustainabilityPerformance | varchar(255) | NO | |||
| Coordinates | text | NO | |||
| TagView | varchar(8) | NO | |||
| CreatedOn | varchar(20) | NO | |||
| CreatedBy | varchar(255) | NO |