> For the complete documentation index, see [llms.txt](https://docs.snapfix.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.snapfix.com/engineering-reference/db/tables/tpri_room.md).

# tPri\_Room

{% hint style="info" %}
Generated from the staging database schema, with descriptions drafted by agents ([how to read these docs](https://docs.snapfix.com/how-to-read.md)). [Source on GitHub](https://github.com/snapfix/docs/blob/main/spec/db/tables/tPri_Room.md).
{% endhint %}

## Description

One room of a site, in a building, with its status, floor, type, priority, capacity and cleaning times. Housekeeping tasks are created per room.

<details>

<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE `tPri_Room` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) DEFAULT NULL,
  `uuid_tBuilding` varchar(255) DEFAULT NULL,
  `uuid_tParentRoomStatus` varchar(255) DEFAULT NULL,
  `uuid_tBuildingRoomStatus` varchar(255) DEFAULT NULL,
  `uuid_tBuildingRoomStatusMain` varchar(255) DEFAULT NULL,
  `uuid_tBuildingRoomStatusSecondary` varchar(255) DEFAULT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fLargeTextTitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fInstruction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fPriority` tinyint DEFAULT '0',
  `fPriorityLevel` int DEFAULT '0',
  `fImage` varchar(255) DEFAULT NULL,
  `fVideoHeader` tinyint DEFAULT '0',
  `enum_Origin` int DEFAULT '0',
  `fLat` double DEFAULT NULL,
  `fLng` double DEFAULT NULL,
  `fPriorityNumber` bigint DEFAULT '1000',
  `last_clean_ts` bigint DEFAULT NULL,
  `next_clean_ts` bigint DEFAULT NULL,
  `fInActive` tinyint DEFAULT '0',
  `fArchived` tinyint DEFAULT '0',
  `fVisible` tinyint DEFAULT '1',
  `fDeleted` tinyint DEFAULT '0',
  `fCreatedTs` bigint DEFAULT '0',
  `fModifiedTs` bigint DEFAULT '0',
  `fArchivedTs` bigint DEFAULT '0',
  `fDeletedTs` bigint DEFAULT '0',
  `fServerTs` bigint DEFAULT '0',
  `uuid_tUser_CreatedBy` varchar(255) DEFAULT '',
  `uuid_tUser_ModifiedBy` varchar(255) DEFAULT '',
  `excludeFromApi` tinyint DEFAULT '0',
  `excludeFromApiTs` bigint DEFAULT NULL,
  `uuid_tUser_ArchivedBy` varchar(255) DEFAULT '',
  `uuid_tUser_DeletedBy` varchar(255) DEFAULT '',
  `uuid_tRoomGuestStatus` varchar(255) DEFAULT NULL,
  `floor_number` int DEFAULT NULL,
  `guest_capacity` int DEFAULT NULL,
  `floor_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occupied` tinyint DEFAULT '0',
  `onHold` tinyint DEFAULT '0' COMMENT 'opera specific',
  `guestServiceCode` varchar(255) DEFAULT NULL COMMENT 'opera specific',
  `cleaningPriority` varchar(255) DEFAULT NULL COMMENT 'opera specific',
  `linenChangeRequired` tinyint DEFAULT '0' COMMENT 'opera specific',
  `suiteRoom` tinyint DEFAULT NULL COMMENT 'opera specific',
  `smokingPreference` varchar(255) DEFAULT NULL,
  `enum_RoomType` varchar(255) DEFAULT NULL,
  `fPermanentNotes` text,
  `fBedCount` int DEFAULT '1',
  `fReservationQueue` tinyint DEFAULT '0',
  `isPrivate` tinyint(1) DEFAULT '0',
  `isVirtual` tinyint(1) DEFAULT '0',
  `enum_RoomTypeShort` varchar(50) DEFAULT NULL,
  `doorlockID` varchar(255) DEFAULT NULL,
  `fCleaningDurationInSeconds_departure` int DEFAULT '1800',
  `fCleaningDurationInSeconds_stayover` int DEFAULT '1800',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uuid` (`uuid`) USING BTREE,
  KEY `fk_tPri_Room_createdbyuser` (`uuid_tUser_CreatedBy`),
  KEY `idx_room_building_deleted_name` (`uuid_tBuilding`,`fDeleted`,`fName`),
  CONSTRAINT `fk_room_building` FOREIGN KEY (`uuid_tBuilding`) REFERENCES `tPri_Building` (`uuid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_tPri_Room_createdbyuser` FOREIGN KEY (`uuid_tUser_CreatedBy`) REFERENCES `tPri_User` (`uuid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1
```

</details>

## Columns

| Name                                  | Type         | Default | Nullable | Extra Definition | Children                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Parents                                                                                     | Comment                                                                                                                                                                 |
| ------------------------------------- | ------------ | ------- | -------- | ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                                    | int          |         | false    | auto\_increment  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid                                  | varchar(255) |         | true     |                  | [cloudbeds\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/cloudbeds_roommapping.md) [comtrol\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/comtrol_roommapping.md) [guestline\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/guestline_roommapping.md) [hotsoft\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/hotsoft_roommapping.md) [jonaschorum\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/jonaschorum_roommapping.md) [opera\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/opera_roommapping.md) [stayntouch\_RoomMapping](https://docs.snapfix.com/engineering-reference/db/tables/stayntouch_roommapping.md) [tPri\_RoomUserAssigned](https://docs.snapfix.com/engineering-reference/db/tables/tpri_roomuserassigned.md) |                                                                                             |                                                                                                                                                                         |
| uuid\_tBuilding                       | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | [tPri\_Building](https://docs.snapfix.com/engineering-reference/db/tables/tpri_building.md) |                                                                                                                                                                         |
| uuid\_tParentRoomStatus               | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | The site room status (tPri\_ParentRoomStatus, which is empty); no foreign key.                                                                                          |
| uuid\_tBuildingRoomStatus             | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tBuildingRoomStatusMain         | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tBuildingRoomStatusSecondary    | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fName                                 | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fLargeTextTitle                       | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fDescription                          | text         |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fInstruction                          | text         |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fPriority                             | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fPriorityLevel                        | int          | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fImage                                | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fVideoHeader                          | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| enum\_Origin                          | int          | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | Where the room row came from: 0 unknown, 1 Android, 2 iOS, 3 web, 4 web admin, 5 email, 6 QR, 7 public API, 8 guest line, 9 schedule, 10 auto housekeeping, 11 XVENDOR. |
| fLat                                  | double       |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fLng                                  | double       |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fPriorityNumber                       | bigint       | 1000    | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| last\_clean\_ts                       | bigint       |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| next\_clean\_ts                       | bigint       |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fInActive                             | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fArchived                             | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fVisible                              | tinyint      | 1       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fDeleted                              | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fCreatedTs                            | bigint       | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fModifiedTs                           | bigint       | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fArchivedTs                           | bigint       | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fDeletedTs                            | bigint       | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fServerTs                             | bigint       | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tUser\_CreatedBy                | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | [tPri\_User](https://docs.snapfix.com/engineering-reference/db/tables/tpri_user.md)         |                                                                                                                                                                         |
| uuid\_tUser\_ModifiedBy               | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| excludeFromApi                        | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| excludeFromApiTs                      | bigint       |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tUser\_ArchivedBy               | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tUser\_DeletedBy                | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| uuid\_tRoomGuestStatus                | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | The room's booking record (tPri\_RoomGuestStatus); no foreign key.                                                                                                      |
| floor\_number                         | int          |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| guest\_capacity                       | int          |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| floor\_description                    | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| occupied                              | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| onHold                                | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | opera specific                                                                                                                                                          |
| guestServiceCode                      | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | opera specific                                                                                                                                                          |
| cleaningPriority                      | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | opera specific                                                                                                                                                          |
| linenChangeRequired                   | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | opera specific                                                                                                                                                          |
| suiteRoom                             | tinyint      |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | opera specific                                                                                                                                                          |
| smokingPreference                     | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| enum\_RoomType                        | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | Room type as free text, varying by site; there is no lookup table, and the Opera service puts it into housekeeping task text.                                           |
| fPermanentNotes                       | text         |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fBedCount                             | int          | 1       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fReservationQueue                     | tinyint      | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| isPrivate                             | tinyint(1)   | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| isVirtual                             | tinyint(1)   | 0       | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| enum\_RoomTypeShort                   | varchar(50)  |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| doorlockID                            | varchar(255) |         | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             |                                                                                                                                                                         |
| fCleaningDurationInSeconds\_departure | int          | 1800    | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | Planned cleaning time after a departure, in seconds (default 1800).                                                                                                     |
| fCleaningDurationInSeconds\_stayover  | int          | 1800    | true     |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                             | Planned cleaning time for a stayover, in seconds (default 1800).                                                                                                        |

## Viewpoints

| Name                                                                             | Definition                                                                                                                 |
| -------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------- |
| [rooms](https://docs.snapfix.com/engineering-reference/db/tables/viewpoint-7.md) | Buildings, sections, areas and rooms, room statuses, guests and beds, the users linked to rooms and areas, and their logs. |

## Constraints

| Name                          | Type        | Definition                                                        |
| ----------------------------- | ----------- | ----------------------------------------------------------------- |
| fk\_room\_building            | FOREIGN KEY | FOREIGN KEY (uuid\_tBuilding) REFERENCES tPri\_Building (uuid)    |
| fk\_tPri\_Room\_createdbyuser | FOREIGN KEY | FOREIGN KEY (uuid\_tUser\_CreatedBy) REFERENCES tPri\_User (uuid) |
| PRIMARY                       | PRIMARY KEY | PRIMARY KEY (id)                                                  |
| uuid                          | UNIQUE      | UNIQUE KEY uuid (uuid)                                            |

## Indexes

| Name                               | Definition                                                                            |
| ---------------------------------- | ------------------------------------------------------------------------------------- |
| fk\_tPri\_Room\_createdbyuser      | KEY fk\_tPri\_Room\_createdbyuser (uuid\_tUser\_CreatedBy) USING BTREE                |
| idx\_room\_building\_deleted\_name | KEY idx\_room\_building\_deleted\_name (uuid\_tBuilding, fDeleted, fName) USING BTREE |
| PRIMARY                            | PRIMARY KEY (id) USING BTREE                                                          |
| uuid                               | UNIQUE KEY uuid (uuid) USING BTREE                                                    |

## Relations

```mermaid
erDiagram

"cloudbeds_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"comtrol_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"guestline_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"hotsoft_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"jonaschorum_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"opera_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"stayntouch_RoomMapping" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"tPri_RoomUserAssigned" }o--o| "tPri_Room" : "FOREIGN KEY (uuid_tRoom) REFERENCES tPri_Room (uuid)"
"tPri_Room" }o--o| "tPri_Building" : "FOREIGN KEY (uuid_tBuilding) REFERENCES tPri_Building (uuid)"
"tPri_Room" }o--o| "tPri_User" : "FOREIGN KEY (uuid_tUser_CreatedBy) REFERENCES tPri_User (uuid)"

"tPri_Room" {
  int id PK
  varchar_255_ uuid
  varchar_255_ uuid_tBuilding FK
  varchar_255_ uuid_tUser_CreatedBy FK
}
"cloudbeds_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"comtrol_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"guestline_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"hotsoft_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"jonaschorum_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"opera_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"stayntouch_RoomMapping" {
  int id PK
  varchar_255_ uuid_tRoom FK
}
"tPri_RoomUserAssigned" {
  int id PK
  varchar_255_ uuid_tRoom FK
  varchar_255_ uuid_tUser FK
  varchar_255_ uuid_tUser_CreatedBy FK
}
"tPri_Building" {
  int id PK
  varchar_255_ uuid
  varchar_255_ uuid_tParent FK
  varchar_255_ uuid_tUser_CreatedBy FK
}
"tPri_User" {
  int id PK
  varchar_255_ uuid
  varchar_255_ uuid_tUser_CreatedBy FK
}
```

***

> Generated by [tbls](https://github.com/k1LoW/tbls)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.snapfix.com/engineering-reference/db/tables/tpri_room.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
