| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| facilityId | int(11) | YES | MUL | ||
| floorId | int(11) | YES | |||
| name | varchar(64) | NO | |||
| description | varchar(255) | NO | |||
| category | varchar(255) | NO | |||
| roomTag | varchar(255) | NO | |||
| roomUse | varchar(64) | NO | |||
| roomAccess | varchar(64) | NO | |||
| flooring | varchar(64) | NO | |||
| orgUnit | varchar(64) | NO | |||
| verified | varchar(64) | NO | |||
| stage | varchar(64) | NO | |||
| usableHeight | decimal(10,2) | NO | |||
| netArea | decimal(10,2) | NO | |||
| rentalArea | decimal(10,2) | NO | |||
| wallPerimeter | decimal(10,2) | NO | |||
| tagCoordinates | varchar(32) | NO | |||
| geometryData | text | NO | |||
| createdOn | varchar(20) | NO | |||
| createdBy | varchar(255) | NO |