DATA
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| facilityId | int(11) | YES | MUL | ||
| floorId | int(11) | YES | |||
| spaceId | int(11) | YES | |||
| typeId | int(11) | YES | |||
| name | varchar(128) | NO | |||
| description | varchar(255) | NO | |||
| cadType | varchar(32) | NO | |||
| tagNumber | varchar(255) | NO | |||
| stage | varchar(64) | NO | |||
| extSystem | varchar(255) | NO | |||
| extObject | varchar(255) | NO | |||
| extIdentifier | varchar(255) | NO | |||
| extLocation | varchar(255) | NO | |||
| serialNumber | varchar(255) | NO | |||
| productionYear | varchar(10) | NO | |||
| installationDate | varchar(10) | NO | |||
| warrantyStartDate | varchar(20) | NO | |||
| batchReference | varchar(255) | NO | |||
| barCode | varchar(255) | YES | |||
| qrCode | varchar(255) | YES | |||
| assetIdentifier | varchar(255) | NO | |||
| length | decimal(10,2) | NO | |||
| width | decimal(10,2) | NO | |||
| height | decimal(10,2) | NO | |||
| area | decimal(10,2) | NO | |||
| quantity | decimal(10,2) | NO | |||
| color | varchar(255) | NO | |||
| penIndex | int(11) | NO | |||
| coordinates | varchar(255) | NO | |||
| createdOn | varchar(20) | NO | |||
| createdBy | varchar(255) | NO |