Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int4 | 10 | √ | null |
|
|
|||||
| RoomId | int4 | 10 | null |
|
|
||||||
| Name | varchar | 200 | null |
|
|
||||||
| Description | varchar | 2000 | √ | null |
|
|
|||||
| Category | varchar | 100 | √ | null |
|
|
|||||
| Notes | varchar | 2000 | √ | null |
|
|
|||||
| CreatedAtUtc | timestamptz | 35,6 | null |
|
|
||||||
| UpdatedAtUtc | timestamptz | 35,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Item | Primary key | Asc | Id |
| IX_Item_RoomId | Performance | Asc | RoomId |
Relationships
Close relationships within degrees of separation
