| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| facilityId | int(11) | YES | MUL | ||
| name | varchar(32) | NO | |||
| description | varchar(255) | NO | |||
| category | varchar(255) | NO | |||
| elevation | decimal(10,2) | NO | |||
| height | decimal(10,2) | NO | |||
| level | int(11) | NO | |||
| csvName | varchar(64) | NO | |||
| ifcBuildingStoreyList | varchar(255) | NO | |||
| extIdentifier | varchar(6) | NO | |||
| createdOn | varchar(20) | NO | |||
| createdBy | varchar(255) | NO |