Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
|||||
| layout_name | text | 2147483647 | null |
|
|
Display name of the floor plan; independent of room_location.name. |
|||||
| layout_file | text | 2147483647 | √ | null |
|
|
Public S3/CDN URL of the floor plan background image, generated through rpc.utility_gen_file_url using file_category floorplan_file. The URL is stored here only and must not be duplicated inside layout, because the S3 cleanup can only see this column. |
||||
| layout | jsonb | 2147483647 | √ | null |
|
|
Editor scene for the floor plan (rooms, positions, settings). Stored verbatim; the structure is owned by the frontend and is not validated here. |
||||
| location_id | int4 | 10 | √ | null |
|
|
Optional room_location binding. NULL means the layout is not assigned to a floor. At most one layout per location. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_room_layout | Primary key | Asc | id |
| unq_room_layout_location | Must be unique | Asc | location_id |
Relationships
Close relationships within degrees of separation
